This message was deleted.

Use Spatial filters for this, Below link has the explanation and sample data. https://druid.apache.org/docs/latest/development/geo.html

I want to create a table of cities with geometry data, so when importing the data from geojson file how should I save it in Druid datasource?

In the link given we have an sample ingestion spec where x and y are the coordinates of the cities, Are you getting any error by using the example spec

@Kuldip Shelke What are you trying to do with the polygon? If you are trying to find whether a location is within a polygon, the corresponding filter for the data above would be:

"filter" : {
    "type": "spatial",
    "dimension": "spatialDim",
    "bound": {
        "type": "polygon",
        "abscissa": [72.880622863769531, 72.882926940917969, 72.883712768554688, 72.876976013183537, 72.875907897949276],
        "ordinate": [19.067600250244197, 19.066390991210994, 19.06438064575201, 19.055419921875, 19.052352905273381]
    }

I guess the issue is whether you could use a city lookup to find/build the filters. Or are you trying to join a city lookup with event location data?