KiranVelumuri commented on code in PR #5641: URL: https://github.com/apache/hive/pull/5641#discussion_r2007409857
########## standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.1.0.derby.sql: ########## @@ -704,7 +713,8 @@ CREATE TABLE MIN_HISTORY_WRITE_ID ( MH_TXNID bigint NOT NULL REFERENCES TXNS (TXN_ID), MH_DATABASE varchar(128) NOT NULL, MH_TABLE varchar(256) NOT NULL, - MH_WRITEID bigint NOT NULL + MH_WRITEID bigint NOT NULL, + CONSTRAINT MIN_HISTORY_WRITE_ID_PK PRIMARY KEY (MH_TXNID, MH_DATABASE, MH_TABLE, MH_WRITEID) Review Comment: For the same transaction ID, list of write IDs are inserted into this table. So, write ID also has to be included in the primary key. -- 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
