| set hive.vectorized.execution.enabled=false; |
| |
| DROP TABLE parquet_array_null_element_staging; |
| DROP TABLE parquet_array_null_element; |
| |
| CREATE TABLE parquet_array_null_element_staging ( |
| id int, |
| lstint ARRAY<INT>, |
| lststr ARRAY<STRING>, |
| mp MAP<STRING,STRING> |
| ) ROW FORMAT DELIMITED |
| FIELDS TERMINATED BY '|' |
| COLLECTION ITEMS TERMINATED BY ',' |
| MAP KEYS TERMINATED BY ':' |
| NULL DEFINED AS ''; |
| |
| CREATE TABLE parquet_array_null_element ( |
| id int, |
| lstint ARRAY<INT>, |
| lststr ARRAY<STRING>, |
| mp MAP<STRING,STRING> |
| ) STORED AS PARQUET; |
| |
| DESCRIBE FORMATTED parquet_array_null_element; |
| |
| LOAD DATA LOCAL INPATH '../../data/files/parquet_array_null_element.txt' OVERWRITE INTO TABLE parquet_array_null_element_staging; |
| |
| SELECT * FROM parquet_array_null_element_staging; |
| |
| INSERT OVERWRITE TABLE parquet_array_null_element SELECT * FROM parquet_array_null_element_staging; |
| |
| SELECT lstint from parquet_array_null_element; |
| SELECT lststr from parquet_array_null_element; |
| SELECT mp from parquet_array_null_element; |
| SELECT * FROM parquet_array_null_element; |