[
https://issues.apache.org/jira/browse/HIVE-26659?focusedWorklogId=857845&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-857845
]
ASF GitHub Bot logged work on HIVE-26659:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 19/Apr/23 08:22
Start Date: 19/Apr/23 08:22
Worklog Time Spent: 10m
Work Description: ngsg commented on code in PR #4190:
URL: https://github.com/apache/hive/pull/4190#discussion_r1170991803
##########
ql/src/test/queries/clientpositive/antijoin2.q:
##########
@@ -0,0 +1,75 @@
+set hive.merge.nway.joins=false;
+set hive.vectorized.execution.enabled=false;
+set hive.auto.convert.join=true;
+set hive.auto.convert.anti.join=true;
+
+drop table if exists tt1;
+drop table if exists tt2;
+drop table if exists tt3;
+
+create table tt1 (ws_order_number bigint, ws_ext_ship_cost decimal(7, 2));
+create table tt2 (ws_order_number bigint);
+create table tt3 (wr_order_number bigint);
+
+insert into tt1 values (42, 3093.96), (1041, 299.28), (1378, 85.56), (1378,
719.44), (1395, 145.68);
+insert into tt2 values (1378), (1395);
+insert into tt3 values (42), (1041);
+
+
Issue Time Tracking
-------------------
Worklog Id: (was: 857845)
Time Spent: 1.5h (was: 1h 20m)
> TPC-DS query 16, 69, 94 return wrong results.
> ---------------------------------------------
>
> Key: HIVE-26659
> URL: https://issues.apache.org/jira/browse/HIVE-26659
> Project: Hive
> Issue Type: Sub-task
> Affects Versions: 4.0.0-alpha-2
> Reporter: Sungwoo Park
> Assignee: Seonggon Namgung
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> TPC-DS query 16, 69, 94 return wrong results when hive.auto.convert.anti.join
> is set to true.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
