Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-15 Thread Jason Altekruse
This option cannot be set at the session level, it must be set at the system level. There is a JIRA open for giving a warning [1], but unfortunately right now the alter session statement just acts as a no-op. You can also write a case statement like this if you don't want to set the option at the

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-15 Thread Khurram Faraaz
Anup, can you please - share your parquet data file (also your CTAS statement that you used to create that parquet file) - and the SQL query you are running That way we can run your query against your data file on latest Drill 1.9.0, and share results with you. On Sat, Oct 15, 2016 at 4:36

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-15 Thread Nitin Pawar
not sure if this helps try setting this ..i am nit aware which version it was included alter session set `drill.exec.functions.cast_empty_string_to_null=true; and then you can try cast operation as well On Oct 15, 2016 4:28 PM, "Anup Tiwari" wrote: > We will surely

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-15 Thread Anup Tiwari
We will surely test this on 1.8 and let you know.. but by looking at JIRA , I thought it got fixed in 0.8, is it not the case? Let me know if i missed anything and pls provide some quick fix which can be applicable just by changing some variable like alter session mentioned in trail mail.. On

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-15 Thread Nitin Pawar
is there an option where you can upgrade to 1.8 and test it? On Sat, Oct 15, 2016 at 10:23 AM, Anup Tiwari wrote: > No.. on a parquet table.. > > Regards, > *Anup Tiwari* > > On Fri, Oct 14, 2016 at 6:23 PM, Nitin Pawar > wrote: > > > are

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-14 Thread Anup Tiwari
No.. on a parquet table.. Regards, *Anup Tiwari* On Fri, Oct 14, 2016 at 6:23 PM, Nitin Pawar wrote: > are you querying on csv files? > > On Fri, Oct 14, 2016 at 1:31 PM, Anup Tiwari > wrote: > > > Hi Team, > > > > I got number format

Re: [Drill 1.6] : Number format exception due to Empty String

2016-10-14 Thread Nitin Pawar
are you querying on csv files? On Fri, Oct 14, 2016 at 1:31 PM, Anup Tiwari wrote: > Hi Team, > > I got number format exception for empty string and after googling i found > that this issue is bit related to DRILL-1874 >

[Drill 1.6] : Number format exception due to Empty String

2016-10-14 Thread Anup Tiwari
Hi Team, I got number format exception for empty string and after googling i found that this issue is bit related to DRILL-1874 . Q) Is it fixed in 1.6 ? Since it is very basic problem which can occur anytime. After reading comments of