Thank u…. ☺
From: Bejoy KS [mailto:bejoy...@yahoo.com]
Sent: Friday, November 23, 2012 3:20 PM
To: user@hive.apache.org
Subject: Re: pblm in joining two tables in hive.
Hi
Do a Left outer join A to B and do a null check on B's columns.
SELECT A.* FROM A LEFT OUTER JOIN B ON (...)
Hi
Do a Left outer join A to B and do a null check on B's columns.
SELECT A.* FROM A LEFT OUTER JOIN B ON (...) WHERE B.clmn IS NULL.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Manjinder Singh01
Date: Fri, 23 Nov 2012 09:03:06
To: user@hive.ap
