How to add jar files for Hue in Cloudera?

Question

I'm running an SQL query on a JSON serde table. It's working in the Hive CLI, but it's failing in Hue with the error:

Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

I guess it's due to the missing jar file; any idea how to add the jar file hive-hcatalog-core-1.2.1.jar for Hue?

Answer 1

Run ADD JAR hive-hcatalog-core-1.2.1.jar in hue before your query this thing will be present till your current secession persists.

Answer 2

Place your jar in HDFS and add same path by using ADD JAR hdfs:///user/hive/lib/hive-hcatalog-core-1.2.1.jar ;

Answer 3

For the benefit of others, who might face same issue either for this particular jar "hive-hcatalog-core-1.2.1.jar" or any udf jar:

In the HUE - Query Editor, run the following command:

add jar hdfs:/hive-hcatalog-core-1.2.1.jar;   

Please note single quotes is not required as is the case with Hive CLI

Answer 4

Exact command cloudera gave is ADD JAR {{lib_dir}}/hive/lib/hive-contrib.jar;

1)I am unable to find hive/lib directory on CDH 5

The {{lib_dir}} on CDH installed environments for Hive would either be /usr/lib/hive/ or /opt/cloudera/parcels/CDH/lib/hive/ (depending on packages or parcels being in use).

this is the way to add jar in cloudera

for this you have to change to supper user by use this command

      SUDO SU

it will change to supper user