
hive
不会编程的码农
QQ:1670934843
展开
-
Hive DDL
1.创建内部表create table person1(id int,name string,likes ARRAY <string>,address MAP <string,string>)ROW FORMAT DELIMITED//指定每一项分割FIELDS TERMINATED BY ','//指定集合分割COLLECTION ITEMS TERMINATED BY '_'原创 2017-04-29 11:11:29 · 420 阅读 · 0 评论 -
Hive--DML
//分区(分区的字段一定不能在表的字段中)create table person5(id int,name string,likes ARRAY <string>,address MAP <string,string>)PARTITION BY(sex string)ROW FORMAT DELIMITED//指定每一项分割FIELDS TERMINATED BY ','//指原创 2017-05-02 15:58:32 · 281 阅读 · 0 评论