Support Questions
Find answers, ask questions, and share your expertise

Hortonworks Hive ODBC Driver DSN setup

Hortonworks Hive ODBC Driver DSN setup

Contributor

Hi

While doing DSN setup I am getting below error. Please suggest.

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

10 REPLIES 10

Re: Hortonworks Hive ODBC Driver DSN setup

@Tech Guy

Can you please try to follow below URL and see if that resolve the issue?.

http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-w...

Re: Hortonworks Hive ODBC Driver DSN setup

@Tech Guy

This can be occur due to many issues like incorrect port or firewall, may be hive service is not up and running or table permission see this post https://community.hortonworks.com/questions/10192/facing-issue-with-odbc-connection.html

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

@ Jitendra

I tried above link previously but got the error mentioned in my thread.

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

@ devers,

I am using Win7. Any suggestion?

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

Can you share a screenshot of what your DSN setup looks like? Or maybe post a bit more details?

Alternatively, do you have any other ODBC connections, or is this the first one you have tried?

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

If you are on a Mac with "El Capitan" (10.11) and run into this, you are likely dealing with a platform specific issue.

The driver and installation does work with 10.10 along with Office 365 (2016)

Possible issue with ODBC Hive and El Capitan

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

@devers.

PFA dsn-setup.jpg

I tried with user name hive and hue but same error.

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

I don't believe the password for hive is "hue"

Did you try maria_dev/maria_dev for name and password?

Re: Hortonworks Hive ODBC Driver DSN setup

Contributor

yes. I used hue since it is mentioned in below instruction link

http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-w...

Is there any way to check detailed log which can give me more information about the error ?