[jira] [Created] (LENS-788) Option to do flattening of columns on bridge tables to later

["Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>]

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)