[
https://issues.apache.org/jira/browse/TAJO-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14163347#comment-14163347
]
Hudson commented on TAJO-1102:
------------------------------
SUCCESS: Integrated in Tajo-master-CODEGEN-build #40 (See
[https://builds.apache.org/job/Tajo-master-CODEGEN-build/40/])
TAJO-1102: Self-join with a partitioned table returns wrong result data.
(babokim: rev f42baa005dbf3f4fe64e3f3745616164df9aba65)
* tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/ScanNode.java
* CHANGES
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinBroadcast.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/PartitionedTableScanNode.java
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTableInFilter.result
> Self-join with a partitioned table returns wrong result data.
> -------------------------------------------------------------
>
> Key: TAJO-1102
> URL: https://issues.apache.org/jira/browse/TAJO-1102
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Affects Versions: 0.9.0
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Priority: Minor
> Fix For: 0.9.0
>
>
> See the following case.
> {code:sql}
> CREATE TABLE orders_partition
> (o_orderkey INT8, o_custkey INT8, o_totalprice FLOAT8, o_orderpriority TEXT,
> o_clerk TEXT, o_shippriority INT4, o_comment TEXT) USING CSV WITH
> ('csvfile.delimiter'='|')
> PARTITION BY COLUMN(o_orderdate TEXT, o_orderstatus TEXT);
> {code}
> {code:sql}
> select a.o_orderstatus, count(*) as cnt
> from orders_partition a
> inner join orders_partition b
> on a.o_orderdate = b.o_orderdate
> and a.o_orderstatus = b.o_orderstatus
> and a.o_orderkey = b.o_orderkey
> where a.o_orderdate='1995-02-21'
> and a.o_orderstatus in ('F')
> group by a.o_orderstatus;
> {code}
> Because of the where condition (where a.o_orderdate='1995-02-21 and
> a.o_orderstatus in ('F')), orders_partition table aliased 'a' is small and
> broadcast target table.
> In this case GlobalPlanner can't resolve which table is partitioned table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
