blob: 7a0f240cdb29fa1c61abb95951bbef919baa2207 [file] [log] [blame]
CREATE TABLE complex1 (
c0 int,
c1 array<int>,
c2 map<int, string>,
c3 struct<f1:int,f2:string,f3:array<int>>,
c4 array<struct<f1:int,f2:string,f3:array<int>>>);
INSERT INTO complex1
SELECT 3,
array(1, 2, null),
map(1, 'one', 2, null),
named_struct('f1', cast(null as int), 'f2', cast(null as string), 'f3', array(1, 2, null)),
array(named_struct('f1', 11, 'f2', 'two', 'f3', array(2, 3, 4)));
select * from complex1;