[
https://issues.apache.org/jira/browse/TAJO-680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696436#comment-14696436
]
Hudson commented on TAJO-680:
-----------------------------
FAILURE: Integrated in Tajo-master-build #799 (See
[https://builds.apache.org/job/Tajo-master-build/799/])
TAJO-680: Improve the IN operator to support sub queries. (jihoonson: rev
042c3e882fbb45fffc6fc2988588282ed085614c)
*
tajo-plan/src/main/java/org/apache/tajo/plan/serder/LogicalNodeDeserializer.java
*
tajo-core/src/test/resources/results/TestInSubquery/testNestedInSubQuery2.result
*
tajo-core/src/test/resources/queries/TestInSubquery/testInSubQueryWithOtherConditions.sql
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/BasicEvalNodeVisitor.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/SimpleTableSubQuery.java
*
tajo-core/src/test/resources/queries/TestInSubquery/testSameKeyNameOfOuterAndInnerQueries.sql
* tajo-plan/src/main/java/org/apache/tajo/plan/verifier/LogicalPlanVerifier.java
* tajo-core/src/test/resources/results/TestInSubquery/testInSubQuery.result
* tajo-plan/src/main/java/org/apache/tajo/plan/logical/RelationNode.java
* tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java
*
tajo-core/src/test/resources/queries/TestInSubquery/testNestedInAndNotInSubQuery.sql
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/SimpleEvalNodeVisitor.java
* tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanPreprocessor.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalNodeVisitor2.java
* tajo-plan/src/main/java/org/apache/tajo/plan/algebra/AlgebraVisitor.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/rules/ProjectionPushDownRule.java
* tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlan.java
* tajo-core/src/test/resources/queries/TestInSubquery/testInAndNotInSubQuery.sql
* tajo-plan/src/main/java/org/apache/tajo/plan/ExprAnnotator.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/BaseLogicalPlanRewriteRuleProvider.java
*
tajo-core/src/test/resources/queries/TestInSubquery/testInSubQueryWithTableSubQuery.sql
* tajo-algebra/src/main/java/org/apache/tajo/algebra/RelationList.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/CommonSubquery.java
* tajo-core/src/test/java/org/apache/tajo/QueryTestCaseBase.java
* tajo-plan/src/main/java/org/apache/tajo/plan/visitor/SimpleAlgebraVisitor.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/RowConstantEval.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/ExistsPredicate.java
* tajo-algebra/src/main/java/org/apache/tajo/algebra/OpType.java
*
tajo-core/src/test/resources/results/TestInSubquery/testSameKeyNameOfOuterAndInnerQueries.result
*
tajo-plan/src/main/java/org/apache/tajo/plan/joinorder/GreedyHeuristicJoinOrderAlgorithm.java
* CHANGES
* tajo-plan/src/main/java/org/apache/tajo/plan/serder/LogicalNodeSerializer.java
* tajo-core/src/test/resources/results/TestInSubquery/testInSubQuery2.result
*
tajo-core/src/test/resources/results/TestInSubquery/testInSubQueryWithJoin.result
* tajo-plan/src/main/proto/Plan.proto
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/ValueSetEval.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestInSubquery.java
*
tajo-core/src/test/resources/results/TestInSubquery/testInAndNotInSubQuery.result
* tajo-plan/src/main/java/org/apache/tajo/plan/serder/EvalNodeSerializer.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/SubqueryEval.java
* tajo-plan/src/main/java/org/apache/tajo/plan/LogicalOptimizer.java
* tajo-core/src/test/resources/queries/TestInSubquery/testInSubQuery.sql
* tajo-algebra/src/main/java/org/apache/tajo/algebra/Relation.java
* tajo-core/src/test/resources/queries/TestInSubquery/testInSubQuery2.sql
*
tajo-core/src/test/resources/results/TestInSubquery/testNestedNotInSubQuery.result
* tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java
*
tajo-core/src/test/resources/results/TestInSubquery/testMultipleNotInSubQuery.result
* tajo-plan/src/main/java/org/apache/tajo/plan/serder/EvalNodeDeserializer.java
* tajo-core/src/test/resources/queries/TestInSubquery/testInSubQueryWithJoin.sql
* tajo-core/src/test/resources/results/TestInSubquery/testNotInSubQuery.result
*
tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/rules/InSubqueryRewriteRule.java
* tajo-plan/src/main/java/org/apache/tajo/plan/nameresolver/NameResolver.java
* tajo-core/src/test/resources/queries/TestInSubquery/testNestedInSubQuery.sql
* tajo-plan/src/main/java/org/apache/tajo/plan/algebra/BaseAlgebraVisitor.java
* tajo-core/src/main/java/org/apache/tajo/master/GlobalEngine.java
* tajo-core/src/test/java/org/apache/tajo/engine/planner/TestLogicalPlan.java
* tajo-core/src/main/java/org/apache/tajo/engine/parser/SQLAnalyzer.java
*
tajo-core/src/test/resources/results/TestInSubquery/testInSubQueryWithOtherConditions.result
* tajo-core/src/test/java/org/apache/tajo/engine/eval/ExprTestBase.java
*
tajo-core/src/test/resources/queries/TestInSubquery/testNestedNotInSubQuery.sql
*
tajo-core/src/test/resources/results/TestInSubquery/testMultipleInSubQuery.result
* tajo-plan/src/main/java/org/apache/tajo/plan/joinorder/JoinGraph.java
*
tajo-core/src/test/resources/results/TestInSubquery/testInSubQueryWithTableSubQuery.result
*
tajo-core/src/test/resources/results/TestInSubquery/testNestedInAndNotInSubQuery.result
* tajo-core/src/test/resources/queries/TestInSubquery/testNotInSubQuery.sql
* tajo-core/src/test/resources/queries/TestInSubquery/testMultipleInSubQuery.sql
*
tajo-core/src/test/resources/queries/TestInSubquery/testWithAsteriskAndJoin.sql
*
tajo-core/src/test/resources/results/TestInSubquery/testNestedInSubQuery.result
* tajo-algebra/src/main/java/org/apache/tajo/algebra/TablePrimarySubQuery.java
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalType.java
* tajo-plan/src/main/java/org/apache/tajo/plan/joinorder/JoinOrderingUtil.java
* tajo-plan/src/main/java/org/apache/tajo/plan/util/ExprFinder.java
*
tajo-core/src/test/resources/queries/TestInSubquery/testMultipleNotInSubQuery.sql
*
tajo-core/src/test/resources/results/TestInSubquery/testWithAsteriskAndJoin.result
* tajo-plan/src/main/java/org/apache/tajo/plan/expr/InEval.java
* tajo-core/src/test/resources/queries/TestInSubquery/testNestedInSubQuery2.sql
> Improve the IN operator to support sub queries
> ----------------------------------------------
>
> Key: TAJO-680
> URL: https://issues.apache.org/jira/browse/TAJO-680
> Project: Tajo
> Issue Type: Improvement
> Components: distributed query plan, SQL Parser
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Fix For: 0.11.0
>
> Attachments: Distributed plan.png, Logical plan.png
>
>
> Currently, the IN operator can be used with only sets of values.
> We need to improve it to support sub queries as the following example query.
> {noformat}
> tajo> select * from nation where n_regionkey in (select r_regionkey from
> region);
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
