| set hive.vectorized.execution.enabled=false; |
| |
| DROP TABLE IF EXISTS dec_comp; |
| |
| CREATE TABLE dec_comp(arr ARRAY<decimal(5,2)>, m MAP<String, decimal(5,2)>, s STRUCT<i:int, d:decimal(5,2)>) |
| ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED by ':'; |
| |
| LOAD DATA LOCAL INPATH '../../data/files/dec_comp.txt' INTO TABLE dec_comp; |
| |
| SELECT * FROM dec_comp; |
| |
| DROP TABLE IF EXISTS parq_dec_comp; |
| |
| CREATE TABLE parq_dec_comp(arr ARRAY<decimal(5,2)>, m MAP<String, decimal(5,2)>, s STRUCT<i:int, d:decimal(5,2)>) |
| STORED AS PARQUET; |
| |
| DESC parq_dec_comp; |
| |
| INSERT OVERWRITE TABLE parq_dec_comp SELECT * FROM dec_comp; |
| |
| SELECT * FROM parq_dec_comp; |
| |
| DROP TABLE dec_comp; |
| DROP TABLE parq_dec_comp; |