--原数据
[root@master]# vi a_base_tab.txt
1001,sunwukong,assassin,male
1002,HANXIN,assassin,male
[root@master]# vi i_base_tab.txt
1002,hanxin,assassin,male
1003,zhaoyun,assassin,male
--上传数据
[root@master]# hadoop fs -put a_base_tab.txt /user/hive/external/a_base_tab
[root@master]# hadoop fs -put i_base_tab.txt /user/hive/external/i_base_tab
--创建外部表 a_base_tab
create external table a_base_tab
(id string,name string,job string,sex string)
row format delimited fields terminated by ','
location '/user/hive/external/a_base_tab';
--创建外部表 i_base_tab
create external table i_base_tab
(id string,name string,job string,sex string)
row format delimited fields terminated by ','
location '/user/hive/external/i_base_tab';
--测试 full outer 语法
select a.*,i.* from a_base_tab a full outer join i_base_tab i on a.id=i.id;