zuotingbing commented on issue #8979: URL: https://github.com/apache/gravitino/issues/8979#issuecomment-3471500226
please also check upgrade-0.9.0-to-1.0.0-postgresql.sql [https://github.com/apache/gravitino/blob/main/scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql](url) **ERROR1:** gravitino-pg=# CREATE TABLE IF NOT EXISTS statistic_meta ( id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, statistic_id BIGINT NOT NULL, statistic_name VARCHAR(128) NOT NULL, metalake_id BIGINT NOT NULL, statistic_value TEXT NOT NULL, metadata_object_id BIGINT NOT NULL, metadata_object_type VARCHAR(64) NOT NULL, PRIMARY KEY (statistic_id), UNIQUE (statistic_name, metadata_object_id, deleted_at) ); ERROR: column "deleted_at" named in key does not exist LINE 10: UNIQUE (statistic_name, metadata_object_id, deleted_at) ^ **ERROR2:** COMMENT ON COLUMN statistic_meta.audit_info IS 'statistic audit info'; COMMENT ON COLUMN statistic_meta.current_version IS 'statistic current version'; COMMENT ON COLUMN statistic_meta.last_version IS 'statistic last version'; gravitino-pg=# COMMENT ON COLUMN statistic_meta.audit_info IS 'statistic audit info'; ERROR: column "audit_info" of relation "statistic_meta" does not exist gravitino-pg=# COMMENT ON COLUMN statistic_meta.current_version IS 'statistic current version'; ERROR: column "current_version" of relation "statistic_meta" does not exist gravitino-pg=# COMMENT ON COLUMN statistic_meta.last_version IS 'statistic last version'; ERROR: column "last_version" of relation "statistic_meta" does not exist -- 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]
