ODBC Connection to Kylo Sandbox

[Bimal Mehta]

Hi,

I am using the Hortonworks Kylo Sandbox on my machine. Its a great tool (Kylo) and eased a lot of my integration work

I have an additional requirement where I need to create dashboards using Tableau on top of Hive tables that I created using Kylo Feeds.

I am trying to set up an ODBC connection to Hive server. I am passing the IP address that I see in Ambari dashboard and using port 10000 to connect to HIVE tables.

However by DNS connection fails the test and gives an error 100060. I am using the Ambari login credentials (admin/admin) for this.

What am I doing wrong here? How do I make this ODBC connection to Sandbox work?

Thanks

B

[Jagrut Sharma]

Bimal - You will need to download the Hortonworks Hive ODBC driver via [1]. Install it for your platform, and then use Tableau's 'Hortonworks Hadoop Hive' connection. The following settings should work - I tested locally on a Mac.

Server: localhost OR sandbox.kylo.io

port: 10000

type: HiveServer2

Authentication: Username

Username: hive

If you are facing DNS issues, make sure that the machine running Tableau is able to connect to the Sandbox via the name specified for 'server' in connection settings. Check any firewall or port restrictions that may be present.

[1] https://hortonworks.com/downloads/#addons

Thanks.

--

Jagrut

[Bimal Mehta]

Thanks for your reply. I did exactly the same thing you mentioned but am still getting the below error when I use localhost. I also used 127.0.0.1 instead of localhost with no success.

FAILED!

[Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10061.

When I use sandbox.kylo.io I get the below error

FAILED!

[Hortonworks][Hardy] (34) Error from server: Could not resolve host for client socket.

I am on a Windows machine and I am getting the error while setting up my DSN. I tried both 32 bit and 64 bit Hive ODBC drivers.

What firewall/port restrictions do I need to check?

Thanks

Bimal

[Jagrut Sharma]

Bimal - To support sandbox.kylo.io, you may need to make an entry in your hosts file for Windows.

For firewall/ports, you can check that connection from Tableau machine -> Kylo sandbox allows port 10000 to pass through since that is used for the connection.

Thanks.

--

Jagrut

[Bimal Mehta]

Thanks Jagrut,

Both Kylo Sandbox and Tableau are on the same machine.

Where do I check that  Kylo sandbox allows port 10000 to pass through? Can you provide some more details on that.

[Jagrut Sharma]

Bimal - If you have Kylo sandbox, check that port 10000 is open by going to Settings->Network -> Port forwarding. There should be an entry with:

protocol: TCP

host port: 10000

guest port: 10000

In addition to this if you have any other firewall mechanism running on Windows, you may need to check that also.

Thanks.

--

Jagrut

[Bimal Mehta]

Thank You Jagrut.

That was the problem, the entry was missing in the Sandbox. The Port was not open on the VM.

Appreciate your quick and reliable response on this.

Regards

Bimal