| ==== |
| ---- QUERY |
| select id from complextypestbl |
| ---- RESULTS |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl |
| ---- RESULTS |
| 8 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select id from complextypestbl where id > 3 |
| ---- RESULTS |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select item from complextypestbl.int_array |
| ---- RESULTS |
| 1 |
| 2 |
| 3 |
| NULL |
| 1 |
| 2 |
| NULL |
| 3 |
| NULL |
| -1 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.int_array |
| ---- RESULTS |
| 10 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(item) from complextypestbl.int_array |
| ---- RESULTS |
| 7 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select item from complextypestbl.int_array_array.item |
| ---- RESULTS |
| 1 |
| 2 |
| 3 |
| 4 |
| NULL |
| 1 |
| 2 |
| NULL |
| 3 |
| NULL |
| 4 |
| 5 |
| 6 |
| -1 |
| -2 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select item from complextypestbl.int_array_array.item where item > 3 |
| ---- RESULTS |
| 4 |
| 4 |
| 5 |
| 6 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.int_array_array.item |
| ---- RESULTS |
| 15 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(item) from complextypestbl.int_array_array.item |
| ---- RESULTS |
| 12 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.int_array_array |
| ---- RESULTS |
| 11 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select nested_struct.a from complextypestbl |
| ---- RESULTS |
| 1 |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| 7 |
| -1 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select count(nested_struct.a) from complextypestbl |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select item from complextypestbl.nested_struct.b |
| ---- RESULTS |
| 1 |
| NULL |
| 2 |
| 3 |
| NULL |
| -1 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.nested_struct.b |
| ---- RESULTS |
| 6 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(item) from complextypestbl.nested_struct.b |
| ---- RESULTS |
| 4 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select item from complextypestbl.nested_struct.b where item is null; |
| ---- RESULTS |
| NULL |
| NULL |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select inner_array.item.e from complextypestbl.nested_struct.c.d.item inner_array |
| ---- RESULTS |
| 10 |
| -10 |
| 11 |
| NULL |
| 10 |
| NULL |
| -10 |
| NULL |
| 11 |
| NULL |
| NULL |
| -1 |
| ---- TYPES |
| int |
| ==== |
| ---- QUERY |
| select count(inner_array.item.e) from complextypestbl.nested_struct.c.d.item inner_array |
| ---- RESULTS |
| 7 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.nested_struct.c.d.item inner_array |
| ---- RESULTS |
| 12 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.nested_struct.c.d.item inner_array |
| where inner_array.item.f = 'bbb' |
| ---- RESULTS |
| 2 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| select inner_array.item.e, inner_array.item.f |
| from complextypestbl.nested_struct.c.d.item inner_array |
| ---- RESULTS |
| 10,'aaa' |
| -10,'bbb' |
| 11,'c' |
| NULL,'NULL' |
| 10,'aaa' |
| NULL,'NULL' |
| -10,'bbb' |
| NULL,'NULL' |
| 11,'c' |
| NULL,'NULL' |
| NULL,'NULL' |
| -1,'nonnullable' |
| ---- TYPES |
| int,string |
| ==== |
| ---- QUERY |
| select count(*) from complextypestbl.nested_struct.c.d |
| ---- RESULTS |
| 10 |
| ---- TYPES |
| bigint |
| ==== |