[
https://issues.apache.org/jira/browse/PHOENIX-71?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13956017#comment-13956017
]
Hudson commented on PHOENIX-71:
-------------------------------
SUCCESS: Integrated in Apache Phoenix - Branch:master #203 (See
[https://builds.apache.org/job/Phoenix/203/])
PHOENIX-71 Support sub-joins (maryannxue: rev
12bd7aeddd4e25a754b76c3f05b00730c4304644)
* phoenix-core/src/main/java/org/apache/phoenix/optimize/QueryOptimizer.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeRewriter.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/HashJoinIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
*
phoenix-core/src/test/java/org/apache/phoenix/compile/JoinQueryCompilerTest.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/StatementNormalizer.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/DerivedTableNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/TableNodeVisitor.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/NamedTableNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeFactory.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/JoinPartNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/JoinTableNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/SelectStatement.java
* phoenix-core/src/main/antlr3/PhoenixSQL.g
* phoenix-core/src/main/java/org/apache/phoenix/compile/FromCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/BindTableNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/TableNode.java
> Support sub-joins
> -----------------
>
> Key: PHOENIX-71
> URL: https://issues.apache.org/jira/browse/PHOENIX-71
> Project: Phoenix
> Issue Type: New Feature
> Affects Versions: 3.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
>
> Support join table as sub-join. (currently join table can only be a named
> table)
> For example,
> select * from A left join (B join C on B.bc_id = C.bc_id) on A.ab_id =
> B.ab_id and A.ac_id = C.ac_id;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
