data_analysis/production_code/loghubods.operators_channel_spider_dt.sql

-- Task: 爬虫产品负责人_分区  ID: 1025579701  Type: ODPS_SQL
--odps sql 
--********************************************************************--
--author:于卓异
--create time:2025-04-28 11:13:49
--********************************************************************--
CREATE TABLE IF NOT EXISTS loghubods.operators_channel_spider_dt
(
    name     STRING
    ,channel STRING
    ,uid     STRING
    ,videoid STRING
)
PARTITIONED BY 
(
    dt       STRING COMMENT '分区'
)
STORED AS ALIORC
LIFECYCLE 60
;

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