scarlin-cloudera commented on code in PR #4190: URL: https://github.com/apache/hive/pull/4190#discussion_r1179548225
########## 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); + +-- The result should be the same regardless of vectorization. + +explain Review Comment: We tested locally with the tpcds queries and your patch seems to have fixed the problem. Thanks! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
