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;
文章来源：https://www.toymoban.com/news/detail-513482.html
文章来源地址https://www.toymoban.com/news/detail-513482.html
2、pg库
pg库建表语句
DROP TABLE IF EXISTS fi_dwa.tmp_001;
CREATE TABLE "fi_dwa"."tmp_001" (
"etl_time" timestamp(6),
"day_id" 到了这里，关于hive、pg库，建表语句及查询表结构语句的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
