MySQL，Hive 表结合方式：

左结合：

select * from tableA left join tableB on A.key =B.key;

右结合：

select * from tableA right join tableB on A.key =B.key;

左结合右为空：

select * from tableA left join tableB on A.key =B.key where B.key is null;

取交集：

select * from tableA inner join tableB on A.key =B.key ;

右结合左为空：

select* from tableA right join tableB on A.key =B.key where A.key is null;

全结合：

select * from tableA full join tableB on A.key =B.key ;

去交集：

select * from tableA right join tableB on A.key =B.key where A.key is null and B.key is null;