创建分区表
CREATE TABLE 表名(`字段1` string,`字段2` int) partitioned by(分区字段 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
例子
CREATE TABLE my_table(`id` string,`cnt` int) partitioned by(date string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
将数据写入分区表
INSERT INTO TABLE 表名 PARTITION (分区字段=分区字段值) select 字段1,字段2 FROM 原始表 where 字段3=字段值;
例子
INSERT INTO TABLE my_table PARTITION (date='20130101') select id,cnt FROM origin_tabel where date='20130101';