建表模板
CREATE TABLE "off_net" (
"TIME_DAY" datetime DEFAULT NULL,
"CALLING_DN" varchar(50) DEFAULT NULL,
"CALLED_DN" varchar(50) DEFAULT NULL,
"CONN_TIME" float DEFAULT NULL,
"CALL_ALL_NUM" bigint(20) DEFAULT NULL,
"NO_CALLEDBACK" decimal(10,0) DEFAULT NULL,
"USER_COUNT" decimal(10,0) DEFAULT NULL,
"CALL_BACK" decimal(10,0) DEFAULT NULL,
"AREA_NAME" varchar(200) DEFAULT NULL,
"MKT_AREA_NAME" varchar(200) DEFAULT NULL,
"CUST_AGE" bigint(20) DEFAULT NULL,
"CUST_TYPE_NAME" varchar(16) DEFAULT NULL,
"VIP_LEVEL_NAME" varchar(16) DEFAULT NULL,
"INNET_datetime" datetime DEFAULT NULL,
"EFF_datetime" datetime DEFAULT NULL,
"EXP_datetime" datetime DEFAULT NULL,
"PROD_OFFER_NAME" varchar(255) DEFAULT NULL,
"CHARGE" decimal(10,0) DEFAULT NULL,
"PROD_ADDR" varchar(255) DEFAULT NULL,
"CALL_RESPON_NUM" bigint(20) DEFAULT NULL
) COMPRESS(5, 5) ENGINE=EXPRESS REPLICATED DEFAULT CHARSET=utf8 TABLESPACE='bigdata'
COMPRESS(5, 5) 压缩比
REPLICATED 复制表
CHARSET=utf8 字符编码
TABLESPACE='bigdata' 指定表空间