1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TEMPORARY VIEW tbl_x AS VALUES
(1, NAMED_STRUCT('C', 'gamma', 'D', 'delta')),
(2, NAMED_STRUCT('C', 'epsilon', 'D', 'eta')),
(3, NAMED_STRUCT('C', 'theta', 'D', 'iota'))
AS T(ID, ST);
-- Create a struct
SELECT STRUCT('alpha', 'beta') ST;
-- Create a struct with aliases
SELECT STRUCT('alpha' AS A, 'beta' AS B) ST;
-- Star expansion in a struct.
SELECT ID, STRUCT(ST.*) NST FROM tbl_x;
-- Append a column to a struct
SELECT ID, STRUCT(ST.*,CAST(ID AS STRING) AS E) NST FROM tbl_x;
-- Prepend a column to a struct
SELECT ID, STRUCT(CAST(ID AS STRING) AS AA, ST.*) NST FROM tbl_x;
|
