drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: JSON field changes from scalar to list
Date Fri, 15 May 2015 20:04:32 GMT
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 <vince.gonzalez@gmail.com>
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)
>

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