pinot icon indicating copy to clipboard operation
pinot copied to clipboard

Generic function to apply any scalar function on an MV column

Open nairDev25 opened this issue 3 years ago • 3 comments

Currently, scalar functions supports only Single valued column. Need generic function to apply any scalar function on an MV column

nairDev25 avatar May 26 '22 07:05 nairDev25

Hi @nairDev25, scalar functions can be applied to MV column right now, although it requires certain type of input value. See ArrayFunctions for some example scalar functions that apply to MV column. Do you encounter some issue when trying to apply a scalar function to a MV column?

Jackie-Jiang avatar May 26 '22 20:05 Jackie-Jiang

Hi @Jackie-Jiang , We need to run function like lower(mv_column), currently its failing

nairDev25 avatar May 30 '22 07:05 nairDev25

If we add String[] lower(String[] input) as a scalar function in StringFunctions, it should work. Do you want to help contribute this?

Jackie-Jiang avatar May 31 '22 19:05 Jackie-Jiang