[
https://issues.apache.org/jira/browse/LENS-835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14973060#comment-14973060
]
Amareshwari Sriramadasu commented on LENS-835:
----------------------------------------------
Committed. Thanks [~sushilmohanty] !
> 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
> Fix For: 2.5
>
> 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)
