How to realize Multi-table Association in hive

This article will explain in detail how to achieve multi-table association in hive. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Use noc_dpi;CREATE table IF NOT EXISTS tmp_yym_app (appname STRING, mdn_num int, inputoctets int,outputoctet int) row format delimited fields terminated by'| 'stored as textfile location' / user/noc/private/tmp_yym_app' Insert overwrite table tmp_yym_appselect tt.appname,count (distinct mdn), sum (tt.inputoctets) Sum (tt.outputoctets) from (select t..from NOC_3G_APP_USER_SUMMARY t join liming_test_mdn m on t.mdn=m.mdn and m.mdnails' and m.mdn is not null where t.dt=$appdate1union all select t.* from NOC_4G_APP_USER_SUMMARY t join liming_test_mdn m on t.mdn=m.mdn and m.mdnails' and m.mdn is not null where t.dt=$appdate1) tt group by tt.appname on "how to implement multiple tables in hive" That's all for the article "relevance". Hope that the above content can be helpful to you, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.