Jaehwa Jung created TAJO-747:
--------------------------------
Summary: BroadCastJoin omits some data.
Key: TAJO-747
URL: https://issues.apache.org/jira/browse/TAJO-747
Project: Tajo
Issue Type: Sub-task
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)
