Hi Nitin, This is definitely the regression. Could you please post the Jira ticket with details of your case, data and workaround [1]. It will help for developers to solve this issue.
[1] https://issues.apache.org/jira/projects/DRILL Thanks. Kind regards Vitalii On Thu, Jun 28, 2018 at 10:50 AM Nitin Pawar <nitinpawar...@gmail.com> wrote: > 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 >