Is your problem solved? *Thanks & Regards,*
*Srinivas T* On Wed, Feb 25, 2015 at 4:17 PM, Srinivas Thunga <srinivas.thu...@gmail.com> wrote: > 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.shw...@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.thu...@gmail.com> wrote: ----- >> To: "user@hive.apache.org" <user@hive.apache.org> >> From: Srinivas Thunga <srinivas.thu...@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.shw...@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.shw...@tcs.com> wrote: ----- >>> To: user@hive.apache.org >>> From: Jadhav Shweta <jadhav.shw...@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.thu...@gmail.com> wrote: ----- >>> To: "user@hive.apache.org" <user@hive.apache.org> >>> From: Srinivas Thunga <srinivas.thu...@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.shw...@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.thu...@gmail.com> wrote: ----- >>>> To: "user@hive.apache.org" <user@hive.apache.org> >>>> From: Srinivas Thunga <srinivas.thu...@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.shw...@tcs.com> >>>> wrote: >>>> >>>>> Hi >>>>> >>>>> I am running simple select query >>>>> >>>>> select * from table; >>>>> >>>>> thanks >>>>> Shweta Jadhav >>>>> >>>>> >>>>> >>>>> -----Srinivas Thunga <srinivas.thu...@gmail.com> wrote: ----- >>>>> To: "user@hive.apache.org" <user@hive.apache.org> >>>>> From: Srinivas Thunga <srinivas.thu...@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.shw...@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 >>>>>> >>>>>> >>>>> >>>> >>> >> >
