11-26-2014 03:25 PM
Just insalled the latest version of HIVE ODBC driver (2.5.12) and created a linked server in Microsoft SQL Server 2014.
Tried a simple select * from table, or even one integer column such as select ID from table, but the queries failed with this
OLE DB provider "MSDASQL" for linked server "CLOUDERA-HIVE" returned message "[Cloudera][HiveODBC] (35) Error from Hive: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.".
Msg 7320, Level 16, State 2, Line 4
Cannot execute the query "SELECT "Tbl1002"."row_id" "Col1004" FROM "HIVE"."default"."test_table" "Tbl1002"" against OLE DB provider "MSDASQL" for linked server "CLOUDERA-HIVE".
PS. Tried to enable Fast SQL Prepare, but didnt help.
Tried to enable Use Async exec - didnt help.
Native query - dont work on MS SQL.
01-07-2015 11:13 PM
Hi Thomas ,
Sorry for posting this question here .I hope you can solve my issue .
I have installed cloudera CDH4.7.1 A 3 cluster.I am trying to load data from hive to oracle database using Oracle loader for hadoop.I have integrated hadoop with Oracle Data Integrater ODI .For trigering OLH from ODI we have knowledge module File-Hive to Oracle (OLH-OSCH).
I am getting following error:
01-08-2015 12:44 AM
Hi Visahl, no idea what would be the problem, in my case the HIVE connector simply did not read the metadata correctly.
I am sorry, but I cannot help you
01-09-2015 12:15 PM
Hi Thomas ,the issue has been solved.My aim was to integrate Oracle Data Integrater with hadoop for loading data from Hive to Oracle database using OLH(oracle loader for hadoop.If you want to know the solution ,I can share with you.
08-04-2015 11:16 PM
Hi Tomas, have you solve this problem yet ? I have encountered the same problem through using ODBC. And I have tried Microsoft Driver for Hive and Cloudera Driver for Apache Hive but both of them didn't work.
04-06-2016 10:54 AM
Hi i had the same issue trying to query hiveserver2 from tableau 9.1, i resolved it by configuring the ODBC driver as user hdfs, i logged on to the hiveserver2 as user hdfs and i was able to execute the queries