Supports of Multi Polygons in pointInPolygon function

[alexvaut]

Clickhouse supports polygons in pointInPolygon. This is already great. However it doesn't support Multi Polygon while the Boost library C++ underneath supports it. Right now, we workaround this limitation by using a UNION ALL and a select statement for each sub polygon: "select lon,lat where pointInPolygon((lon, lat),{each_pol})". But this is not efficient since we can have thousands of polygons in one multi polygon. More importantly, it's impossible to store a multi polygon in clickhouse and run the pointInPolygon function directly on it.

Could we envisage adding support of Multi Polygons in pointInPolygon ?

Thanks !

[cBevilaqua]

Clickhouse supports polygons in pointInPolygon. This is already great. However it doesn't support Multi Polygon while the Boost library C++ underneath supports it. Right now, we workaround this limitation by using a UNION ALL and a select statement for each sub polygon: "select lon,lat where pointInPolygon((lon, lat),{each_pol})". But this is not efficient since we can have thousands of polygons in one multi polygon. More importantly, it's impossible to store a multi polygon in clickhouse and run the pointInPolygon function directly on it.

Could we envisage adding support of Multi Polygons in pointInPolygon ?

Thanks !

I'm having the same requirement.
Can you share an example how you achieved this: select lon,lat where pointInPolygon((lon, lat),{each_pol}) ?
Thanks!