drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Rogers <par0...@yahoo.com.INVALID>
Subject Re: explain - Polygon shapes and MultiPolygon shapes
Date Tue, 12 Jun 2018 03:45:58 GMT
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 <divya.htconex@gmail.com>
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
  
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message