| create table hybrid_table (d date) | |
| ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' | |
| COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED BY ':' | |
| stored as avro; | |
| INSERT INTO hybrid_table VALUES | |
| ('2012-02-21'), | |
| ('2014-02-11'), | |
| ('1947-02-11'), | |
| ('8200-02-11'), | |
| ('1012-02-21'), | |
| ('1014-02-11'), | |
| ('0947-02-11'), | |
| ('0200-02-11'); | |
| select * from hybrid_table; | |
| set hive.avro.proleptic.gregorian.default=true; | |
| select * from hybrid_table; | |
| drop table hybrid_table; |