1、hive
hive 建表语句
DROP TABLE IF EXISTS tmp_001;
CREATE TABLE tmp_001 (
etl_time timestamp comment '',
day_id double comment '',
subs_id string comment '',
msisdn int comment ''
)
comment ''
partitioned by (p_day_id string)
row format delimited
fields terminated by '|' ;
hive 查询表结构语句
show create table tmp_001;
desc tmp_001;
2、pg库
pg库建表语句
DROP TABLE IF EXISTS fi_dwa.tmp_001;
CREATE TABLE "fi_dwa"."tmp_001" (
"etl_time" timestamp(