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.
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:
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
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.
I am having the same issues, clould you please provide the setps, what you did to slove the problem.
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.
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