You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Divakar Tomar (JIRA)" <ji...@apache.org> on 2017/08/18 12:07:00 UTC

[jira] [Closed] (LENS-1334) Full outer join queries join conditions not rewritten correctly when more than two table involved

     [ https://issues.apache.org/jira/browse/LENS-1334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Divakar Tomar closed LENS-1334.
-------------------------------

This feature is not supported after fact-to-fact join as queries are written using union construct.

> Full outer join queries join conditions not rewritten correctly when more than two table involved
> -------------------------------------------------------------------------------------------------
>
>                 Key: LENS-1334
>                 URL: https://issues.apache.org/jira/browse/LENS-1334
>             Project: Apache Lens
>          Issue Type: Bug
>          Components: cube
>            Reporter: Sushil Mohanty
>            Assignee: Sushil Mohanty
>             Fix For: 2.7
>
>         Attachments: LENS-1334-1.patch
>
>
> Currently full outer join queries are written like below
> {CODE}
> ...from A full outer join B full outer join C on A.col = B.col and A.col = C.col
> {CODE}
> instead it should be rewritten as 
> {CODE}
> ...from A full outer join B  on a.col = b.col full outer join C on b.col = c.col
> {CODE}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)