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

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

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

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

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

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