Sushil Mohanty created LENS-1411:
------------------------------------

             Summary: 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


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