Hi everyone, can Apache Pinot supports a list of lists data type (a multi-valued column where values are also lists)? Thanks.

Pinot supports JSON for complex data types, you can use that?

yes, I can use Json but this would results in more complicated queries (we generate queries on the fly) in addition to the performance hit from using Json.

What’s the performance hit with JSON you are referring to?

From docs: It’s not performant to group by or order by a JSON field, because

JSON_EXTRACT_SCALAR

is needed to extract the values in the GROUP BY and ORDER BY clauses, which invokes the function evaluation.

We don’t have that yet (perhaps file a GH issue with request). For performance, I’d recommend trying it out, as it depends on a lot of factors including your SLA requirement, query selectivity etc

thanks