set hive.vectorized.execution.enabled=true;
set hive.explain.user=false;
set hive.fetch.task.conversion=none;

create table nested_array_array_table (
nested_array_array  array<array<int>>)
STORED AS PARQUET;

create table nested_array_map_table (
nested_array_map  array<map<string,string>>)
STORED AS PARQUET;

create table nested_array_struct_table (
nested_array_map  array<struct<latitude: DOUBLE, longitude: DOUBLE>>)
STORED AS PARQUET;

create table nested_map_array_table (
nested_map_array  map<string,array<int>>)
STORED AS PARQUET;

create table nested_map_map_table (
nested_map_map    map<string,map<string,string>>)
STORED AS PARQUET;

create table nested_map_struct_table (
nested_map_struct    map<string,struct<latitude: DOUBLE, longitude: DOUBLE>>)
STORED AS PARQUET;

create table nested_struct_array_table (
nested_struct_array struct<s:string, i:bigint, a:array<int>>)
STORED AS PARQUET;

create table nested_struct_map_table (
nested_struct_map struct<s:string, i:bigint, m:map<string,string>>)
STORED AS PARQUET;

create table nested_struct_struct_table (
nested_struct_struct struct<s:string, i:bigint, s2:struct<latitude: DOUBLE, longitude: DOUBLE>>)
STORED AS PARQUET;


EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_array_array_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_array_map_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_array_map_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_map_array_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_map_map_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_map_struct_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_struct_array_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_struct_map_table;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM nested_struct_struct_table;