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)