You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@amoro.apache.org by ji...@apache.org on 2024/09/24 02:43:48 UTC
(amoro) branch master updated: [hotfix] ams-mysql-init.sql fix error init (#3217)
This is an automated email from the ASF dual-hosted git repository.
jinsongzhou pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/amoro.git
The following commit(s) were added to refs/heads/master by this push:
new efd665051 [hotfix] ams-mysql-init.sql fix error init (#3217)
efd665051 is described below
commit efd665051c8f05cd703d6c9d2f138e71a92baad5
Author: mansonliwh <61...@users.noreply.github.com>
AuthorDate: Tue Sep 24 10:43:44 2024 +0800
[hotfix] ams-mysql-init.sql fix error init (#3217)
[Improvement] ams-mysql-init.sql fix
---
amoro-ams/src/main/resources/mysql/ams-mysql-init.sql | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
diff --git a/amoro-ams/src/main/resources/mysql/ams-mysql-init.sql b/amoro-ams/src/main/resources/mysql/ams-mysql-init.sql
index b2e41cf90..3db61746b 100644
--- a/amoro-ams/src/main/resources/mysql/ams-mysql-init.sql
+++ b/amoro-ams/src/main/resources/mysql/ams-mysql-init.sql
@@ -122,8 +122,7 @@ CREATE TABLE `table_runtime`
`last_major_optimizing_time` timestamp NULL DEFAULT NULL COMMENT 'Latest Major Optimize time for all partitions',
`last_minor_optimizing_time` timestamp NULL DEFAULT NULL COMMENT 'Latest Minor Optimize time for all partitions',
`last_full_optimizing_time` timestamp NULL DEFAULT NULL COMMENT 'Latest Full Optimize time for all partitions',
- `optimizing_status_code` int DEFAULT 700 COMMENT 'Table optimize status code: 100(FULL_OPTIMIZING),' ||
- ' 200(MAJOR_OPTIMIZING), 300(MINOR_OPTIMIZING), 400(COMMITTING), 500(PLANING), 600(PENDING), 700(IDLE)',
+ `optimizing_status_code` int DEFAULT 700 COMMENT 'Table optimize status code: 100(FULL_OPTIMIZING), 200(MAJOR_OPTIMIZING), 300(MINOR_OPTIMIZING), 400(COMMITTING), 500(PLANING), 600(PENDING), 700(IDLE)',
`optimizing_status_start_time` timestamp default CURRENT_TIMESTAMP COMMENT 'Table optimize status start time',
`optimizing_process_id` bigint(20) NOT NULL COMMENT 'optimizing_procedure UUID',
`optimizer_group` varchar(64) NOT NULL,
@@ -132,8 +131,8 @@ CREATE TABLE `table_runtime`
`pending_input` mediumtext,
`table_summary` mediumtext,
PRIMARY KEY (`table_id`),
- UNIQUE KEY `table_index` (`catalog_name`,`db_name`,`table_name`)
- INDEX idx_optimizer_status_and_time (optimizing_status_code, optimizing_status_start_time DESC);
+ UNIQUE KEY `table_index` (`catalog_name`,`db_name`,`table_name`),
+ INDEX idx_optimizer_status_and_time (optimizing_status_code, optimizing_status_start_time DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT 'Optimize running information of each table' ROW_FORMAT=DYNAMIC;
CREATE TABLE `table_optimizing_process`