Re: NumberFormatException with cast to double?

If you like to treat "" as NULL, please set this option "drill.exec.functions.cast_empty_string_to_null" as true in the system level. Meaning, alter system set `drill.exec.functions.cast_empty_string_to_null` = true On Sun, Mar 13, 2016 at 3:53 PM, Matt wrote: > That does

Re: NumberFormatException with cast to double?

That does indeed remove the NumberFormatException, replacing it with the same error on "empty String". As indicated by Jason in this thread I may have mistakenly believed that empty columns would be treated as NULLs. Is there a setting to set the NULL value in the data, or should all of

Re: S3 query takes a long time to start

Hi Jacques, All these technologies are pretty new to me, but I can give it a shot :) Is there any literature that can help me understand how things are set up? Cheers, On Fri, Mar 11, 2016 at 01:42:54PM -0800, Jacques Nadeau wrote: I've been thinking a lot of this. Definitely think there