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 (...)
user@hive.apache.org
Reply-To: user@hive.apache.org
Subject: pblm in joining two tables in hive.
Hi,
In hive I have two tables fst is 'a' and 2nd is 'b'.
Now I want to display the data of 'a ' table which is not present in b
table.
Thnks
Manjinder
**
Hi,
In hive I have two tables fst is 'a' and 2nd is 'b'.
Now I want to display the data of 'a ' table which is not present in b
table.
Thnks
Manjinder
CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended so