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
...@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
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
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