Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Connect to Hadoop from Alteryx


Dear Community Members,


I am trying to establish connectivity to Hadoop from within Alteryx. I have been able to setup a DSN using the Simba Hive ODBC driver and that DSN enables connectivity to Hadoop on a stand-alone basis. 


The DSN when invoked in Microsoft Excel enables retrieval of data from a Hadoop table. However, when I use the same DSN via an ODBC connection in Alteryx, I am not able to query a table. 


It seems from the error message that Alteryx is able to connect to Hadoop. However, the connection doesn't let me query a table in Hadoop.


I have pasted below the screenshot of the error message from Alteryx Designer app. 


Error Message.PNGError Message


Please revert if you have any questions or need any more details.


Best Regards,

Ashish Bhavnani


I have seen that message if the table name is called incorrectly.  sometimes ` is required in places where it is not required when querying from other places. 


Hi @TDGuy,


Thanks for your reply.


I checked the table name and it's name is being correctly used in Alteryx. 


Did you mean that I should write the query as select count(*) from DB1`TAB1?





It is picky about tick marks.  The format that I tend to use is `DB1`.`TAB1`  or just `TAB1`.