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.