hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Msr Msr <msrmaill...@gmail.com>
Subject Re: left join error
Date Tue, 06 Oct 2015 13:54:02 GMT
Try using alias qualified columns fir common columns in bith
tables...something like this one
select date_key,ref, '' from master_request_tab a left join dm_search_eng b
on substr(ref, 1,length(a.engine)) = b.engine where a.engineis null;
On Oct 6, 2015 9:19 AM, "Garry Chen" <gc92@cornell.edu> wrote:

> Hi All,
>
>                 Do you guys see any error in the following left join sql
> statement?  However,  the hive give me error as “Error: Error while
> compiling statement: FAILED: SemanticException [Error 10017]: Line 1:75
> Both left and right aliases encountered in JOIN 'engine'
> (state=42000,code=10017)”.  Please let me kow where I am doing wrong.
> Thank you.
>
>
>
> select date_key,ref, '' from master_request_tab left join dm_search_eng on
> substr(ref, 1, length(engine)) = engine where engine is null;
>
>
>
>
>
>
>

Mime
View raw message