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 types.
File /home/kap/bigdata/test2.json
Record 1
Line 4
Column 16
Field foo
Line 4
Column 16
Field foo
Fragment 0:0
[Error Id: 549fd777-0cad-4728-af53-9fa988e53d00 on lpoz0775:31010]
(state=,code=0)
Such structures often exists in geojson files which contains geometries of
different types i.e. Polygon and MultiPolygon:
{
"type": "GeometryCollection",
"geometries":
[
{ "type": "Polygon",
"coordinates": [
[ [100.0, 0.0], [101.0, 0.0], [101.0, 1.0], [100.0, 1.0], [100.0, 0.0] ]
]
},
{ "type": "MultiPolygon",
"coordinates": [
[[[102.0, 2.0], [103.0, 2.0], [103.0, 3.0], [102.0, 3.0], [102.0, 2.0]]],
[[[100.0, 0.0], [101.0, 0.0], [101.0, 1.0], [100.0, 1.0], [100.0, 0.0]],
[[100.2, 0.2], [100.8, 0.2], [100.8, 0.8], [100.2, 0.8], [100.2, 0.2]]]
]
}
]
}
( which renders to: http://bl.ocks.org/anonymous/raw/b18e661defbb26df903b/ )
