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 Plain View
Hive >> mail # user >> Joining between table of different databases


+
hadoop hive 2012-01-31, 07:33
Copy link to this message
-
Re: Joining between table of different databases
Yes, you can do it :). Are you having any problems doing it – if so, what are the errors you are seeing?

You should be able to use db.table_name in your joins. HiveQL doesn't seem to like db.table_name.column notation – so you may have to use "db.table_name as foo", and foo.column instead. Otherwise, it does seem to work.

Sriram

From: hadoop hive <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Tue, 31 Jan 2012 13:03:52 +0530
To: <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Joining between table of different databases

hey folks,

Any1 have idea about joining two tables of different databases in hive(0.7.0).

regards
Vikas Srivastava
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