hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sriram Krishnan <>
Subject Re: Joining between table of different databases
Date Tue, 31 Jan 2012 16:27:44 GMT
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.


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

hey folks,

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

Vikas Srivastava

View raw message