[
https://issues.apache.org/jira/browse/TAJO-747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jaehwa Jung updated TAJO-747:
-----------------------------
Issue Type: Bug (was: Sub-task)
Parent: (was: TAJO-727)
> BroadCastJoin omits some data.
> ------------------------------
>
> Key: TAJO-747
> URL: https://issues.apache.org/jira/browse/TAJO-747
> Project: Tajo
> Issue Type: Bug
> Reporter: Jaehwa Jung
>
> When I tested sub-queries for TPC-DS Q32, I found a bug about BroadCastJoin
> as follows:
> *SQL*
> {code:xml}
> SELECT COUNT(*)
> FROM (
> SELECT cs.cs_item_sk as cs_item_sk,
> cs.cs_ext_discount_amt as cs_ext_discount_amt
> FROM catalog_sales cs
> JOIN date_dim d ON (d.d_date_sk = cs.cs_sold_date_sk)
> WHERE d.d_date between '2000-01-27' and '2000-04-27'
> ) cs1
> JOIN item i ON (i.i_item_sk = cs1.cs_item_sk);
> {code}
> *tajo.dist-query.join.broadcast.auto = false*
> {code:xml}
> result: 1 rows (8 B)
> ?count
> -------------------------------
> 4163848
> {code}
> *tajo.dist-query.join.broadcast.auto = true*
> {code:xml}
> result: 1 rows (8 B)
> ?count
> -------------------------------
> 4139958
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
