Re: querying json with arrays of varying dimensionality fails

I think union type support is still in beta stage; that's why it's turned off by default. Could you please file a JIRA for the problem you encountered? That way, we will not lose track of those issues. Thanks! On Mon, Feb 15, 2016 at 4:32 AM, Karol Potocki wrote: > Ok, now the

Re: querying json with arrays of varying dimensionality fails

Ok, now the query executes succesfully. But now the problem moved to flatten step. Trying: select flatten(feature) from dfs.`tmp/1.json`; causes: Error: SYSTEM ERROR: SchemaChangeRuntimeException: Inner vector type mismatch. Requested type: [minor_type: BIGINT mode: OPTIONAL ], actual type:

querying json with arrays of varying dimensionality fails

There is a problem querying json files with structure like below: { "feature": [ { "foo": [1, 2] }, { "foo": [[1, 2], [1, 2]] } ] } it fails with: Error: UNSUPPORTED_OPERATION ERROR: In a list of type BIGINT, encountered a value of type LIST. Drill does not support lists of different

Re: querying json with arrays of varying dimensionality fails

For such use case, you need to turn on union vector type support (https://issues.apache.org/jira/browse/DRILL-3229) 0: jdbc:drill:zk=local> alter session set `exec.enable_union_type` = true; +---+--+ | ok | summary |