Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error connecting to hive database using HortonWork hive odbc driver

avatar
New Contributor

Error is as follows:

[Hortonworks][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

3 REPLIES 3

avatar
Master Mentor

@Hiren Gala

The errors suggest that your cluster is probably SSL enables so you would need extra configuration for the ODBC to work .Look at the attached screenshot, of course, you will need the CA, Private key.

odbc-ssl.png

avatar
New Contributor

It is showing me the below error after enabling ssl

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

avatar
Master Mentor

@Hiren Gala

Can you give te screenshot and parameters used?

The following are possible causes of this issue:

1. Incorrect port and/or Hive Service defined in connection.
2. Network issues.
3. The Hive server is not started.

Please revert