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 <[email protected]> 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 <[email protected]> wrote: ----- > To: "[email protected]" <[email protected]> > From: Srinivas Thunga <[email protected]> > 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 <[email protected]> > 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 <[email protected]> wrote: ----- >> To: [email protected] >> From: Jadhav Shweta <[email protected]> >> 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 <[email protected]> wrote: ----- >> To: "[email protected]" <[email protected]> >> From: Srinivas Thunga <[email protected]> >> 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 <[email protected]> >> 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 <[email protected]> wrote: ----- >>> To: "[email protected]" <[email protected]> >>> From: Srinivas Thunga <[email protected]> >>> 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 <[email protected]> >>> wrote: >>> >>>> Hi >>>> >>>> I am running simple select query >>>> >>>> select * from table; >>>> >>>> thanks >>>> Shweta Jadhav >>>> >>>> >>>> >>>> -----Srinivas Thunga <[email protected]> wrote: ----- >>>> To: "[email protected]" <[email protected]> >>>> From: Srinivas Thunga <[email protected]> >>>> 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 <[email protected]> >>>> 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 >>>>> >>>>> >>>> >>> >> >
