Support Questions

Find answers, ask questions, and share your expertise

Hortonworks Hive ODBC Driver DSN setup

avatar
Expert 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

avatar
Super Guru
@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...

avatar
Super Guru

@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

avatar
Expert Contributor

@ Jitendra

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

avatar
Expert Contributor

@ devers,

I am using Win7. Any suggestion?

avatar
Rising Star

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?

avatar
Rising Star

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

avatar
Expert Contributor

@devers.

PFA dsn-setup.jpg

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

avatar
Rising Star

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

Did you try maria_dev/maria_dev for name and password?

avatar
Expert 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 ?