https://pinot.apache.org/ logo
#getting-started
Title
# getting-started
a

Aaron Weiss

03/14/2022, 5:15 PM
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.
Copy code
map_value(external_recipient_identifier, 'Théoden@gmail.com', external_recipient_ipaddress)
k

Kishore G

03/14/2022, 5:23 PM
looks like there is
arraySliceString(column, start, end)
a

Aaron Weiss

03/14/2022, 5:30 PM
that's perfect! Thanks @User, any reason that isn't documented?
k

Kishore G

03/14/2022, 5:33 PM
no excuse 🙂
1
a

Aaron Weiss

03/14/2022, 5:33 PM
haha ok, much appreciated tho
m

Mayank

03/14/2022, 5:38 PM
Apologies, we will get this added in the docs asap.
we have some other array functions that I'll document as well
a

Aaron Weiss

03/14/2022, 5:59 PM
thanks all!
👍 1
m

Mark Needham

03/15/2022, 2:58 PM
Other array functions are now documented as well - https://docs.pinot.apache.org/configuration-reference/functions
🙏 1
a

Aaron Weiss

03/15/2022, 3:02 PM
very nice, thanks @User!