Hi,
Try the following statement instead:
Select *
from orderdetails
left semi join (
select orderid
from orders
left semi join sites on
orders.siteid = sites.siteid
) orders on
orderdetails.orderid = orders.orderid;
Matt
On Aug 3, 2012
Hi Hive users,
According to the grammar for Joins at
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins,
Hive should be able to parse joins where the table reference on the
right-hand side is itself a join. For instance, one should be able to
specify (a join (b join c)) as:
