创建宽带(细分市场)表样sheet1 - DM_M_YX_KD_YXD_1
CREATE TABLE IF NOT EXISTS DM_M_YX_KD_YXD_1(\n month_id STRING COMMENT '账期',\n prov_name STRING COMMENT '省分',\n xfsc_type STRING COMMENT '细分市场',\n is_innet DOUBLE COMMENT '在网用户数(户)',\n acct_tag DOUBLE COMMENT '出账用户数(户)',\n total_fee DOUBLE COMMENT '本月收入(万)',\n is_this_break DOUBLE COMMENT '离网用户(户)',\n is_this_dev DOUBLE COMMENT '当月新增用户(户)',\n total_fee_dev DOUBLE COMMENT '当月新增用户收入(万)'\n) \nPARTITIONED BY (\n month_id STRING\n) \nSTORED AS ORC\nTBLPROPERTIES (\n 'COMMENT' = '宽带(细分市场)表样sheet1'\n);
原文地址: https://www.cveoy.top/t/topic/p4p2 著作权归作者所有。请勿转载和采集!