sql数据库建表语句
DROP TABLE IF EXISTS DWM.TB_D_fms_rule_result_data;
CREATE TABLE DWM.TB_D_fms_rule_result_data(
day_id string comment '',
CALLING_NBR string comment '',
VOICE_CALLING_OPERATOR string comment '',
cdr_count string comment '',
DURATION string comment '')
comment '结果表'
partitioned by (p_day_id string)
row format delimited
fields terminated by '|' ;
GP数据库建表语句
DROP TABLE IF EXISTS fi_dwa.TB_D_fms_rule_result_d;
CREATE TABLE fi_dwa.TB_D_fms_rule_result_d(
day_id VARCHAR ,
CALLING_NBR VARCHAR,
VOICE_CALLING_OPERATOR VARCHAR,
cdr_count VARCHAR,
DURATION VARCHAR,
p_day_id VARCHAR
) DISTRIBUTED by (p_day_id);