mdayakar commented on code in PR #6055: URL: https://github.com/apache/hive/pull/6055#discussion_r2321281436
########## ql/src/test/queries/clientpositive/antijoin_conversion.q: ########## @@ -20,3 +20,31 @@ select n.* from n left outer join t on (n.a=t.a) where cast(t.a as float) is nul select assert_true(count(1)=4) from n left outer join t on (n.a=t.a) where cast(t.a as float) is null; +create table tab1 (col1 int, col2 int, col3 int, col4 int); +create table tab2 (col1 int, col2 int, col3 int, col4 int); + +insert into tab1 values (123, 1000, 5000, 9), (456, 1000, 7000, 7), (789, 1000, 5000, 8); +insert into tab2 values (123, 1000, 5000, 2), (456, 1000, 7000, 7), (123, 5000, 4000, 2); + +select t1.col1, t1.col2, t1.col3 from tab2 t1 +left join tab1 t2 Review Comment: Modified it. -- 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: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
