community
cancel
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

Asteroid

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

Meteor

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. 

Asteroid

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?

 

Regards,

Ashish

Meteor

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

Labels