• 特殊数据类型

　　ARRAY，MAP，STRUCT

CREATE TABLE employee(
　　name string,
　　salary double,
　　subor array<string>,
　　dedu map<string, double>,
　　address struct<street:string, city:string, state:string, zip:int>
)
ROW FORMAT DELIMITED
FIELDS TREMINATED BY '\u001'
COLLECTION ITEMS TERMINATED BY ','
MAP KEYS TERMINATED BY ':'
LINES TERMINATED BY '\n'
STORED BY TEXTFILE;

 

• 写时模式和读时模式