You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Shiang Luong <sh...@openx.com> on 2014/09/23 07:28:30 UTC
Querying A table which JDBC
Hi All,
I'm new to hive. I'm having some problems querying an hive table with
JDBC. It fails when it is trying to run an map reduce job. It can't seem
to find the serde jar file. When I query it through the command line it
works fine. Anyone have any hints on how I can get it working with JDBC?
Thanks in advance.
Shiang
Re: Querying A table which JDBC
Posted by Nitin Pawar <ni...@gmail.com>.
can you share hiveserver2 heap size and your table size ?
On Tue, Sep 23, 2014 at 11:31 PM, Shiang Luong <sh...@openx.com>
wrote:
> Ritesh thanks for your response.
>
> Where do I download and place the jars?
> Do you mean on the hive server itself? I believe the files are already
> there since I can query the same table via command line.
> It feels like the serde is not being sent along with the query? or I need
> to get the jar sent out to the distributed cache?
> I even tried running:
>
> myStatment.execute("add JAR /usr/lib/hive/extra_libs/test.jar");
>
> That didn't work. I'm not sure just shooting out thoughts.
>
> Thanks,
>
> Shiang
>
> On Mon, Sep 22, 2014 at 10:52 PM, Ritesh Kumar Singh <
> riteshoneinamillion@gmail.com> wrote:
>
>> try downloading the jar files and put it in the libraries folder
>>
>> On Tue, Sep 23, 2014 at 10:58 AM, Shiang Luong <sh...@openx.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> I'm new to hive. I'm having some problems querying an hive table with
>>> JDBC. It fails when it is trying to run an map reduce job. It can't seem
>>> to find the serde jar file. When I query it through the command line it
>>> works fine. Anyone have any hints on how I can get it working with JDBC?
>>>
>>> Thanks in advance.
>>>
>>> Shiang
>>>
>>
>>
>
>
> --
> Shiang Luong
> Software Engineer in Test | OpenX
> 888 East Walnut Street, 2nd Floor | Pasadena, CA 91101
> o: +1 (626) 466-1141 x0000 | m: +1 (626) 512-2165 | shiang.luong@openx.com
> OpenX ranked No. 7 in Forbes’ America’s Most Promising Companies
>
--
Nitin Pawar
Re: Querying A table which JDBC
Posted by Shiang Luong <sh...@openx.com>.
Ritesh thanks for your response.
Where do I download and place the jars?
Do you mean on the hive server itself? I believe the files are already
there since I can query the same table via command line.
It feels like the serde is not being sent along with the query? or I need
to get the jar sent out to the distributed cache?
I even tried running:
myStatment.execute("add JAR /usr/lib/hive/extra_libs/test.jar");
That didn't work. I'm not sure just shooting out thoughts.
Thanks,
Shiang
On Mon, Sep 22, 2014 at 10:52 PM, Ritesh Kumar Singh <
riteshoneinamillion@gmail.com> wrote:
> try downloading the jar files and put it in the libraries folder
>
> On Tue, Sep 23, 2014 at 10:58 AM, Shiang Luong <sh...@openx.com>
> wrote:
>
>> Hi All,
>>
>> I'm new to hive. I'm having some problems querying an hive table with
>> JDBC. It fails when it is trying to run an map reduce job. It can't seem
>> to find the serde jar file. When I query it through the command line it
>> works fine. Anyone have any hints on how I can get it working with JDBC?
>>
>> Thanks in advance.
>>
>> Shiang
>>
>
>
--
Shiang Luong
Software Engineer in Test | OpenX
888 East Walnut Street, 2nd Floor | Pasadena, CA 91101
o: +1 (626) 466-1141 x0000 | m: +1 (626) 512-2165 | shiang.luong@openx.com
OpenX ranked No. 7 in Forbes’ America’s Most Promising Companies
Re: Querying A table which JDBC
Posted by Ritesh Kumar Singh <ri...@gmail.com>.
try downloading the jar files and put it in the libraries folder
On Tue, Sep 23, 2014 at 10:58 AM, Shiang Luong <sh...@openx.com>
wrote:
> Hi All,
>
> I'm new to hive. I'm having some problems querying an hive table with
> JDBC. It fails when it is trying to run an map reduce job. It can't seem
> to find the serde jar file. When I query it through the command line it
> works fine. Anyone have any hints on how I can get it working with JDBC?
>
> Thanks in advance.
>
> Shiang
>