RE: pblm in joining two tables in hive.....

2012-11-23 Thread Manjinder Singh01
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 (...)

Re: pblm in joining two tables in hive.....

2012-11-23 Thread Bejoy KS
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 **

pblm in joining two tables in hive.....

2012-11-23 Thread Manjinder Singh01
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