ADD JAR hdfs://<namenode_hostname>:8020/hive_jars/hive-contrib-2.1.1.jar should work (depending on your nn port and confirm this file exists)
ADD JAR hdfs:/hive_jars/hive-contrib-2.1.1.jar
The ODBC driver could be having an issue with the forward slashes.
The guaranteed method is to create a permanent association by adding the JAR to hive/lib or hadoop/lib on hiveserver2 node.
Copying to hive-client/auxlib/ and restarting Hive is an option.
Adding following property to Hive-env.sh is an option
There may be a trace function for your ODBC driver to see a more detailed error.
Some ODBC drivers may not support the ADD JAR syntax.
On February 23, 2018 at 3:27 PM Jörn Franke <jornfra...@gmail.com> wrote:
Add jar works only with local files on the Hive server.
On 23. Feb 2018, at 21:08, Andy Srine < andy.sr...@gmail.com> wrote:
Team,Is ADD JAR from HDFS (ADD JAR hdfs:///hive_jars/hive-contrib-2.1.1.jar;) supported in hiveserver2 via an ODBC connection?Some relevant points:
- I am able to do it in Hive 2.1.1 via JDBC (beeline), but not via an ODBC client.
- In Hive 1.2.1, I can add a jar from the local node, but not a JAR on HDFS.
- Some old blogs online say HiveServer2 doesn't support "ADD JAR " period. But thats not what I experience via beeline.Let me know your thoughts and experiences.Thanks,Andy