Hey Vince, I don't think that's supported. The array "data" is heterogeneous (one is a simple value and other is an array).
-Abhishek On Fri, May 15, 2015 at 12:12 PM, Vince Gonzalez <[email protected]> wrote: > 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) >
