Is there any way to query a specific cell in a multi-value column? For instance, in the example below, I know that the first values in each column go together, but I can't seem to query them like "SELECT external_recipient_identifier[0], external_recipient_ipaddress[0]". I did try the map_value function for that email, and it did return me the correct ipaddress, but this seems pretty limited because you have to specify an exact filter for the 2nd parameter.

map_value(external_recipient_identifier, 'Théoden@gmail.com', external_recipient_ipaddress)

looks like there is

arraySliceString(column, start, end)

that's perfect! Thanks @User, any reason that isn't documented?

no excuse 🙂

haha ok, much appreciated tho

Apologies, we will get this added in the docs asap.

thanks all!

Other array functions are now documented as well - https://docs.pinot.apache.org/configuration-reference/functions

very nice, thanks @User!