| DROP TABLE avro_charvarchar_staging; |
| DROP TABLE avro_charvarchar; |
| |
| CREATE TABLE avro_charvarchar_staging ( |
| cchar char(5), |
| cvarchar varchar(10), |
| m1 map<string, char(2)>, |
| l1 array<string>, |
| st1 struct<c1:int, c2:varchar(4)> |
| ) ROW FORMAT DELIMITED |
| FIELDS TERMINATED BY '|' |
| COLLECTION ITEMS TERMINATED BY ',' |
| MAP KEYS TERMINATED BY ':'; |
| |
| CREATE TABLE avro_charvarchar ( |
| cchar char(5), |
| cvarchar varchar(10), |
| m1 map<string, char(2)>, |
| l1 array<string>, |
| st1 struct<c1:int, c2:varchar(4)> |
| ) STORED AS AVRO; |
| |
| LOAD DATA LOCAL INPATH '../../data/files/avro_charvarchar.txt' OVERWRITE INTO TABLE avro_charvarchar_staging; |
| |
| INSERT OVERWRITE TABLE avro_charvarchar SELECT * FROM avro_charvarchar_staging; |
| |
| SELECT * FROM avro_charvarchar; |