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.

Adding auxlib to hive server 2 using CM express 5.1.1

Adding auxlib to hive server 2 using CM express 5.1.1

New Contributor

Hi,

 
We are trying to add aux jar (containing serdes and udfs) to our HIVESERVER 2 service. 
 
We are able to do that to a hive cli not running in server mode. We basically change the hive-site.xml to include our aux-jar using the CM. 
 
However this doesn't affect the Hiveserver2 service, despite the fact the service's hive-site.xml is configured properly 
 
As a workaround to this problem we had to change the hive.sh script as follows:
 
Changing the last line there from 
exec $HIVE_HOME/bin/hive  --config $CONF_DIR --service "$@" 
to
exec $HIVE_HOME/bin/hive  --config $CONF_DIR --service "$@" --hiveconf hive.aux.jars.path=file:///....
 
Can CM add this configuration always to this line,
 
Thanks. 
3 REPLIES 3

Re: Adding auxlib to hive server 2 using CM express 5.1.1

Cloudera Employee

Hi guydo,

 

Did you try using the "Hive Auxiliary JARs Directory" configuration in CM ?

 

This config allows you to specify a directory containing aux jars, for both Hive CLI and HiveServer2 services.

 

thanks,

Mohit 

Re: Adding auxlib to hive server 2 using CM express 5.1.1

Explorer
Where is this option located?

Re: Adding auxlib to hive server 2 using CM express 5.1.1

Cloudera Employee

Hi charles_tay,

 

This configuration is located in "Service-Wide > Advanced" section under Hive service configuration.

 

thanks,

Mohit