hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Sears <>
Subject Re: ODBC-hiveserver2 question
Date Sat, 24 Feb 2018 03:37:51 GMT
<!DOCTYPE html>
    <meta charset="UTF-8">
</head><body><pre><em><span id="mce_4_start" style="overflow:hidden;line-height:0px">Add
JAR works with HDFS, though perhaps not with ODBC drivers.<br><br></span>ADD
JAR hdfs://&#60;namenode_hostname&#62;:8020/hive_jars/hive-contrib-2.1.1.jar </em>should
work (depending on your nn port and confirm this file exists)<em><br>Alternative
syntax<br>ADD JAR hdfs:/hive_jars/hive-contrib-2.1.1.jar<br></em><br>The
ODBC driver could be having an issue with the forward slashes.<br><br>The guaranteed
method is to create a permanent association by adding the JAR to hive/lib or hadoop/lib on
hiveserver2 node.<br>Copying to hive-client/auxlib/ and restarting Hive is an option.<br>Adding
following property to is an option<br><span class="pln">HIVE_AUX_JARS_PATH</span><span
class="pun">=</span><br><br>There may be a trace function for your ODBC
driver to see a more detailed error.  <br><br>Some ODBC drivers may not support
the ADD JAR syntax.<br><br>cheers,<br>Andrew</pre><blockquote type="cite">On
February 23, 2018 at 3:27 PM J&#246;rn Franke &#60;; wrote:
<br> <br><div>&#160;<br></div><div>Add jar works only
with local files on the Hive server.</div><div><br>On 23. Feb 2018, at 21:08,
Andy Srine &#60; <a href=""></a>&#62;
wrote: <br> <br></div><blockquote type="cite"><div><div dir="ltr">Team,<div><br></div><div>Is
ADD JAR from HDFS (ADD JAR hdfs:///hive_jars/hive-contrib-2.1.1.jar;) supported in hiveserver2
via an ODBC connection?&#160;</div><div><br></div><div>Some
relevant points:</div><div><ul><li>I am able to do it in Hive 2.1.1
via JDBC (beeline), but not via an ODBC client.<br></li><li>In Hive 1.2.1,
I can add a jar from the local node, but not a JAR on HDFS.<br></li><li>Some
old blogs online say HiveServer2 doesn&#39;t support &#34;ADD JAR &#34; period.
But thats not what I experience via beeline.</li></ul></div><div>Let
me know your thoughts and experiences.</div><div><div><br></div><div
class="ox-2d06069796-gmail_signature"><div dir="ltr">Thanks,<div>Andy</div><div><br></div></div></div></div></div></div></blockquote></blockquote><p

View raw message