correlated subquery in hive

simran_k — Wed, 27 Jul 2016 14:30:57 GMT

How to use data from outer query in the inner query or subquery in hive?I am trying to use ndo.FromDate and ndo.ToDate in the second JOIN but that would not work

LEFT JOIN 
Temp.NumberOfDaysOnline ndo
ON
ndo.sku = nr.sku
JOIN
gadb.gasessiondata gasessiondata
ON 
1=1
LEFT JOIN 
(
 SELECT SUM(gasessiondata.sessions) As visitsOnDaysSKUWasLive
 FROM 
 gadb.gasessiondata gasessiondata
 WHERE 
 gasessiondata.date >= ndo.FromDate
 AND 
 gasessiondata.date < ndo.ToDate
 ) AS visits

Re: correlated subquery in hive

cstanca — Tue, 27 Dec 2016 06:38:31 GMT

@Simran Kaur

You need to use a join or a sub-query within the sub-query. You can access out query from inner query. It is the other way around and by design for any SQL-like language.

question correlated subquery in hive in Archives of Support Questions (Read Only)

correlated subquery in hive

Re: correlated subquery in hive