hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tucker, Matt" <Matt.Tuc...@disney.com>
Subject Re: Parsing nested joins in Hive
Date Sat, 04 Aug 2012 02:40:49 GMT
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.avijit@oracle.com> wrote:

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

Mime
View raw message