Add Custom JAR Files to Hive

check if auxlib directory is present in /usr/hdp/<version_number>/hive/auxlib if not, 
Repeat for all Hive client nodes, the HiveServer2 node and the Hive Metastore node
Move the custom SerDe JAR file (e.g. hivexmlserde- into that directory on 
all the above-mentioned nodes
Restart all Hive services
# ps -ef | grep hive
in hive server2 and check if the above jar is added.
For temporarily adding:
hive > ADD JAR /usr/hdp/current/hive-server2/lib/json-serde-1.3.7-jar-with-dependencies.jar;
Then run the hive command

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *