[
https://issues.apache.org/jira/browse/LENS-905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15063666#comment-15063666
]
Hudson commented on LENS-905:
-----------------------------
SUCCESS: Integrated in Lens-Commit #1157 (See
[https://builds.apache.org/job/Lens-Commit/1157/])
LENS-905 : Group by is not promoted when keys projected along with
(sushilmohanty: rev c17908134e004c646724d7e464252ec76a43113d)
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestAggregateResolver.java
* lens-cube/src/main/java/org/apache/lens/cube/parse/AggregateResolver.java
> 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
>
> Attachments: LENS-905.patch
>
>
> 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.
> cube select key1 from table having msr1 > 0
> is being rewritten to "select distinct key1 from table having sum(msr1) > 0 "
> but it supposed to be rewritten to
> "select key1 from table group by key1 having sum(msr1) > 0"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
