hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ayon Sinha <ayonsi...@yahoo.com>
Subject Re: Hive: Issue with JOIN on tables in a database namespace
Date Sun, 20 Nov 2011 05:59:56 GMT
Have you tried using table aliases? What errors do you see?

Sent from my iPhone

On Nov 19, 2011, at 8:44 PM, Daniel Godfrey <c.daniel.godfrey@gmail.com> wrote:

> Hey everyone, 
> 
> I'm having issues trying to execute a simple join on two tables that are in the same
database namespace. I'm trying to following:
> 
> SELECT namespace.table1.* FROM namespace.table1 JOIN namespace.table2 ON (namespace.table1.field1
= namespace.table2.field2);
> 
> If I move the tables outside of the database namespace, I can perform the join just fine.

> 
> Is it not possible to join tables within a database? Or am I missing something?
> 
> Cheers, 
> 
> -- 
> C. Daniel Godfrey
> 
> -4th Year Software Engineering Student at the University of Ottawa
> 
> 

Mime
View raw message