Nizar Hejazi

@walterddr @Jackie-Jiang Is there any way we can support a Split function in Pinot that splits a text based on a delimiter and returns an array/MV?

Thanks @Jackie-Jiang. Need to add `Split` to the String transformations listed [here](https://docs.pinot.apache.org/users/user-guide-query/supported-transformations#string-functions).

@Jackie-Jiang @walterddr I get back the reference of the string array created by `Split`: Query: `split('a,b,c', ',')` Result: `[Ljava.lang.String;@5edb4950` As a result, `Split` does not work w/ array functions: Query:...

Updated issue title.

Hey @cliandy, please address comments and drive this PR to landing.

Hey @chenjian2664, @mosabua, @findepi any update on this PR? We would love to use this feature w/ dbt-trino adapter.

Hey team, any update on the status of this PR?