Hello,
Thank you for your response, however I was just running one column when it was not giving any results I thought I should check if it's the issue with the column so I duplicated the column and ran the first row to crosscheck that's all.
I tried re-running, re starting and logging in again into clay as well.
The column worked for first 5k rows and then for the last stretch it started acting up