Hive的连接操作

连接
---------------
//创建orders表。
CREATE TABLE orders
(
id int,
orderno string ,
price float,
cid int
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;


//笛卡尔积
select a.*,b.* from custs a , orders b ;


//内连接
select a.*,b.* from custs a inner join orders b on a.id = b.cid ;


//左外连接
select a.*,b.* from custs a left outer join orders b on a.id = b.cid ;


//半连接,只查询左边的表
select a.* from custs a left outer join orders b on a.id = b.cid ;


//右外
select a.*,b.* from custs a right outer join orders b on a.id = b.cid ;


//全外
select a.*,b.* from custs a full outer join orders b on a.id = b.cid ;