hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wouter de Bie <wou...@spotify.com>
Subject LEFT OUTER JOIN and partitioned tables
Date Fri, 08 Jul 2011 11:32:10 GMT
Hi all,

I'm experiencing problems with using LEFT OUTER JOIN with partitioned tables. The following
example works as expected:

SELECT
a.val1,
b.val2
FROM a
JOIN b ON
a.val1 = b.val1 AND
a.dt = 20110708
b.dt = 20110708

But when I change it to use a LEFT OUTER JOIN like:

SELECT
a.val1,
b.val2
FROM a
LEFT OUTER JOIN b ON
a.val1 = b.val1 AND
a.dt = 20110708 AND
b.dt = 20110708

On rows where there is a record in both a and b, I get something like

a.val1, NULL
a.val1, b.val2

I would expect that the first row (a.val1, NULL) would not be there.

Am I doing something wrong?

// Wouter 
Mime
View raw message