You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Igor Kravzov <ig...@gmail.com> on 2016/07/06 21:13:07 UTC
hive.aux.jars.path question
Hi guys,
HDP 2.4.2 distribution
I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path
using hive.aux.jars.path property. Added it to custom hive-site.xml
Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for the
property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
But when I try to create table I get the following error
org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error
while compiling statement: FAILED: SemanticException Cannot find class
'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
What is the right way to specify the pat and where should I place the JAR?
Thanks in advance.
Re: hive.aux.jars.path question
Posted by Fan Xu <fa...@dataguise.com>.
Yes, it is a workaround not a fix.
________________________________
From: Igor Kravzov <ig...@gmail.com>
Sent: Wednesday, July 6, 2016 3:02:44 PM
To: user@hive.apache.org
Subject: Re: hive.aux.jars.path question
It worked. Thanks. Still not sure if it is right way to do it.
On Wed, Jul 6, 2016 at 5:45 PM, Fan Xu <fa...@dataguise.com>> wrote:
Yes, we need to restart hiveserver in Ambari
________________________________
From: Igor Kravzov <ig...@gmail.com>>
Sent: Wednesday, July 6, 2016 2:36:41 PM
To: user@hive.apache.org<ma...@hive.apache.org>
Subject: Re: hive.aux.jars.path question
Just copied. Didn't help. Do I need to restart nodes?
On Wed, Jul 6, 2016 at 5:20 PM, Fan Xu <fa...@dataguise.com>> wrote:
Got similar issues.
I have tried to point hive.aux.jars.path to a local/hdfs locations, none of them works.
I could not find a way to make hive.aux.jars.path work, would it be a bug?
The only way I made it work is to add my jar to {hive_home}/lib/
Thanks,
Fan
________________________________
From: Igor Kravzov <ig...@gmail.com>>
Sent: Wednesday, July 6, 2016 2:13:07 PM
To: user@hive.apache.org<ma...@hive.apache.org>
Subject: hive.aux.jars.path question
Hi guys,
HDP 2.4.2 distribution
I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path using hive.aux.jars.path property. Added it to custom hive-site.xml
Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
But when I try to create table I get the following error
org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
What is the right way to specify the pat and where should I place the JAR?
Thanks in advance.
Re: hive.aux.jars.path question
Posted by Igor Kravzov <ig...@gmail.com>.
It worked. Thanks. Still not sure if it is right way to do it.
On Wed, Jul 6, 2016 at 5:45 PM, Fan Xu <fa...@dataguise.com> wrote:
> Yes, we need to restart hiveserver in Ambari
> ------------------------------
> *From:* Igor Kravzov <ig...@gmail.com>
> *Sent:* Wednesday, July 6, 2016 2:36:41 PM
> *To:* user@hive.apache.org
> *Subject:* Re: hive.aux.jars.path question
>
> Just copied. Didn't help. Do I need to restart nodes?
>
> On Wed, Jul 6, 2016 at 5:20 PM, Fan Xu <fa...@dataguise.com> wrote:
>
>> Got similar issues.
>>
>> I have tried to point hive.aux.jars.path to a local/hdfs locations,
>> none of them works.
>>
>> I could not find a way to make hive.aux.jars.path work, would it be a
>> bug?
>>
>> The only way I made it work is to add my jar to {hive_home}/lib/
>>
>>
>> Thanks,
>>
>>
>> Fan
>>
>> ------------------------------
>> *From:* Igor Kravzov <ig...@gmail.com>
>> *Sent:* Wednesday, July 6, 2016 2:13:07 PM
>> *To:* user@hive.apache.org
>> *Subject:* hive.aux.jars.path question
>>
>> Hi guys,
>>
>> HDP 2.4.2 distribution
>>
>> I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path
>> using hive.aux.jars.path property. Added it to custom hive-site.xml
>>
>> Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for
>> the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
>>
>> But when I try to create table I get the following error
>>
>> org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
>>
>>
>> What is the right way to specify the pat and where should I place the JAR?
>>
>> Thanks in advance.
>>
>
>
Re: hive.aux.jars.path question
Posted by Fan Xu <fa...@dataguise.com>.
Yes, we need to restart hiveserver in Ambari
________________________________
From: Igor Kravzov <ig...@gmail.com>
Sent: Wednesday, July 6, 2016 2:36:41 PM
To: user@hive.apache.org
Subject: Re: hive.aux.jars.path question
Just copied. Didn't help. Do I need to restart nodes?
On Wed, Jul 6, 2016 at 5:20 PM, Fan Xu <fa...@dataguise.com>> wrote:
Got similar issues.
I have tried to point hive.aux.jars.path to a local/hdfs locations, none of them works.
I could not find a way to make hive.aux.jars.path work, would it be a bug?
The only way I made it work is to add my jar to {hive_home}/lib/
Thanks,
Fan
________________________________
From: Igor Kravzov <ig...@gmail.com>>
Sent: Wednesday, July 6, 2016 2:13:07 PM
To: user@hive.apache.org<ma...@hive.apache.org>
Subject: hive.aux.jars.path question
Hi guys,
HDP 2.4.2 distribution
I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path using hive.aux.jars.path property. Added it to custom hive-site.xml
Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
But when I try to create table I get the following error
org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
What is the right way to specify the pat and where should I place the JAR?
Thanks in advance.
Re: hive.aux.jars.path question
Posted by Igor Kravzov <ig...@gmail.com>.
Just copied. Didn't help. Do I need to restart nodes?
On Wed, Jul 6, 2016 at 5:20 PM, Fan Xu <fa...@dataguise.com> wrote:
> Got similar issues.
>
> I have tried to point hive.aux.jars.path to a local/hdfs locations, none
> of them works.
>
> I could not find a way to make hive.aux.jars.path work, would it be a
> bug?
>
> The only way I made it work is to add my jar to {hive_home}/lib/
>
>
> Thanks,
>
>
> Fan
>
> ------------------------------
> *From:* Igor Kravzov <ig...@gmail.com>
> *Sent:* Wednesday, July 6, 2016 2:13:07 PM
> *To:* user@hive.apache.org
> *Subject:* hive.aux.jars.path question
>
> Hi guys,
>
> HDP 2.4.2 distribution
>
> I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path
> using hive.aux.jars.path property. Added it to custom hive-site.xml
>
> Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for
> the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
>
> But when I try to create table I get the following error
>
> org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
>
>
> What is the right way to specify the pat and where should I place the JAR?
>
> Thanks in advance.
>
Re: hive.aux.jars.path question
Posted by Fan Xu <fa...@dataguise.com>.
Got similar issues.
I have tried to point hive.aux.jars.path to a local/hdfs locations, none of them works.
I could not find a way to make hive.aux.jars.path work, would it be a bug?
The only way I made it work is to add my jar to {hive_home}/lib/
Thanks,
Fan
________________________________
From: Igor Kravzov <ig...@gmail.com>
Sent: Wednesday, July 6, 2016 2:13:07 PM
To: user@hive.apache.org
Subject: hive.aux.jars.path question
Hi guys,
HDP 2.4.2 distribution
I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path using hive.aux.jars.path property. Added it to custom hive-site.xml
Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar
But when I try to create table I get the following error
org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: SemanticException Cannot find class 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS]
What is the right way to specify the pat and where should I place the JAR?
Thanks in advance.