sql didn't finish running, sth went wrong

Question

hi all ,

I really need your help. I connect to oracle db with input tool which contains a string of sql:

when select count(*) from table A, the result is : 48067.

when select * from table A, the input tool is always 0% and won't stop.

i executed the sql in db, it works but the rows of result was 6878, count result was 6878.

does anyone have any idea what's wrong with the db?

cyg3003 · Answer

for input tool in alteryx,

when select * from table A where rownum <= 10, the input tool will run properly and give the result.