Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive ODBC query fails, works in Hive shell though - hive.aux.jars.path?

Highlighted

Hive ODBC query fails, works in Hive shell though - hive.aux.jars.path?

New Contributor

Dear all,

 

I am unable to perform queries via Hive ODBC although the same queries do work well via Hive shell.

 

I receive the following error message:

[Cloudera][HiveODBC] (35) Error from Hive: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask'.

 

 

I am using CDH 4.4 VM and the latest ODBC drivers from Cloudera.

 

The Hive tables are visible so the connection should work.

 

Edit: I found out that the attribute

mapred.cache.files

is different for ODBC jobs:

hdfs://localhost.localdomain:8020/tmp/hive-hive-cloudera/hive_2014-03-18_10-14-40_784_8989485848295602678-5/-mr-10003/7121ff89-364e-46a9-83d3-c4e6d5ad3ae1#HIVE_PLAN7121ff89-364e-46a9-83d3-c4e6d5ad3ae1,hdfs://localhost.localdomain:8020/user/cloudera/.staging/job_201403171258_0016/libjars/hive-builtins-0.10.0-cdh4.4.0.jar

When started via shell:

hdfs://localhost.localdomain:8020/tmp/hive-cloudera/hive_2014-03-18_10-17-07_871_1425206083686056374-1/-mr-10003/54e88d0e-d27d-4690-8aaa-8c216dfa4a0d#HIVE_PLAN54e88d0e-d27d-4690-8aaa-8c216dfa4a0d,hdfs://localhost.localdomain:8020/user/cloudera/.staging/job_201403171258_0018/libjars/hive-builtins-0.10.0-cdh4.4.0.jar,hdfs://localhost.localdomain:8020/user/cloudera/.staging/job_201403171258_0018/libjars/hbase.jar,hdfs://localhost.localdomain:8020/user/cloudera/.staging/job_201403171258_0018/libjars/hive-hbase-handler-0.10.0-cdh4.4.0.jar,hdfs://localhost.localdomain:8020/user/cloudera/.staging/job_201403171258_0018/libjars/zookeeper.jar

This jar is crucial for the success of a job:

hive-hbase-handler-0.10.0-cdh4.4.0.jar

  

It seems as if ODBC MapReduce jobs are not affected by

hive.aux.jars.path

 although shell MapReduce jobs are.

 

Is there a way to solve this issue?

 

Thanks in advance.

 

Best regards,

Fabian

 

PS: A detailed structure of the table can be found here:

http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-Failed-to-parse-view-definition-...

1 REPLY 1

Re: Hive ODBC query fails, works in Hive shell though - hive.aux.jars.path?

Master Guru
If you've made changes to the hive.aux.jars.path, you may want to duplicate that change set in CM across all available hive-site.xml safety valves (i.e. both client and server ones - former affects CLI, latter affects HS2, i.e. JDBC/ODBC).