drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vince Gonzalez <vince.gonza...@gmail.com>
Subject JSON field changes from scalar to list
Date Fri, 15 May 2015 19:12:29 GMT
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)

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message