Aravind Swaminathan
01/20/2025, 9:34 AMrobert zych
01/20/2025, 5:02 PMEvan Galpin
01/21/2025, 5:14 PMunnest array of strings to individual rows in pinot during query executionI’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)