[ 
https://issues.apache.org/jira/browse/PHOENIX-944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14182436#comment-14182436
 ] 

Hudson commented on PHOENIX-944:
--------------------------------

SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #286 (See 
[https://builds.apache.org/job/Phoenix-3.0-hadoop1/286/])
PHOENIX-944 Support derived tables in FROM clause that needs extra steps of 
client-side aggregation or other processing (maryannxue: rev 
2bdc33bc58739606111157539ad9a066368dd03a)
* 
phoenix-core/src/main/java/org/apache/phoenix/compile/TrackOrderPreservingExpressionCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java.orig
* phoenix-core/src/main/java/org/apache/phoenix/compile/SubqueryRewriter.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ClientAggregatePlan.java
* 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/GroupByCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/FromCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeFactory.java
* 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/HashJoinRegionScanner.java
* 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/GroupedAggregateRegionObserver.java
* 
phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseGroupedAggregatingResultIterator.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/ProjectedColumnExpression.java
* 
phoenix-core/src/main/java/org/apache/phoenix/execute/ClientProcessingPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/SelectStatement.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/TupleProjectionPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/ColumnRef.java
* 
phoenix-core/src/main/java/org/apache/phoenix/iterate/GroupedAggregatingResultIterator.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OrderByCompiler.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
* 
phoenix-core/src/main/java/org/apache/phoenix/iterate/LookAheadResultIterator.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SubqueryIT.java
* phoenix-core/src/main/java/org/apache/phoenix/optimize/QueryOptimizer.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/HashJoinPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/TupleProjector.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/ClientScanPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/join/TupleProjector.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/DistinctValueClientAggregator.java
* 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/ScanRegionObserver.java


> Support derived tables in FROM clause that needs extra steps of client-side 
> aggregation or other processing
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-944
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-944
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0, 5.0.0
>            Reporter: Maryann Xue
>            Assignee: Maryann Xue
>             Fix For: 3.0.0, 4.0.0, 5.0.0
>
>         Attachments: 944-3.patch, 944.patch
>
>   Original Estimate: 168h
>  Remaining Estimate: 168h
>
> Groupby in both outer and inner queries cannot be flattened. We can apply an 
> extra step of client-side aggregation to handle such cases.
> See DerivedTableIT.java for all those examples that are currently not 
> supported.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to