[ https://issues.apache.org/jira/browse/LENS-1273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15561809#comment-15561809 ]
Rajat Khandelwal commented on LENS-1273: ---------------------------------------- Committed. Thanks [~amareshwari] > Resolve issues with case when aggregate expressions with dim-attributes > conditions > ----------------------------------------------------------------------------------- > > Key: LENS-1273 > URL: https://issues.apache.org/jira/browse/LENS-1273 > Project: Apache Lens > Issue Type: Improvement > Components: cube > Reporter: Amareshwari Sriramadasu > Assignee: Amareshwari Sriramadasu > Fix For: 2.7 > > Attachments: LENS-1273.2.patch, LENS-1273.3.patch, LENS-1273.patch > > > Right now, users write query like the following : > select sum(case when dim1=x then msr1 else 0 end), msr2 from cube where > time_range_in(...) > And if dim1 and msr2 are not queryable, query fails saying Fields cannot be > queried together. > but the query should be accepted. > The same works fine if the above is created as cube expression. -- This message was sent by Atlassian JIRA (v6.3.4#6332)