You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Sushil Mohanty (JIRA)" <ji...@apache.org> on 2017/04/18 08:50:41 UTC
[jira] [Updated] (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:all-tabpanel ]
Sushil Mohanty updated LENS-1411:
---------------------------------
Attachment: LENS-1411.patch
Small change, attaching patch directly in the ticket.
> 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)