This message was deleted.
# generals
Slackbot
04/05/2023, 9:52 AMThis message was deleted.
v
Vadim
04/05/2023, 4:00 PMNo, there isn't a way to do it in bulk, you would have to spell out the name of every key but doing that defeats the purpose of the COMPLEX<json> type
c
Clint Wylie
04/05/2023, 7:15 PMi suppose we could add customization options to lower or uppercase the keys someday if that’s a common need, or a transform function for it 🤷
Clint Wylie
04/05/2023, 7:16 PMor maybe an option store them case insensitive or something
p
Park Hoon
04/06/2023, 1:27 AMHi, It would be nice to have
transformPark Hoon
04/06/2023, 1:27 AMHere are examples.
Copy code
> SELECT transform(array(1, 2, 3), x -> x + 1);
[2,3,4]
> SELECT transform(array(1, 2, 3), (x, i) -> x + i);
[1,3,5] Copy code
> SELECT transform_keys(map_from_arrays(array(1, 2, 3), array(1, 2, 3)), (k, v) -> k + 1);
{2:1,3:2,4:3}
> SELECT transform_keys(map_from_arrays(array(1, 2, 3), array(1, 2, 3)), (k, v) -> k + v);
{2:1,4:2,6:3} Copy code
> SELECT transform_values(map_from_arrays(array(1, 2, 3), array(1, 2, 3)), (k, v) -> v + 1);
{1:2,2:3,3:4}
> SELECT transform_values(map_from_arrays(array(1, 2, 3), array(1, 2, 3)), (k, v) -> k + v);
{1:2,2:4,3:6}Park Hoon
04/06/2023, 1:37 AMThose transform functions also accept a map parameter.
Copy code
df.selectExpr("transform_values(col1, (k,v) -> coalesce(v.a, v.b, v.c, v.d)) as col1").show()