difin commented on code in PR #6924:
URL: https://github.com/apache/hive/pull/6924#discussion_r4556369036
##########
iceberg/iceberg-handler/src/test/queries/positive/iceberg_v3_dml_distribution.q:
##########
@@ -0,0 +1,37 @@
+-- A V3 table gets one DV per data file: the deleted records are distributed
by FILE__PATH
+set hive.explain.user=false;
+
+create external table ice_v3 (id int, name string) partitioned by spec
(bucket(2, id))
+stored by iceberg tblproperties ('format-version'='3');
+insert into ice_v3 values (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd');
+
+create external table ice_v3_src (id int) stored by iceberg tblproperties
('format-version'='3');
+insert into ice_v3_src values (1), (2), (5);
+
+explain delete from ice_v3 where id = 1;
+delete from ice_v3 where id = 1;
+
+explain update ice_v3 set name = 'x' where id = 2;
+update ice_v3 set name = 'x' where id = 2;
+
+explain merge into ice_v3 t using ice_v3_src s on t.id = s.id
+when matched and t.id = 2 then update set name = 'y'
+when matched then delete
+when not matched then insert values (s.id, 'z');
+merge into ice_v3 t using ice_v3_src s on t.id = s.id
Review Comment:
nit: can you add a new line above this one for readability?
--
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]
