ODBC connection to BIG data : throwing 'No Columns Returned' error

toxicboy

Hello,

I have a HQL code , which runs on HUE platform also runs on my colleague`s ALTERYX desktop when they try running it.

However when I try to run it it throws the error. Apart from this I am able to run other Workflows which have custom queries etc.

Could anyone help on this

apathetichell

your driver and your colleague's driver could have different configurations which are effecting how the SQL is formatted when sent via ODBC. I would also say to see 1) is this an access issue - (my hunch is no - because it runs on your HUE platform - this might not be no if you are using different login mechanisms there). 2) Is there something small off in your HQL (like an extra quote or comma) 3) can you limit the results and see if this is a memory/timeout issue?

Not much of an HQL person - and I only use HIVE with Databricks.