Yeah, this is my code.

Properties prop = new Properties();
prop.put(USER, user);
prop.put(PASSWORD, password);
prop.put("hiveconf:hive.aux.jars.path", auxJarPath);

ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(url, prop);


Hopes it will be helpful.

2015-12-29 19:49 GMT+08:00 Lee S <sle...@gmail.com>:

> @Heng, I didn't try to set the variable directly in beeline shell.
> Actually,
>
> I programmed with hive jdbc to create table with self defined serde.
>
> And I need to put the serde jar in the hive.aux.jars.path,in case I can
> find it directly,
>
> not through beeline.
>
>
>
> On Tue, Dec 29, 2015 at 5:38 PM, Heng Chen <heng.chen.1...@gmail.com>
> wrote:
>
>> Have you try to set hive_aux_jars_path explicitly in beeline shell?
>> I found this problem too when i use hive-jdbc in my project,  and i set
>> hive_aux_jars_path explicitly in my code.
>>
>> Hopes it will be helpful.
>>
>>
>> 2015-12-29 15:58 GMT+08:00 Peyman Mohajerian <mohaj...@gmail.com>:
>>
>>> Maybe you need to also add:
>>>
>>> HIVE_AUX_JARS_PATH = /path/to/JAR
>>>
>>> e.g.: 
>>> http://www.cloudera.com/content/www/en-us/documentation/archive/manager/4-x/4-8-0/Cloudera-Manager-Managing-Clusters/cmmc_hive_udf.html
>>>
>>>
>>> On Mon, Dec 28, 2015 at 11:52 PM, Lee S <sle...@gmail.com> wrote:
>>>
>>>> Sorry, the <property> is <value>, forgive my wrong typing. Anybody can
>>>> help?
>>>>
>>>>
>>>> On Tue, Dec 29, 2015 at 3:50 PM, Lee S <sle...@gmail.com> wrote:
>>>>
>>>>> Hi all:
>>>>>    I have a serde jar written by myself to deserialize some kind of
>>>>> data.
>>>>>
>>>>>    I put the jar in the host of hiverserver and set the
>>>>> *hive.aux.jars.path* property in hive-site.xml.
>>>>>
>>>>>   Then I use beeline connecting to hiveserver2, create a table with
>>>>> the serde class, but it said
>>>>>
>>>>>    class not found exception.  why? anybody can help?
>>>>>
>>>>>    <property>
>>>>>      <name>hive.aux.jars.path</name>
>>>>>      <property>file:///root/serde.jar</property>
>>>>>     </property>
>>>>>
>>>>
>>>>
>>>
>>
>

Reply via email to