[jira] [Updated] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."

2017-04-24 Thread Rajat Khandelwal (JIRA) 

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

[jira] [Updated] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."

2017-04-24 Thread Rajat Khandelwal (JIRA) 

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

Rajat Khandelwal updated LENS-1411:
---
Resolution: Fixed
Status: Resolved  (was: Patch Available)

> 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] [Updated] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."

2017-04-21 Thread Rajat Khandelwal (JIRA) 

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

Rajat Khandelwal updated LENS-1411:
---
Status: Patch Available  (was: Open)

> 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] [Updated] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."

2017-04-18 Thread Sushil Mohanty (JIRA) 

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