Hive-关联查询

SQL语句逻辑执行顺序

		select
		          (4
		from      (1
		tb_name
		where     (2
		group by  (3
		having    (5
		order by  (6
		limit     (7

关联查询
join
inner join
left join
right join
full join
union
union all
left semi join

数据1：
1,a
2,b
3,c
建表
create table tb_a(
id int ,
name string
)
row format delimited fields terminated by ‘,’ ;
load data local inpath ‘/data/a/’ into table tb_a ;

数据2：
1,zss
2,lss
3,www
1,xxx
2,yyy
4,zzz
建表
create table tb_b(
id int ,
name string
)
row format delimited fields terminated by ‘,’ ;
load data local inpath ‘/data/b/’ into table tb_b ;
建好的两张表：
±---------±-----------+