sql中分区表partition建立举例

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;