[jira] [Commented] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."
[ https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982910#comment-15982910 ] Hudson commented on LENS-1411: -- UNSTABLE: Integrated in Jenkins build Lens-Commit #1397 (See [https://builds.apache.org/job/Lens-Commit/1397/]) LENS-1411: Queries not rewritten correctly when aggregate expression (rajatgupta59: rev 7f3731ef49e7cc309620dd75bd679d7e8e29776e) * (edit) lens-cube/src/main/java/org/apache/lens/cube/parse/UnionQueryWriter.java > Queries not rewritten correctly when aggregate expression used inside "case > when..." > > > Key: LENS-1411 > URL: https://issues.apache.org/jira/browse/LENS-1411 > Project: Apache Lens > Issue Type: Bug > Components: cube >Reporter: Sushil Mohanty >Assignee: Sushil Mohanty > Fix For: 2.7 > > Attachments: LENS-1411.patch > > > Found error in rewritten query when aggregate expressions used inside "case > when" statement. > for eg : > {CODE} > CASE > WHEN (sum((db.msr1)) = 0) THEN 0 > ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000) > END AS `expr1` > {CODE} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."
[ https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980924#comment-15980924 ] Rajat Khandelwal commented on LENS-1411: Committed. Thanks [~sushilmohanty] > Queries not rewritten correctly when aggregate expression used inside "case > when..." > > > Key: LENS-1411 > URL: https://issues.apache.org/jira/browse/LENS-1411 > Project: Apache Lens > Issue Type: Bug > Components: cube >Reporter: Sushil Mohanty >Assignee: Sushil Mohanty > Fix For: 2.7 > > Attachments: LENS-1411.patch > > > Found error in rewritten query when aggregate expressions used inside "case > when" statement. > for eg : > {CODE} > CASE > WHEN (sum((db.msr1)) = 0) THEN 0 > ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000) > END AS `expr1` > {CODE} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."
[ https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15978533#comment-15978533 ] Hadoop QA commented on LENS-1411: - Applied patch: [LENS-1411.patch|https://issues.apache.org/jira/secure/attachment/12863776/LENS-1411.patch] and ran command: mvn clean install -fae. Result: Success. Build Job: https://builds.apache.org/job/PreCommit-Lens-Build/1260/ > Queries not rewritten correctly when aggregate expression used inside "case > when..." > > > Key: LENS-1411 > URL: https://issues.apache.org/jira/browse/LENS-1411 > Project: Apache Lens > Issue Type: Bug > Components: cube >Reporter: Sushil Mohanty >Assignee: Sushil Mohanty > Attachments: LENS-1411.patch > > > Found error in rewritten query when aggregate expressions used inside "case > when" statement. > for eg : > {CODE} > CASE > WHEN (sum((db.msr1)) = 0) THEN 0 > ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000) > END AS `expr1` > {CODE} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."
[ https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15978464#comment-15978464 ] Rajat Khandelwal commented on LENS-1411: +1 > Queries not rewritten correctly when aggregate expression used inside "case > when..." > > > Key: LENS-1411 > URL: https://issues.apache.org/jira/browse/LENS-1411 > Project: Apache Lens > Issue Type: Bug > Components: cube >Reporter: Sushil Mohanty >Assignee: Sushil Mohanty > Attachments: LENS-1411.patch > > > Found error in rewritten query when aggregate expressions used inside "case > when" statement. > for eg : > {CODE} > CASE > WHEN (sum((db.msr1)) = 0) THEN 0 > ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000) > END AS `expr1` > {CODE} -- This message was sent by Atlassian JIRA (v6.3.15#6346)