| ==== |
| ---- 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 |
| ==== |