[
https://issues.apache.org/jira/browse/LENS-835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14973079#comment-14973079
]
Hudson commented on LENS-835:
-----------------------------
SUCCESS: Integrated in Lens-Commit-Java8 #25 (See
[https://builds.apache.org/job/Lens-Commit-Java8/25/])
LENS-835 : Optimizing fact subquery by removing non aggregated (amareshwari:
rev 1f885cd3d74310ea1cb4e2049692d53d49e5e7cc)
*
lens-driver-jdbc/src/test/java/org/apache/lens/driver/jdbc/TestColumnarSQLRewriter.java
*
lens-driver-jdbc/src/main/java/org/apache/lens/driver/jdbc/ColumnarSQLRewriter.java
> 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)
