-- Task: 渠道统计优化_分区  ID: 1025579802  Type: ODPS_SQL
--odps sql 
--********************************************************************--
--author:于卓异
--create time:2025-04-28 11:14:08
--********************************************************************--
CREATE TABLE IF NOT EXISTS operators_channel_dt
(
    `type`   STRING
    ,name    STRING
    ,uid     STRING
    ,videoid STRING
)
PARTITIONED BY 
(
    dt       STRING COMMENT '分区'
)
STORED AS ALIORC
LIFECYCLE 60
;

INSERT OVERWRITE TABLE operators_channel_dt PARTITION (dt = '${date}${hh}')
SELECT  *
FROM    operators_channel