Hi Team, is unnest functions supported in Pinot. I...
# general
a
Hi Team, is unnest functions supported in Pinot. I want to unnest array of strings to individual rows in pinot during query execution. how can i do that?
e
Robert’s link is a good one for unnesting json data at ingestion time 👍
unnest array of strings to individual rows in pinot during query execution
I’m not sure if this is what you’re after, but one possible way to do what you’ve described is to use multi-value columns[1] and then
GROUP BY
that multi-value column at query time. The result will be 1 row per value in the MV column of a given row. [1] https://docs.pinot.apache.org/configuration-reference/schema#dimensionfieldspec (see
singleValueField
property)