Re: Drill error

2018-06-28 Thread Kunal Khatua
That could be a possibility. See if you can skip that value in the column... 
try using a filter condition with a such as 
NOT LIKE '%' 
On 6/27/2018 11:25:10 PM, Nitin Pawar  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
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 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
>



--
Nitin Pawar


Re: Drill error

2018-06-28 Thread Vitalii Diravka
Thank you, Nitin

Kind regards
Vitalii


On Thu, Jun 28, 2018 at 6:04 PM Nitin Pawar  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 
> > 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  >
> > > 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 
> > > >> 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
> 

Re: Drill error

2018-06-28 Thread Nitin Pawar
created https://issues.apache.org/jira/browse/DRILL-6551

On Thu, Jun 28, 2018 at 7:43 PM, Vitalii Diravka 
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 
> 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 
> > 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  >
> > > 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 
> > >> 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


Re: Drill error

2018-06-28 Thread Vitalii Diravka
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 
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 
> 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 
> > 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 
> >> 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 <
> 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
>


Re: Drill error

2018-06-28 Thread Nitin Pawar
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 
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 
> 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 
>> 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 <
>>> 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


Re: Drill error

2018-06-28 Thread Nitin Pawar
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 
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  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
>



-- 
Nitin Pawar