Re: Parsing nested joins in Hive

[Tucker, Matt]

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, at 6:17 PM, "kumar avijit" <avijit.kumar.avi...@oracle.com> 
wrote:

> select * from orderdetails left semi join ( orders left semi join 
> sites on (sites.siteid = orders.siteid) ) on 
> (orderdetails.orderid=orders.orderid);