hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinivas Thunga <srinivas.thu...@gmail.com>
Subject Re: ERROR OutOfMemoryError: Java heap space
Date Wed, 25 Feb 2015 10:47:46 GMT
Hi,

You can set fetch size based certain datatype like blob, image, etc

statement.setFetchSize(1000);

Try this.


*Thanks & Regards,*

*Srinivas T*

On Wed, Feb 25, 2015 at 4:10 PM, Jadhav Shweta <jadhav.shweta@tcs.com>
wrote:

> Query is working fine if i have small data set in same table.
> But its throwing error for large data set
>
> Thanks
> Shweta Jadhav
>
>
>
> -----Srinivas Thunga <srinivas.thunga@gmail.com> wrote: -----
> To: "user@hive.apache.org" <user@hive.apache.org>
> From: Srinivas Thunga <srinivas.thunga@gmail.com>
> Date: 02/25/2015 03:45PM
>
> Subject: Re: ERROR OutOfMemoryError: Java heap space
>
> not required. Make sure there will not be unnecessary looping in your code
>
> *Thanks & Regards,*
>
> *Srinivas T*
>
> On Wed, Feb 25, 2015 at 2:58 PM, Jadhav Shweta <jadhav.shweta@tcs.com>
> wrote:
>
>> Do I need to increase HADOOP_HEAPSIZE
>> I haven't set it.
>> I have cluster with 4 machines each having 8GB ram.
>> I read somewhere that we should mention auth=noSasl in hive jdbc url. Is
>> it necessary
>>
>> Thanks
>> Shweta Jadhav
>>
>>
>>
>> -----Jadhav Shweta <jadhav.shweta@tcs.com> wrote: -----
>> To: user@hive.apache.org
>> From: Jadhav Shweta <jadhav.shweta@tcs.com>
>> Date: 02/25/2015 02:54PM
>>
>> Subject: Re: ERROR OutOfMemoryError: Java heap space
>>
>> I am running the query using spring batch framework.
>>
>> Thanks
>> Shweta Jadhav
>>
>> -----Srinivas Thunga <srinivas.thunga@gmail.com> wrote: -----
>> To: "user@hive.apache.org" <user@hive.apache.org>
>> From: Srinivas Thunga <srinivas.thunga@gmail.com>
>> Date: 02/25/2015 02:43PM
>> Subject: Re: ERROR OutOfMemoryError: Java heap space
>>
>> Hi,
>>
>> Might be problem in your code.
>>
>> Generally it happens when there are unnecessary looping.
>>
>> Please check your java code.
>>
>> *Thanks & Regards,*
>>
>> *Srinivas T*
>>
>> On Wed, Feb 25, 2015 at 2:38 PM, Jadhav Shweta <jadhav.shweta@tcs.com>
>> wrote:
>>
>>> Hi
>>>
>>> I have installed apache hive 0.13.0.
>>> I have configured metastore as postgres db.
>>> Query is working fine in beeline command line interface but giving Heap
>>> space error while executing using JDBC java client.
>>>
>>> Thanks
>>> Shweta Jadhav
>>>
>>> -----Srinivas Thunga <srinivas.thunga@gmail.com> wrote: -----
>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>> From: Srinivas Thunga <srinivas.thunga@gmail.com>
>>> Date: 02/25/2015 02:32PM
>>> Subject: Re: ERROR OutOfMemoryError: Java heap space
>>>
>>>
>>> Hi,
>>>
>>> Let me know how you configured Hive?
>>>
>>> R u using cloudera?
>>>
>>> If you are installed Hive separately then have you configured Metastore?
>>>
>>>
>>>
>>> *Thanks & Regards,*
>>>
>>> *Srinivas T*
>>>
>>> On Wed, Feb 25, 2015 at 2:27 PM, Jadhav Shweta <jadhav.shweta@tcs.com>
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> I am running simple select query
>>>>
>>>> select * from table;
>>>>
>>>> thanks
>>>> Shweta Jadhav
>>>>
>>>>
>>>>
>>>> -----Srinivas Thunga <srinivas.thunga@gmail.com> wrote: -----
>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>> From: Srinivas Thunga <srinivas.thunga@gmail.com>
>>>> Date: 02/25/2015 01:09PM
>>>> Subject: Re:
>>>>
>>>> Hi,
>>>>
>>>> Can  you place the query as well which you are trying?
>>>>
>>>>
>>>>
>>>> *Thanks & Regards,*
>>>>
>>>> *Srinivas T*
>>>>
>>>> On Wed, Feb 25, 2015 at 1:02 PM, Jadhav Shweta <jadhav.shweta@tcs.com>
>>>> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> I am trying to run hive query
>>>>> Its getting executed from beeline interface
>>>>> but its throwing
>>>>>
>>>>>    java.lang.OutOfMemoryError: Java heap space
>>>>>
>>>>>
>>>>>    error when connecting using jdbc.
>>>>>
>>>>>
>>>>>    I am using hive 0.13.0 version and hiveserver2.
>>>>>
>>>>>
>>>>>    which parameters i need to configure for the same.
>>>>>
>>>>> thanks
>>>>>
>>>>> Shweta Jadhav
>>>>>
>>>>> =====-----=====-----=====
>>>>> Notice: The information contained in this e-mail
>>>>> message and/or attachments to it may contain
>>>>> confidential or privileged information. If you are
>>>>> not the intended recipient, any dissemination, use,
>>>>> review, distribution, printing or copying of the
>>>>> information contained in this e-mail message
>>>>> and/or attachments to it are strictly prohibited. If
>>>>> you have received this communication in error,
>>>>> please notify us by reply e-mail or telephone and
>>>>> immediately and permanently delete the message
>>>>> and any attachments. Thank you
>>>>>
>>>>>
>>>>
>>>
>>
>

Mime
View raw message