create table legacy_table (d date) | |
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' | |
COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED BY ':' | |
stored as avro; | |
load data local inpath '../../data/files/avro_legacy_mixed_dates.avro' into table legacy_table; | |
select * from legacy_table; | |
set hive.avro.proleptic.gregorian.default=true; | |
select * from legacy_table; | |
drop table legacy_table; |