*Is this the best solution for this problem? Anyway to provide a type hint in the query?* - I guess it depends on how you want to use this field. If you just want to report the field, you could also consider treating this field as string by issuing
alter session set `store.json.all_text_mode` = true; As otherwise Drill currently does not support type promotion from int to double. -Hanifi On Wed, Jun 17, 2015 at 4:28 PM, Tim Harper <[email protected]> wrote: > The data: > > > timcharper@timcharper:~/data $ cat test.json > > [ > > {"leFloat": 1, "leInt": 1}, > > {"leFloat": 0.1, "leInt": 1} > > ] > > > The exception: > > > 0: jdbc:drill:zk=local> select leFloat from > file.`/Users/timcharper/data/test.json`; > > Error: DATA_READ ERROR: Error parsing JSON - You tried to write a Float8 > type when you are using a ValueWriter of type NullableBigIntWriterImpl. > > > > File /Users/timcharper/data/test.json > > Record 2 > > Fragment 0:0 > > > > [Error Id: e1ba7368-cbe2-401b-aa96-f01b7a8f97ae on 10.0.7.68:31010] > (state=,code=0) > > If I switch the first record and the second, then I get this: > > > 0: jdbc:drill:zk=local> select leFloat from > file.`/Users/timcharper/data/test.json`; > > Error: DATA_READ ERROR: Error parsing JSON - You tried to write a BigInt > type when you are using a ValueWriter of type NullableFloat8WriterImpl. > > > > File /Users/timcharper/data/test.json > > Record 2 > > Fragment 0:0 > > > > [Error Id: 02db1336-cbe2-42e8-aaa3-9a926598295a on 10.0.7.68:31010] > (state=,code=0) > > If I set store.json.read_numbers_as_double to true, then things work, but > this is less that desirable; Is this the best solution for this problem? > Anyway to provide a type hint in the query? > > Thanks! > > Tim
