Polygon dictionaries

Example configuration:

Tne corresponding DDL-query:

When configuring the polygon dictionary, the key must have one of two types:
- A simple polygon. It is an array of points.
- MultiPolygon. It is an array of polygons. Each polygon is a two-dimensional array of points. The first element of this array is the outer boundary of the polygon, and subsequent elements specify areas to be excluded from it.

The user can in all formats supported by ClickHouse.

There are 3 types of in-memory storage available:

Dictionary queries are carried out using standard for working with external dictionaries.
An important difference is that here the keys will be the points for which you want to find the polygon containing them.

As a result of executing the last command for each point in the ‘points’ table, a minimum area polygon containing this point will be found, and the requested attributes will be output.