hive常见demo

1、插入demo数据

注意，分区要带引号，比如kpi_branch=‘$kpi_branch’，且引号要和sql整体引号错开（分别使用单双引号）；一定要带一个虚拟的from，否则报错。

(1)单分区case

table_name="table_name_xxx"
dt='20220101'
sql="
insert overwrite table ${table_name} partition(dt='${dt}')
select
	*
from
	(
		select
		1 as uv,
		1 as expo,
		1 as ia_num,
		1 as click_num,
		1 as read_duration,
		1 as qianbao_ia,
		1 as qianboa_click,
		1 as duration_per_mid,
		1 as duration_per_uid,
		1 as liucun
	)table
"
echo $sql
hive -e "$sql"

(2)多分区case

table_name="table_name_xxx"
dt='20220101'
kpi_branch='test'
sql="
insert into table ${table_name} partition(dt='$dt',kpi_branch='$kpi_branch')
select
	*
from
	(
	select
	1 as uv,
	1 as expo,
	1 as ia_num,
	1 as click_num,
	1 as read_duration,
	1 as qianbao_ia,
	1 as qianboa_click,
	1 as duration_per_mid,
	1 as duration_per_uid,
	1 as liucun
	)table
"
echo $sql
hive -e "$sql"