[jira] [Resolved] (QUICKSTEP-50) Finding and eliminating common sub-expression in aggregation

["Zuyu Zhang (JIRA)" <ji...@apache.org>]

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

Zuyu Zhang resolved QUICKSTEP-50.
---------------------------------
    Resolution: Duplicate

> Finding and eliminating common sub-expression in aggregation
> ------------------------------------------------------------
>
>                 Key: QUICKSTEP-50
>                 URL: https://issues.apache.org/jira/browse/QUICKSTEP-50
>             Project: Apache Quickstep
>          Issue Type: New Feature
>          Components: Expressions, Relational Operators
>            Reporter: Harshad Deshmukh
>
> Background: Sometimes in aggregation, some expressions share a common sub-expression which can potentially be computed only once. For instance in TPC-H Q1 sum(lo_quantity) and avg(lo_quantity) can be computed only once and finally share the computation. 
> Proposed solution: Optimizer should find such common sub-expressions and pass the information to the relational operator. The aggregation operator will compute only one common sub expression. In the Finalize aggregation operator, we can share the common sub expression among the consumer aggregation handles and let them compute the final result. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)