You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Eduardo Machado <ea...@gmail.com> on 2018/08/29 19:18:26 UTC

Error: SYSTEM ERROR: NumberFormatException: empty String

Gentlemen,

I'm trying to create a table but I'm getting this error message (subject).
The 3 attachments are the steps I've tried so far.

The Screen_1 is just to show the result of:

ALTER SYSTEM SET `drill.exec.functions.cast_empty_string_to_null` = true;

What am I doing wrong?

Thank you,

Eduardo Machado

Re: Error: SYSTEM ERROR: NumberFormatException: empty String

Posted by Boaz Ben-Zvi <bb...@mapr.com>.

  Hi Eduardo,

      Did you try to attach an image to you message ?  The Apache list 
does not support attachments, so please describe the error.

And the Alter System seems to work fine (unless you don't have admin 
permissions - may try "ALTER SESSION" instead):

0: jdbc:drill:zk=local> ALTER SYSTEM SET 
`drill.exec.functions.cast_empty_string_to_null` = true;
+-------+----------------------------------------------------------+
|  ok   |                         summary                          |
+-------+----------------------------------------------------------+
| true  | drill.exec.functions.cast_empty_string_to_null updated.  |
+-------+----------------------------------------------------------+
1 row selected (1.338 seconds)

    Thanks,

         Boaz

On 8/29/18 12:18 PM, Eduardo Machado wrote:
> Gentlemen,
>
> I'm trying to create a table but I'm getting this error message 
> (subject). The 3 attachments are the steps I've tried so far.
>
> The Screen_1 is just to show the result of:
>
> ALTER SYSTEM SET `drill.exec.functions.cast_empty_string_to_null` = true;
>
> What am I doing wrong?
>
> Thank you,
>
> Eduardo Machado
>
>