PREHOOK: query: -- start with the original nestedcomplex test create table nestedcomplex ( simple_int int, max_nested_array array>>>>>>>>>>>>>>>>>>>>>>, max_nested_map array>>>>>>>>>>>>>>>>>>>>>, max_nested_struct array>>>>>>>>>>>>>>>>>>>>>>, simple_string string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'hive.serialization.extend.nesting.levels'='true', 'line.delim'='\n' ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@nestedcomplex POSTHOOK: query: -- start with the original nestedcomplex test create table nestedcomplex ( simple_int int, max_nested_array array>>>>>>>>>>>>>>>>>>>>>>, max_nested_map array>>>>>>>>>>>>>>>>>>>>>, max_nested_struct array>>>>>>>>>>>>>>>>>>>>>>, simple_string string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'hive.serialization.extend.nesting.levels'='true', 'line.delim'='\n' ) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@nestedcomplex PREHOOK: query: describe nestedcomplex PREHOOK: type: DESCTABLE PREHOOK: Input: default@nestedcomplex POSTHOOK: query: describe nestedcomplex POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nestedcomplex simple_int int max_nested_array array>>>>>>>>>>>>>>>>>>>>>> max_nested_map array>>>>>>>>>>>>>>>>>>>>> max_nested_struct array>>>>>>>>>>>>>>>>>>>>>> simple_string string PREHOOK: query: describe extended nestedcomplex PREHOOK: type: DESCTABLE PREHOOK: Input: default@nestedcomplex POSTHOOK: query: describe extended nestedcomplex POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nestedcomplex simple_int int max_nested_array array>>>>>>>>>>>>>>>>>>>>>> max_nested_map array>>>>>>>>>>>>>>>>>>>>> max_nested_struct array>>>>>>>>>>>>>>>>>>>>>> simple_string string #### A masked pattern was here #### PREHOOK: query: load data local inpath '../../data/files/nested_complex.txt' overwrite into table nestedcomplex PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@nestedcomplex POSTHOOK: query: load data local inpath '../../data/files/nested_complex.txt' overwrite into table nestedcomplex POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@nestedcomplex PREHOOK: query: -- and load the table into Parquet CREATE TABLE parquet_nested_complex STORED AS PARQUET AS SELECT * FROM nestedcomplex PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@nestedcomplex PREHOOK: Output: database:default PREHOOK: Output: default@parquet_nested_complex POSTHOOK: query: -- and load the table into Parquet CREATE TABLE parquet_nested_complex STORED AS PARQUET AS SELECT * FROM nestedcomplex POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@nestedcomplex POSTHOOK: Output: database:default POSTHOOK: Output: default@parquet_nested_complex PREHOOK: query: SELECT * FROM parquet_nested_complex SORT BY simple_int PREHOOK: type: QUERY PREHOOK: Input: default@parquet_nested_complex #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM parquet_nested_complex SORT BY simple_int POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_nested_complex #### A masked pattern was here #### 2 [[[[[[[[[[[[[[[[[[[[[[[0,3,2]]]]]]]]]]]]]]]]]]]]]]] [[[[[[[[[[[[[[[[[[[[[{"k1":"v1","k3":"v3"}]]]]]]]]]]]]]]]]]]]]] [[[[[[[[[[[[[[[[[[[[[[{"s":"b","i":10}]]]]]]]]]]]]]]]]]]]]]] 2 3 [[[[[[[[[[[[[[[[[[[[[[[0,1,2]]]]]]]]]]]]]]]]]]]]]]] [[[[[[[[[[[[[[[[[[[[[{"k1":"v1","k2":"v2"}]]]]]]]]]]]]]]]]]]]]] [[[[[[[[[[[[[[[[[[[[[[{"s":"a","i":10}]]]]]]]]]]]]]]]]]]]]]] 2 PREHOOK: query: DROP TABLE nestedcomplex PREHOOK: type: DROPTABLE PREHOOK: Input: default@nestedcomplex PREHOOK: Output: default@nestedcomplex POSTHOOK: query: DROP TABLE nestedcomplex POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@nestedcomplex POSTHOOK: Output: default@nestedcomplex PREHOOK: query: DROP TABLE parquet_nested_complex PREHOOK: type: DROPTABLE PREHOOK: Input: default@parquet_nested_complex PREHOOK: Output: default@parquet_nested_complex POSTHOOK: query: DROP TABLE parquet_nested_complex POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@parquet_nested_complex POSTHOOK: Output: default@parquet_nested_complex