DROP TABLE IF EXISTS tableresult;
CREATE TABLE IF NOT EXISTS tableresult (
planid BIGINT COMMENT '用户id',
totalday BIGINT,
itemData STRING COMMENT '推荐的任务组-任务list',
bizTime DATETIME COMMENT '大数据的数据源的时间(天)',
updateTime DATETIME COMMENT '数据更新时间',
versionNo BIGINT COMMENT '大数据的数据版本'
)
PARTITIONED BY (
publishday STRING,
dsplan_id STRING
);
INSERT OVERWRITE TABLE tableresult PARTITION (publishday, dsplan_id)
SELECT u.planid AS planid, u.totalday AS totalday, u.itemData AS itemData
, u.bizTime AS bizTime, u.updatetime AS updatetime, u.versionno AS versionno, u.publishday AS publishday, u.dsplan_id AS dsplan_id
FROM table u;
sql中分区表partition建立举例
最新推荐文章于 2020-04-17 22:24:00 发布