Re: Drill error

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

2018-06-27 Thread Khurram Faraaz
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

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

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