Amareshwari Sriramadasu created LENS-788:
--------------------------------------------
Summary: Option to do flattening of columns on bridge tables to
later
Key: LENS-788
URL: https://issues.apache.org/jira/browse/LENS-788
Project: Apache Lens
Issue Type: Improvement
Components: cube
Affects Versions: 2.4
Reporter: Amareshwari Sriramadasu
Assignee: Amareshwari Sriramadasu
Fix For: 2.5
With support to flatten (aggregate) columns from bridge table joins added in
LENS-752, this is enhancement to apply aggregate later to applying filters or
expression over the columns.
For ex :
With schema example given LENS-752, if user queries revenue with a filter :
cube select usersport.name, revenue where time_range_in(dt,x,y) and
usersport.name in ('Cricket').
The query should have an option to apply filter before aggregate or not.
Similarly :
cube select (case when usersport.name='cricket' then 'CKT' when
usersport.name='football' then 'FB' else 'NA' end), revenue where
time_range_in(dt,x,y).
The query should have option to apply expression before aggregate or not.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
