Hey, do we have any example querying/working on the multi-value column? I cannot find one in the document. e.g. get the first element in the multi-val column.

How do you want to use it? Note that it not necessarily be ordered.

I see. I have a column with a list of addresses of the customer, where each one is a json.

@User do we preserve MV column order? Rather should client rely on ordering?

We do preserver the order in MV column

The ordering is not important. I want to know how to fetch the first or the second element in the MV column. Do we have a pinot function to do that?

In

ArrayFunctions

we have several functions that applies to array. You may plug-in your own function with

ScalarFunction

annotation

Thanks, I will check that out. One more question, do you happen to know the behavior of trino/prestodb when it query a MV column? Any function I should applied on the result to be recognized as a array in trino?

@User ^^

You could use a groovy function to fetch a particular element from the array

I think the ask is for fetching it during query time.

we have groovy for query time too

Prestodb should treat mv column as an array

several examples of getting elements from MV columns using groovy: https://docs.pinot.apache.org/users/user-guide-query/scalar-functions

Thanks @User