How can i query complex nested json data from Pinot, do we need to flatten before ingestion or does pinot can support json functions ?.

you need to flatten the nested json during ingestion

Thanks! Is there any plan to support or feature request like Druid Json Flatten Spec ? Can you share any json examples or documentation if available.

yes, we flattening is easy to add and is on the roadmap. @Neha Pawar can you point to the issue.

Here's the issue: https://github.com/apache/incubator-pinot/issues/5264

@Neha Pawar Thanks for the info.