I was able to fix this issue by doing concat(string1, ' ', string2) instead of concat(string1, string2) Not sure how adding a separator helps but it solved the problem
On Thu, Jun 28, 2018 at 11:55 AM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > Could this cause an issue if one of the field in concat function has large > text ? > > On Thu, Jun 28, 2018 at 11:10 AM, Nitin Pawar <nitinpawar...@gmail.com> > wrote: > >> Hi Khurram, >> >> This is a parquet table. >> all the columns in the table are string columns (even date column is >> stored as string) >> >> I am currently using drill 1.13.0. Same query used to work fine on drill >> 1.8.0 >> >> Thanks, >> Nitin >> >> On Thu, Jun 28, 2018 at 12:17 AM, Khurram Faraaz <kfar...@mapr.com> >> wrote: >> >>> Hi Nitin, >>> >>> Can you please share the description of the table (i.e. column types) ? >>> Is this a parquet table or JSON ? >>> Also please share the version of Drill and the drillbit.log >>> >>> Thanks, >>> Khurram >>> >>> On Wed, Jun 27, 2018 at 9:45 AM, Nitin Pawar <nitinpawar...@gmail.com> >>> wrote: >>> >>> > here are the details >>> > >>> > query: >>> > >>> > select Account Account,Name Name,CONCAT(DateString , string2) >>> > Merged_String from dfs.tmp.`/nitin/` t1 >>> > >>> > There is no custom UDF in this query; >>> > >>> > >>> > >>> > On Wed, Jun 27, 2018 at 2:22 PM, Nitin Pawar <nitinpawar...@gmail.com> >>> > wrote: >>> > >>> > > Hi Vitalii, >>> > > >>> > > Thanks for the description. >>> > > I will try to get the log for this but as this is happening in >>> production >>> > > and drill log gets overwritten in our case very fast. >>> > > >>> > > Also I will get the query for the same while getting the log >>> > > >>> > > I will get the details and update the thread >>> > > >>> > > Thanks, >>> > > Nitin >>> > > >>> > > On Tue, Jun 26, 2018 at 7:32 PM, Vitalii Diravka < >>> > > vitalii.dira...@gmail.com> wrote: >>> > > >>> > >> Hi Nitin, >>> > >> >>> > >> It happens in the process of reallocation of the size of buffers in >>> the >>> > >> memory. >>> > >> It isn't a User Exception, so it looks like a bug, if you get it in >>> some >>> > >> existed plugin. >>> > >> But to say you exactly, please describe your case. What kind of >>> query >>> > did >>> > >> you perform, any UDF's, which data source? >>> > >> Also logs can help. >>> > >> >>> > >> Thanks. >>> > >> >>> > >> Kind regards >>> > >> Vitalii >>> > >> >>> > >> >>> > >> On Tue, Jun 26, 2018 at 1:27 PM Nitin Pawar < >>> nitinpawar...@gmail.com> >>> > >> wrote: >>> > >> >>> > >> > Hi, >>> > >> > >>> > >> > Can someone help me understand below error? and how do I not let >>> this >>> > >> > happen ?? >>> > >> > >>> > >> > SYSTEM ERROR: IllegalStateException: Tried to remove unmanaged >>> buffer. >>> > >> > >>> > >> > Fragment 0:0 >>> > >> > >>> > >> > [Error Id: bcd510f6-75ee-49a7-b723-7b35d8575623 on >>> > >> > ip-10-0-103-63.ec2.internal:31010] >>> > >> > Caused By: SYSTEM ERROR: IllegalStateException: Tried to remove >>> > >> unmanaged >>> > >> > buffer. >>> > >> > >>> > >> > Fragment 0:0 >>> > >> > >>> > >> > [Error Id: bcd510f6-75ee-49a7-b723-7b35d8575623 on >>> > >> > ip-10-0-103-63.ec2.internal:31010] >>> > >> > >>> > >> > -- >>> > >> > Nitin Pawar >>> > >> > >>> > >> >>> > > >>> > > >>> > > >>> > > -- >>> > > Nitin Pawar >>> > > >>> > >>> > >>> > >>> > -- >>> > Nitin Pawar >>> > >>> >> >> >> >> -- >> Nitin Pawar >> > > > > -- > Nitin Pawar > -- Nitin Pawar