drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Drill error
Date Thu, 28 Jun 2018 07:50:53 GMT
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 <nitinpawar432@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 <nitinpawar432@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 <kfaraaz@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 <nitinpawar432@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 <nitinpawar432@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.diravka@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 <
>>> nitinpawar432@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message