创建分表
CREATE TABLE tmp_table
(
passport string,
cid int
)PARTITIONED BY(vt bigint)--这个地方就是起个名字吗?
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '/,'
STORED AS SEQUENCEFILE;
添加分区
alter table tmp_table add partition (vt=1000);
alter table tmp_table add partition (vt=2000);
查看分区
SHOW PARTITIONS tmp_table;
插入数据
INSERT OVERWRITE TABLE tmp_table partition (vt=1000) SELECT passport,cid FROM memberbind limit 100000;
到底是什么意思