[
https://issues.apache.org/jira/browse/LENS-835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14972973#comment-14972973
]
Hadoop QA commented on LENS-835:
--------------------------------
Applied patch:
[LENS-835.patch|https://issues.apache.org/jira/secure/attachment/12768571/LENS-835.patch]
and ran command: mvn clean install. Result: Failure. Build Job:
https://builds.apache.org/job/PreCommit-Lens-Build/147/
> Optimizing fact subquery by removing non aggregated expression columns from
> group by clause
> -------------------------------------------------------------------------------------------
>
> Key: LENS-835
> URL: https://issues.apache.org/jira/browse/LENS-835
> Project: Apache Lens
> Issue Type: Improvement
> Components: driver-jdbc
> Reporter: Sushil Mohanty
> Assignee: Sushil Mohanty
> Attachments: LENS-835.patch
>
>
> Currently the fact keys used in SQL are part of group by clause by default.
> If single row functions e.g case, having fact keys part of it and used in an
> aggregate expression such keys need to be removed from fact subquery group by
> clause.
> Eg. sum(case when fact.key1 = '123' then msr1 when fact.key2 = '345' then
> msr2 end)
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
