hive常用 select (查询)语法

1. inner join 用法,求交集

table1(id , name)
(1,小明)
(2,可可)
(3,罗伞)
table2(id ,salary)
(1,3200)
(2,2600)

select a.id,a.name,b.salary from table1 a join table2 b oon a.id=b.id;
(1,小明,3200)
(2,可可,2600)