- I am able to connect to My Hive using Hortonworks hive odbc driver. We are using ODBC connection we have ODBC connection string in our configuration.
- while executing query sometimes we are getting 'Message: ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'java.io.IOException: java.lang.RuntimeException: serious problem'
- I googled and found we can use 'hive.fetch.task.conversion=none' for resolving this we tried this still we are facing same problem.
- We are using Hive 0.14
Asked
Active
Viewed 296 times
-1
Sameer Karkande
- 1
- 2
-
I am new to HIve, Is there any other driver for connecting to Hive (Data lake) which is performance effective? – Sameer Karkande Nov 17 '16 at 05:23
2 Answers
0
- Finally Found the issue, the property that i was using incorrect "hive.fetch.task.conversion=none" (This can be used in Jdbc connection)
- For Horton Works ODBC driver we have to use "ssp_hive.fetch.task.conversion=none" in connection string
- I created DSN and used it in SSIS project to get the connection string for ODBC
Sameer Karkande
- 1
- 2
0
FYI, I also saw this exact error when trying to use beeline on Hive 1.2.1.
SET hive.fetch.task.conversion = none;
This did solve it on beeline.
Cory Brickner
- 11
- 2
-
thanks Cory i found the solution i was aware of this property, it was working in Jdbc and not in odbc we need to apply diff property for Horton works odbc connection string "ssp_hive.fetch.task.conversion=none" – Sameer Karkande Dec 05 '16 at 06:15