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

Posted to user@drill.apache.org by Vince Gonzalez <vi...@gmail.com> on 2015/05/15 21:12:29 UTC

JSON field changes from scalar to list

Given the following data sample (stored in /tmp/data.json) and query, is
there a good way to avoid an error?

{ "timestamp": 1431717028,
  "data": [
    { "a": 1 },
    { "a": [ 1,2,3 ] }
  ]
}


0: jdbc:drill:zk=local> select flatten(data) as data from
dfs.tmp.`test.json`;
Query failed: DATA_READ ERROR: You tried to start when you are using a
ValueWriter of type NullableBigIntWriterImpl.

File  /tmp/test.json
Record  1
Line  4
Column  14
Field  a
Fragment 0:0

[b4ea66d1-98c9-426f-a2ce-aeb211a378da on 172.30.1.73:31010]
Error: exception while executing query: Failure while executing query.
(state=,code=0)