Lumira & Hadoop

[Joe_Peters]

I'm trying to add a new dataset from Hadoop.  I enter the HDFS server and port, but after hitting Connect, it spins for about 10 minutes before failing with "Unable to connect to (my server)". 

I was able to successfully connect to it using IDT and the JDBC connector.

Any idea what's wrong, or even how to find out the actual problem?

[varunanand · Accepted solution]

Hi Joe,

There are couple of ways to access the data from Hadoop. I prefer using the SQL on Hadoop option.

We have the following options for Apache Hadoop and Cloudera,

The port usually for Apache Hadoop is 10000 and for Cloudera is 21050. Please check your host and user ID as well.

Thank you,

Varun Anand

[Joe_Peters · Accepted solution]

Interesting... I don't see those same options:

I know that the server/port/username/password are working; I was able to successfully connect in IDT.

[varunanand · Accepted solution]

Hi Joe,

I am using the option 'SQL on Hadoop' and not 'Connect to Hadoop' as shown below,

Please let me know if there are any questions or comments.

Thank you,

Varun Anand

[Joe_Peters · Accepted solution]

Thank you, Varun.  It works for me too using "SQL on Hadoop", but not "Connect to Hadoop".  Is there any difference between the two modes?

[varunanand · Accepted solution]

Hi Joe,

I'm not aware of any differences between the methods of acquisition.

Thank you,

Varun Anand

[TammyPowlas]

Are you using any drivers, like Simba, to connect to Hadoop with Lumira?

[Joe_Peters]

I do have the Hortonworks ODBC driver installed, but I assume that's not in play here.