Comment
02-08-2024
10:27 PM
02-08-2024
10:27 PM
Great feature!
SELECT * EXCEPT (b, d.y)
FROM VALUES(1, 2, 3, named_struct('x', 10, 'y', 20, 'z', 30)) AS t(a, b, c, d);
a c d
-- -- -------------
1 3 {x: 10 y: 30}
d in the output should be "{x: 10 z: 30}".