Hi All, do you know how Pinot stores data between brackets? (not JSON). Let me explain: I have this data

id,timestamp,application
1,1649268351,"{'app_name': 'foo', 'version': '1.0.0', 'app_id': None, 'business': 'ponzico'}"

And when I load that info I got

| id | timestamp  |    application    |
|----|------------|-------------------|
| 1  | 1649268351 | foo,1.0.0,ponzico |

(In table-schema.json row "_application_" is configured as "STRING".) There is a way to query "_application_" row based on one of the values inside? (ie

SELECT * FROM testing WHERE application.app_name = "foo"

). Thanks in advance!

whats the decoder you are using?

It's a parquet file

this is not how it is expected to be stored. can you share your schema and table config too?

Also, assuming the ingestion works properly, JSON index can help with querying a specific value inside the json

@User With the given parquet data, table schema where 'application' is of type JSON, we were unable to reproduce this on the latest pinot build. The field correctly gets stored as json, as expected. Can you share your table schema, ingestion job spec yaml and any other details that might be of relevance and help in debugging this? cc: @User