Re: LEFT OUTER JOIN and partitioned tables

2011-07-10 Thread Wouter de Bie
Hi all, I've solved the issue by setting hive.outerjoin.supports.filters=false. What does this setting do? It's completely undocumented. --Wouter de Bie Developer Business Intelligence, Spotify wou...@spotify.com +46 72 018 0777 This e-mail (including any attachments) may contain information t

LEFT OUTER JOIN and partitioned tables

2011-07-08 Thread Wouter de Bie
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 FR