KiranVelumuri commented on code in PR #5641: URL: https://github.com/apache/hive/pull/5641#discussion_r2007412489
########## standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.1.0.oracle.sql: ########## @@ -961,7 +961,8 @@ CREATE TABLE TXN_COMPONENTS ( TC_TABLE VARCHAR2(256), TC_PARTITION VARCHAR2(767) NULL, TC_OPERATION_TYPE char(1) NOT NULL, - TC_WRITEID NUMBER(19) + TC_WRITEID NUMBER(19), + INV_ID NUMBER(19) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY Review Comment: > Oracle Database: Supported in Oracle 12c Release 1 (12.1) and later. We use lightweight "oracle-xe:18.4.0-slim" image with which there is no support for invisible columns. When I added the INVISIBLE keyword, the tests failed with incoorect syntax. Ref: [HIVE-26450: Use a more lightweight Oracle image ](https://issues.apache.org/jira/browse/HIVE-26450) -- 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