Hi Divya,
You mentioned combining Polygon shapes with Multipolygon shapes.
JSON allows objects with distinct structures: a Polygon, say, in one record, a
MultiPolygon in another. However, Drill has to convert the JSON to a flat
SQL-like structure. Yes, Drill allows "Maps" (Structs). But all Maps must have
the same schema.
If you have fields that intermix Polygon and MultiPolygon objects, Drill will
flatten the result into single combined tuple schema. This is fine, unless a
field of the same name exists in both objects, but has different types in the
two objects.
Since there is no error included here, it is not clear if this is, indeed, the
case in your example, or if there is some other issue.
Thanks,
- Paul
On Monday, June 11, 2018, 12:03:25 AM PDT, Divya Gehlot
<[email protected]> wrote:
Hi,
Can anybody help me by explaining below :
Drill cannot handle the intermixed Polygon shapes and MultiPolygon shapes.
Workaround: None, per se, but if you avoid querying the multi-polygon lines
(120 of them), Drill works fine on the entire remainder
Thanks,
Divya
