Thank you, Nitin Kind regards Vitalii
On Thu, Jun 28, 2018 at 6:04 PM Nitin Pawar <nitinpawar...@gmail.com> wrote: > created https://issues.apache.org/jira/browse/DRILL-6551 > > On Thu, Jun 28, 2018 at 7:43 PM, Vitalii Diravka < > vitalii.dira...@gmail.com> > wrote: > > > 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 > > > > > > > > > -- > Nitin Pawar >