hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navis류승우 <navis....@nexr.com>
Subject Re: Problem in Hive Right Outer Join
Date Mon, 12 Aug 2013 04:36:08 GMT
Could you upload DDLs for those tables? Thanks.

2013/8/8 Jérôme Verdier <verdier.jerome66@gmail.com>:
> Hi,
>
> I encountered a problem with Right Outer Join in Hive.
>
> Here is where is the problem :
>
>         FROM default.ca ca
>           JOIN default.kpi_magasin mtransf
>           ON  mtransf.co_societe = (CASE WHEN ca.co_societe = 1 THEN 1 ELSE
> 2 END)
>           AND mtransf.id_magasin = ca.id_magasin
>           RIGHT OUTER JOIN default.ssect_comptable a ON a.id_ssect_cpt =
> ca.id_ssect_cpt
>           JOIN default.ssect_comptable b ON a.co_ssect_cpt = b.co_ssect_cpt
> AND b.co_societe = 6
>           JOIN default.kpi_ssect_cpt s
>           ON  s.co_societe   = (CASE WHEN ca.co_societe = 1 THEN 1 ELSE 2
> END)
>           AND (CASE
>                 WHEN ca.co_societe = 6 THEN
>                   b.id_ssect_cpt
>                   ELSE s.id_ssect_cpt
>               END = ca.id_ssect_cpt)
>           AND s.niveau       = 3
>
> here is the error code :
>
> FAILED: SemanticException [Error 10017]: Line 94:16 Both left and right
> aliases encountered in JOIN 'id_ssect_cpt'
>
> I have try multiples option to resolve this error, but problem is still
> here.
>
> what is wrong  here?
>
> Thanks,
>
> --
> Jérôme
>
>
>

Mime
View raw message