Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> pblm in joining two tables in hive.....


Copy link to this message
-
RE: pblm in joining two tables in hive.....
Thank u…. ☺

From: Bejoy KS [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2012 3:20 PM
To: [EMAIL PROTECTED]
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 (...) WHERE B.clmn IS NULL.
Regards
Bejoy KS

Sent from handheld, please excuse typos.
________________________________
From: Manjinder Singh01 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Fri, 23 Nov 2012 09:03:06 +0000
To: [EMAIL PROTECTED]<[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]%[EMAIL PROTECTED]>>
ReplyTo: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
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

**************** CAUTION - Disclaimer *****************

This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely

for the use of the addressee(s). If you are not the intended recipient, please

notify the sender by e-mail and delete the original message. Further, you are not

to copy, disclose, or distribute this e-mail or its contents to any other person and

any such actions are unlawful. This e-mail may contain viruses. Infosys has taken

every reasonable precaution to minimize this risk, but is not liable for any damage

you may sustain as a result of any virus in this e-mail. You should carry out your

own virus checks before opening the e-mail or attachment. Infosys reserves the

right to monitor and review the content of all messages sent to or from this e-mail

address. Messages sent to or from this e-mail address may be stored on the

Infosys e-mail system.

***INFOSYS******** End of Disclaimer ********INFOSYS***
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB