Re: Drill error
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 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 > 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 > > 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 > > >> 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
Re: Drill error
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 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 > 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 > >> 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 >
Re: Drill error
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 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 >> 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
Re: Drill error
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 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 > 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