[
https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Divakar Tomar closed LENS-1411.
-------------------------------
verified
> 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.4.14#64029)
