This message was deleted.

Hi Zohaib, yes there are a number of JSON related functions that allow you to convert strings into object format and also to extract objects or individual values from JSON fields or converted strings. https://druid.apache.org/docs/latest/misc/math-expr#json-functions You can also ingest data directly into a nested JSON format into Druid: https://druid.apache.org/docs/latest/querying/sql-data-types#nested-columns Hopefully this is what you are looking for ... if not, let us know. Thanks. John

Can you please provide an example as i have tried json_object function but it is not working

Here's an example using the kttm-nested demo table ... pulling both simple typed elements, and JSON sub-object.

Thanks i will check