Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

New Contributor

Folks,

I need to connect a mac client to Hive in HDInsights over Azure. Installed Mac ODBC Drivers from [1], and use [2] to configure the ODBC driver. However, the test is failing.

[Hortonworks][HiveODBC](22) Error from the server:connect() failed: Operation Timed Out.

[1] http://hortonworks.com/hdp/addons/

[2] https://azure.microsoft.com/en-us/documentation/ar...

7 REPLIES 7

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

@rmian

It looks like connectivity issues. Operation timed out means that you could not reach the server.

telnet ip or host 10000 can be run to test

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

New Contributor

I can telnet/ssh into the port. It is 1433 for Hive over HDInsight.

sh-3.2# telnet xxx.database.windows.net 1433

Trying aaa.bbb.ccc.107... Connected to xxx.database.windows.net.

Escape character is '^]'.

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

My bad on port

its 443

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

@rmian

https://azure.microsoft.com/en-us/documentation/ar...

this worked for me

HW11326:Downloads nsabharwal$ telnet xxxx.azurehdinsight.net 443

Trying xxxxxx.

Connected to xxxx.cloudapp.net.

Escape character is '^]'.

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

New Contributor

This works for me too BUT on client's WINDOWS machine. :-)

I need to connect my Mac to Hive in HDInsights over Azure

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

New Contributor

This works for me too BUT on client's WINDOWS machine. :-)

I need to connect my Mac to Hive in HDInsights over Azure

Re: ODBC connection unsuccessful in Mac when connecting to Hive in HDInsight over Azure!

Mentor

@rmian are you still having issues with this? Can you accept best answer or provide your own solution?