Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Joining between table of different databases


Copy link to this message
-
Re: Joining between table of different databases
Sriram Krishnan 2012-01-31, 16:27
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