Is there a way to only select the first value of a...
# troubleshootinga
Anand Sainath
02/14/2022, 6:02 AMIs there a way to only select the first value of a multi-valued column?
m
Mayank
02/14/2022, 6:10 AM
In a selection query or for applying predicate/ aggregation?
a
Anand Sainath
02/14/2022, 6:18 AMBoth.
Anand Sainath
02/14/2022, 6:19 AMUse Case: I have a multivalued column, but I want to aggregate based on only the first value in the column (trying to replicate querying in a dataset that already exists)
k
Kishore G
02/14/2022, 7:10 AM
May be add an udf to select the first element
Kishore G
02/14/2022, 7:10 AM
For now , you can use groovy udf as work art