create table t_order(
orderid int,
name string
)
row format delimited
fields terminated by ",";
load data local inpath '/usr/datadir/order.txt' into table t_order;
create table t_goods(
goodid int,
price int
)
row format delimited
fields terminated by ",";
load data local inpath '/usr/datadir/goods.txt' into table t_goods;
Hive中的join分为了内连接、左外连接、右外连接、全外连接。
内连接:inner join
select *
from t_order
join t_goods
on orderid = goodid;
左外连接:
select *
from t_order
left join t_goods
on orderid = goodid;
右外连接:
select *
from t_order
right join t_goods
on orderid = goodid;
全外连接:
select *
from t_order
full join t_goods
on orderid = goodid;