You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Sushil Mohanty (JIRA)" <ji...@apache.org> on 2015/12/17 15:09:46 UTC

[jira] [Updated] (LENS-905) Group by is not promoted when keys projected along with having clause

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

Sushil Mohanty updated LENS-905:
--------------------------------
    Component/s: cube

> Group by is not promoted when keys projected along with having clause
> ---------------------------------------------------------------------
>
>                 Key: LENS-905
>                 URL: https://issues.apache.org/jira/browse/LENS-905
>             Project: Apache Lens
>          Issue Type: Bug
>          Components: cube
>            Reporter: Sushil Mohanty
>            Assignee: Sushil Mohanty
>             Fix For: 2.5
>
>
> Cube rewriter rewrites query with distinct if only keys are projected and having specified. Instead it should promote group by with projected columns.
> for eg.
> select key1 from table having msr1 > 0 
> is being rewritten to "select distinct key1 from table having msr1 > 0 " but it supposed to be rewritten to 
> "select key1 from table group by key1 having msr1 > 0"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)