[ 
https://issues.apache.org/jira/browse/LENS-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajat Khandelwal updated LENS-1411:
-----------------------------------
    Fix Version/s: 2.7

> 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)

Reply via email to