PREHOOK: query: -- this test creates a Parquet table with an array of multi-field structs

CREATE TABLE parquet_array_of_multi_field_structs (
    locations ARRAY<STRUCT<latitude: DOUBLE, longitude: DOUBLE>>
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@parquet_array_of_multi_field_structs
POSTHOOK: query: -- this test creates a Parquet table with an array of multi-field structs

CREATE TABLE parquet_array_of_multi_field_structs (
    locations ARRAY<STRUCT<latitude: DOUBLE, longitude: DOUBLE>>
) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_array_of_multi_field_structs
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/MultiFieldGroupInList.parquet'
OVERWRITE INTO TABLE parquet_array_of_multi_field_structs
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@parquet_array_of_multi_field_structs
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/MultiFieldGroupInList.parquet'
OVERWRITE INTO TABLE parquet_array_of_multi_field_structs
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@parquet_array_of_multi_field_structs
PREHOOK: query: SELECT * FROM parquet_array_of_multi_field_structs
PREHOOK: type: QUERY
PREHOOK: Input: default@parquet_array_of_multi_field_structs
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM parquet_array_of_multi_field_structs
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_array_of_multi_field_structs
#### A masked pattern was here ####
[{"latitude":0.0,"longitude":0.0},{"latitude":0.0,"longitude":180.0}]
PREHOOK: query: DROP TABLE parquet_array_of_multi_field_structs
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@parquet_array_of_multi_field_structs
PREHOOK: Output: default@parquet_array_of_multi_field_structs
POSTHOOK: query: DROP TABLE parquet_array_of_multi_field_structs
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@parquet_array_of_multi_field_structs
POSTHOOK: Output: default@parquet_array_of_multi_field_structs
PREHOOK: query: -- maps use the same writable structure, so validate that the data can be read
-- as a map instead of an array of structs

CREATE TABLE parquet_map_view_of_multi_field_structs (
    locations MAP<DOUBLE, DOUBLE>
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@parquet_map_view_of_multi_field_structs
POSTHOOK: query: -- maps use the same writable structure, so validate that the data can be read
-- as a map instead of an array of structs

CREATE TABLE parquet_map_view_of_multi_field_structs (
    locations MAP<DOUBLE, DOUBLE>
) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_map_view_of_multi_field_structs
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/MultiFieldGroupInList.parquet'
OVERWRITE INTO TABLE parquet_map_view_of_multi_field_structs
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@parquet_map_view_of_multi_field_structs
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/MultiFieldGroupInList.parquet'
OVERWRITE INTO TABLE parquet_map_view_of_multi_field_structs
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@parquet_map_view_of_multi_field_structs
PREHOOK: query: SELECT * FROM parquet_map_view_of_multi_field_structs
PREHOOK: type: QUERY
PREHOOK: Input: default@parquet_map_view_of_multi_field_structs
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM parquet_map_view_of_multi_field_structs
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_map_view_of_multi_field_structs
#### A masked pattern was here ####
{0.0:180.0}
PREHOOK: query: DROP TABLE parquet_map_view_of_multi_field_structs
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@parquet_map_view_of_multi_field_structs
PREHOOK: Output: default@parquet_map_view_of_multi_field_structs
POSTHOOK: query: DROP TABLE parquet_map_view_of_multi_field_structs
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@parquet_map_view_of_multi_field_structs
POSTHOOK: Output: default@parquet_map_view_of_multi_field_structs