====
---- QUERY
select id, key, value from complextypestbl t, t.int_map
---- RESULTS
1,'k1',1
1,'k2',100
2,'k1',2
2,'k2',NULL
7,'k1',NULL
7,'k3',NULL
8,'k1',-1
---- TYPES
bigint,string,int
====
---- QUERY
select id, value from complextypestbl t, t.int_map
---- RESULTS
1,1
1,100
2,2
2,NULL
7,NULL
7,NULL
8,-1
---- TYPES
bigint,int
====
---- QUERY
select key, value from complextypestbl.int_map
---- RESULTS
'k1',1
'k2',100
'k1',2
'k2',NULL
'k1',NULL
'k3',NULL
'k1',-1
---- TYPES
string,int
====
---- QUERY
select id, key, value from complextypestbl t, t.int_map_array.item
---- RESULTS
1,'k1',1
2,'k3',NULL
2,'k1',1
8,'k1',1
---- TYPES
bigint,string,int
====
---- QUERY
select id, a.pos, m.key, m.value from complextypestbl t, t.int_map_array a, a.item m
---- RESULTS
1,0,'k1',1
2,0,'k3',NULL
2,0,'k1',1
8,1,'k1',1
---- TYPES
bigint,bigint,string,int
====
---- QUERY
select id, key from complextypestbl t, t.nested_struct.g
---- RESULTS
1,'foo'
2,'g1'
2,'g2'
2,'g3'
2,'g4'
2,'g5'
5,'foo'
---- TYPES
bigint,string
====
---- QUERY
select id, key, item from complextypestbl t, t.nested_struct.g, g.value.h.i
---- RESULTS
1,'foo',1.1
2,'g1',2.2
2,'g1',NULL
5,'foo',2.2
5,'foo',3.3
---- TYPES
bigint,string,double
====
---- QUERY
select key, item from complextypestbl.nested_struct.g, g.value.h.i
---- RESULTS
'foo',1.1
'g1',2.2
'g1',NULL
'foo',2.2
'foo',3.3
---- TYPES
string,double
====
---- QUERY
select key, item, pos from complextypestbl.nested_struct.g, g.value.h.i
---- RESULTS
'foo',1.1,0
'g1',2.2,0
'g1',NULL,1
'foo',2.2,0
'foo',3.3,1
---- TYPES
string,double,bigint
====
---- QUERY
select item from complextypestbl.nested_struct.g.value.h.i
---- RESULTS
1.1
2.2
NULL
2.2
3.3
---- TYPES
double
====