How to use spatial data in druid?

Dear Team,

In my data I have latitude and longitude. I am able to ingest this data into druid as Coordinates type.But I am not able to find how to use this data ? In Druid document I saw like below,It means only druid sql queries wont support or druid itself is not supporting these features .Please make some clarity . In case any possibility is there, to support druid spatial API’s to query the spatial data please let me know. Any documentation is available please share me.Any help is appreciated.

Unsupported features

Druid does not support all SQL features, including:

Regards,

Prasanna.P

Dear Team,

In my data I have latitude and longitude. I am able to ingest this data into druid as Coordinates type.But I am not able to find how to use this data ? In Druid document I saw like below,It means only druid sql queries wont support or druid itself is not supporting these features .Please make some clarity . In case any possibility is there, to support druid spatial API’s to query the spatial data please let me know. Any documentation is available please share me.Any help is appreciated.

Unsupported features

Druid does not support all SQL features, including:

  • OVER clauses, and analytic functions such as LAG and LEAD.
  • JOIN clauses, other than semi-joins as described above.
  • OFFSET clauses.
  • DDL and DML.
    Additionally, some Druid features are not supported by the SQL language. Some unsupported Druid features include:

Regards,

Prasanna.P

Hi Prasana,

Druid native queries has support for doing geographic queries:

https://druid.apache.org/docs/latest/querying/querying

https://druid.apache.org/docs/latest/development/geo.html

Thanks,

Chi

Druid has support for Multi-Value dimensions.

https://druid.apache.org/docs/latest/querying/multi-value-dimensions.html

Now it is supported in SQL queries as well.

Query cancellation can be done explicitly using API curl -X DELETE “http://host:port/druid/v2/abc123”

where abc123 is the unique query id.