[
https://issues.apache.org/jira/browse/LENS-788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15217463#comment-15217463
]
Hudson commented on LENS-788:
-----------------------------
SUCCESS: Integrated in Lens-Commit #1215 (See
[https://builds.apache.org/job/Lens-Commit/1215/])
LENS-788 : Push expressions before flattening and convert filters to
(amareshwari: rev dba885ca972e8a11281f1bc44ceb4b7dd3906ce0)
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestHQLParser.java
* lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
* lens-cube/src/main/java/org/apache/lens/cube/parse/CubeQueryConfUtil.java
* tools/conf/client/lens-client-site.xml
* lens-cube/src/main/java/org/apache/lens/cube/parse/QueryAST.java
* lens-examples/src/main/resources/interests-local-part.xml
* lens-cube/src/main/java/org/apache/lens/cube/parse/DimOnlyHQLContext.java
* lens-examples/src/main/resources/cube-queries.sql
* lens-cube/src/main/java/org/apache/lens/cube/parse/JoinResolver.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/CubeTestSetup.java
* lens-examples/src/main/resources/customer-interests.xml
* lens-cube/src/main/java/org/apache/lens/cube/parse/CubeQueryContext.java
* lens-cube/src/main/resources/olap-query-conf.xml
*
lens-cube/src/main/java/org/apache/lens/cube/parse/SingleFactMultiStorageHQLContext.java
*
lens-cube/src/main/java/org/apache/lens/cube/parse/SingleFactSingleStorageHQLContext.java
*
lens-cube/src/test/java/org/apache/lens/cube/parse/join/TestBridgeTableJoinCtx.java
* src/site/apt/user/olap-query-conf.apt
* lens-cube/src/main/java/org/apache/lens/cube/parse/HQLParser.java
* lens-examples/src/main/resources/customer_interests_table.xml
* lens-examples/src/main/resources/interests.xml
*
lens-cube/src/test/java/org/apache/lens/cube/parse/TestDefaultAliasDecider.java
*
lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestBridgeTableQueries.java
* lens-cube/src/main/java/org/apache/lens/cube/parse/DimHQLContext.java
* lens-examples/src/main/resources/sales-cube.xml
* lens-examples/src/main/resources/db-storage-schema.sql
* lens-cube/src/main/java/org/apache/lens/cube/parse/MultiFactHQLContext.java
* lens-dist/src/main/assembly/bin-dist.xml
* lens-examples/src/main/resources/interests_table.xml
* lens-examples/src/main/resources/customer-interests-local-part.xml
* src/site/apt/user/olap-cube.apt
* lens-cube/src/main/java/org/apache/lens/cube/parse/DefaultAliasDecider.java
* lens-examples/src/main/resources/customer-interests-local.data
* lens-cube/src/main/java/org/apache/lens/cube/parse/DefaultQueryAST.java
* lens-cube/src/main/java/org/apache/lens/cube/parse/CandidateFact.java
*
lens-cube/src/main/java/org/apache/lens/cube/parse/join/BridgeTableJoinContext.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestQuery.java
* lens-examples/src/main/resources/interests-local.data
* lens-cube/src/main/java/org/apache/lens/cube/parse/join/AutoJoinContext.java
> Option to do flattening of columns on bridge tables 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.6
>
> Attachments: LENS-788.4.patch
>
>
> 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)
