SELECT
date_format(v1.year_month,'yyyy-MM'),
date_format(v2.year_month,'yyyy-MM') v2month,
date_format(v3.year_month,'yyyy-MM') v3month,
v1.region_code,
v1.ind_code,
v1.oper_rev_cum,
v2.oper_rev_cum,
v3.oper_rev_cum,
v2.oper_rev_cum - v1.oper_rev_cum,
(v2.oper_rev_cum - v1.oper_rev_cum)/v3.oper_rev_cum
FROM
fact_macroeconomic_region_industry_month v1
INNER JOIN fact_macroeconomic_region_industry_month v2
ON add_months(v1.year_month,-1) = v2.year_month
AND v1.region_code = v2.region_code
AND v1.ind_code = v2.ind_code
INNER join fact_macroeconomic_region_industry_month v3
ON add_months(v1.year_month,-12) = v3.year_month
AND v1.region_code = v3.region_code
AND v1.ind_code = v3.ind_code
where v1.ind_code='06'
hive 自连接计算环比、同比
最新推荐文章于 2023-03-27 00:43:16 发布