hive脚本模板

–task_name :dwd_xxx.sql
–chinese_name :xxx表
–input_table :dwr.dwd_xxx
–output_table :dwr.dwd_xxx
–developers :xxx
–create_date :2022-05-26
–update_info :2022-05-30

set mapred.job.name = dwr.dwd_xxx.developer_id.${hiveconf:date};
–其他参数

create table if not exists dwr_xxx.dwd_xxx
(
a string comment ‘’
,b bigint comment ‘’
,g int comment ‘’
)
comment ‘’
partitioned by (p1 string comment ‘’,p2 string comment ‘’)
row format delimited
fields terminated by ‘\001’
lines terminated by ‘\n’
stored as orc
;

–创建临时表
drop table if exists dwr_xxx_tmp.dwd_xxx_KaTeX parse error: Expected group after '_' at position 67: …xxx_tmp.dwd_xxx_̲{hiveconf:date}_00 stored as orc as
select
a
,b
from ods_xxx
;

–更新目标表
insert overwrite table dwr_xxx.dwd_xxx
partition (p1,p2)
select
a
,b
from xxx
;
–删除临时表
drop table if exists dwr_xxx_tmp.dwd_xxx_${hiveconf:date}_00;