Hello team, Just started exploring Pinot and I am new to the community here. I am evaluating Pinot for a schema change and I had a couple of questions. Was wondering if any one has thoughts on these: 1. Array of JSON objects or single JSON with array of objects? Which is faster, smaller or easier to query in a Pinot table? 2. If I have a bunch of fields which will not change frequently, does it make sense to have them in a JSON object OR as columns in a PINOT table in terms of query performance?

1. Json with array - @Jackie 2. Json is currently store as text blob + indexing. With primitive columns you get better storage for sure

Referring to point 2. Even for querying columns would perform better correct?

1. Pinot only supports single JSON with array of objects for querying purpose 2. Storing field as column always have better performance (also better compression) than within the JSON

Thanks @Mayank and @Jackie