RE: LEFT OUTER JOIN and partition

2012-01-02 Thread mdefoinplatel.ext
De : mdefoinplatel@orange.com [mailto:mdefoinplatel@orange.com] Envoyé : jeudi 22 décembre 2011 14:29 À : hive-u...@hadoop.apache.org Objet : LEFT OUTER JOIN and partition Hi folks, Ok, I give you the context first : I have seen in the mailing list people advising the us

Re: LEFT OUTER JOIN and partition

2011-12-22 Thread Mark Grover
...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. - Original Message - From: "mdefoinplatel ext" To: user@hive.apache.org Sent: Thursday, December 22, 2011 11:37:30 A

RE: LEFT OUTER JOIN and partition

2011-12-22 Thread mdefoinplatel.ext
2011 14:29 À : hive-u...@hadoop.apache.org Objet : LEFT OUTER JOIN and partition Hi folks, Ok, I give you the context first : I have seen in the mailing list people advising the use of a ... LEFT OUTER JOIN ON ... followed by a WHERE close to write a NOT IN type of query. So to make it clear, it

LEFT OUTER JOIN and partition

2011-12-22 Thread mdefoinplatel.ext
Hi folks, Ok, I give you the context first : I have seen in the mailing list people advising the use of a ... LEFT OUTER JOIN ON ... followed by a WHERE close to write a NOT IN type of query. So to make it clear, it should be possible to rewrite the following query: SELECT a.id FROM a WHERE a.id