scarlin-cloudera commented on code in PR #4783: URL: https://github.com/apache/hive/pull/4783#discussion_r1355515696
########## ql/src/test/queries/clientpositive/multi_insert_gby5.q: ########## @@ -0,0 +1,16 @@ +set hive.cbo.fallback.strategy=NEVER; + +CREATE TABLE tbl1 (key int, f1 int); +CREATE TABLE tbl2 (f1 int) PARTITIONED BY (key int); + +EXPLAIN FROM (SELECT key, f1 FROM tbl1 WHERE key=5) a Review Comment: Ok, I added some data. The query itself is kinda weird, as you mentioned in the comments. I put one row with "key = 5" which should be selected twice. One row in the new table will contain key=6 because it is explicitly put into the partition. The value is the same on both rows. Definitely a weird query, but I think it shows the right data is being filtered and inserted. -- 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
