FROM carts GROUP BY cartId

FROM carts GROUP BY cartId

Expected result:

cartId items

1 [1,100,200,300,250]
A . FLATTEN, COLLECT_UNION
B . ARRAY_UNION, FLATTEN
C . ARRAY_UNION, ARRAY_DISTINT
D . ARRAY_UNION, COLLECT_SET
E . ARRAY_DISTINCT, ARRAY_UNION

Answer: D

Explanation:

COLLECT SET is a kind of aggregate function that combines a column value from all rows into a unique list ARRAY_UNION combines and removes any duplicates,

Graphical user

interface, application

Description automatically generated with medium confidence

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments