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 <hadooph...@gmail.com<mailto:hadooph...@gmail.com>> Reply-To: <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Tue, 31 Jan 2012 13:03:52 +0530 To: <user@hive.apache.org<mailto:user@hive.apache.org>> 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
