Error: SYSTEM ERROR: NumberFormatException: empty String

[Eduardo Machado]

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

[Boaz Ben-Zvi]

 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

Post by Eduardo Machado
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.
ALTER SYSTEM SET `drill.exec.functions.cast_empty_string_to_null` = true;
What am I doing wrong?
Thank you,
Eduardo Machado