This is an automated email from the ASF dual-hosted git repository.
dockerzhang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/inlong.git
The following commit(s) were added to refs/heads/master by this push:
new 20d455081 [INLONG-7332][Manager] Change the field length in SQL files
(#7333)
20d455081 is described below
commit 20d455081ce27e7e03399eb93bcf41588620e0fd
Author: Xin Gong <[email protected]>
AuthorDate: Sun Feb 12 21:19:37 2023 +0800
[INLONG-7332][Manager] Change the field length in SQL files (#7333)
Co-authored-by: healchow <[email protected]>
---
.../main/resources/h2/apache_inlong_manager.sql | 16 +++----
.../manager-web/sql/apache_inlong_manager.sql | 18 ++++----
inlong-manager/manager-web/sql/changes-1.6.0.sql | 53 ++++++++++++++++++++++
3 files changed, 70 insertions(+), 17 deletions(-)
diff --git
a/inlong-manager/manager-test/src/main/resources/h2/apache_inlong_manager.sql
b/inlong-manager/manager-test/src/main/resources/h2/apache_inlong_manager.sql
index 230dde03b..da43a8dd7 100644
---
a/inlong-manager/manager-test/src/main/resources/h2/apache_inlong_manager.sql
+++
b/inlong-manager/manager-test/src/main/resources/h2/apache_inlong_manager.sql
@@ -283,8 +283,8 @@ CREATE TABLE IF NOT EXISTS `inlong_stream_field`
`field_type` varchar(20) NOT NULL COMMENT 'field type',
`field_comment` varchar(50) DEFAULT NULL COMMENT 'Field
description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete,
0: not deleted, > 0: deleted',
PRIMARY KEY (`id`),
@@ -418,8 +418,8 @@ CREATE TABLE IF NOT EXISTS `stream_source_field`
`field_type` varchar(20) NOT NULL COMMENT 'field type',
`field_comment` varchar(50) DEFAULT NULL COMMENT 'Field description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a meta
field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete, 0:
not deleted, > 0: deleted',
PRIMARY KEY (`id`),
@@ -443,8 +443,8 @@ CREATE TABLE IF NOT EXISTS `stream_transform_field`
`field_type` varchar(50) NOT NULL COMMENT 'Field type',
`field_comment` varchar(2000) DEFAULT NULL COMMENT 'Field description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete,
0: not deleted, > 0: deleted',
`origin_node_name` varchar(256) DEFAULT '' COMMENT 'Origin node name
which stream field belongs',
@@ -472,8 +472,8 @@ CREATE TABLE IF NOT EXISTS `stream_sink_field`
`field_comment` varchar(2000) DEFAULT NULL COMMENT 'Field description',
`ext_params` text COMMENT 'Field ext params',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`origin_node_name` varchar(256) DEFAULT '' COMMENT 'Origin node name
which stream field belongs',
`origin_field_name` varchar(50) DEFAULT '' COMMENT 'Origin field name
before transform operation',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
diff --git a/inlong-manager/manager-web/sql/apache_inlong_manager.sql
b/inlong-manager/manager-web/sql/apache_inlong_manager.sql
index 1c482a886..c0c94dad3 100644
--- a/inlong-manager/manager-web/sql/apache_inlong_manager.sql
+++ b/inlong-manager/manager-web/sql/apache_inlong_manager.sql
@@ -298,8 +298,8 @@ CREATE TABLE IF NOT EXISTS `inlong_stream_field`
`field_type` varchar(20) NOT NULL COMMENT 'field type',
`field_comment` varchar(50) DEFAULT NULL COMMENT 'Field
description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete,
0: not deleted, > 0: deleted',
PRIMARY KEY (`id`),
@@ -438,8 +438,8 @@ CREATE TABLE IF NOT EXISTS `stream_source_field`
`field_type` varchar(20) NOT NULL COMMENT 'field type',
`field_comment` varchar(50) DEFAULT NULL COMMENT 'Field description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a meta
field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete, 0:
not deleted, > 0: deleted',
PRIMARY KEY (`id`),
@@ -464,8 +464,8 @@ CREATE TABLE IF NOT EXISTS `stream_transform_field`
`field_type` varchar(50) NOT NULL COMMENT 'Field type',
`field_comment` varchar(2000) DEFAULT NULL COMMENT 'Field description',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete,
0: not deleted, > 0: deleted',
`origin_node_name` varchar(256) DEFAULT '' COMMENT 'Origin node name
which stream field belongs',
@@ -487,15 +487,15 @@ CREATE TABLE IF NOT EXISTS `stream_sink_field`
`inlong_stream_id` varchar(256) NOT NULL COMMENT 'Inlong stream id',
`sink_id` int(11) NOT NULL COMMENT 'Sink id',
`sink_type` varchar(15) NOT NULL COMMENT 'Sink type',
- `source_field_name` varchar(50) DEFAULT NULL COMMENT 'Source field name',
+ `source_field_name` varchar(120) DEFAULT NULL COMMENT 'Source field name',
`source_field_type` varchar(50) DEFAULT NULL COMMENT 'Source field type',
`field_name` varchar(120) NOT NULL COMMENT 'Field name',
`field_type` varchar(50) NOT NULL COMMENT 'Field type',
`field_comment` varchar(2000) DEFAULT NULL COMMENT 'Field description',
`ext_params` text COMMENT 'Field ext params',
`is_meta_field` smallint(3) DEFAULT '0' COMMENT 'Is this field a
meta field? 0: no, 1: yes',
- `meta_field_name` varchar(20) DEFAULT NULL COMMENT 'Meta field name',
- `field_format` varchar(50) DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, SQL, ISO_8601 and custom such
as yyyy-MM-dd HH:mm:ss',
+ `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta field name',
+ `field_format` text DEFAULT NULL COMMENT 'Field format,
including MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.',
`origin_node_name` varchar(256) DEFAULT '' COMMENT 'Origin node name
which stream field belongs',
`origin_field_name` varchar(50) DEFAULT '' COMMENT 'Origin field name
before transform operation',
`rank_num` smallint(6) DEFAULT '0' COMMENT 'Field order
(front-end display field order)',
diff --git a/inlong-manager/manager-web/sql/changes-1.6.0.sql
b/inlong-manager/manager-web/sql/changes-1.6.0.sql
new file mode 100644
index 000000000..e81074eba
--- /dev/null
+++ b/inlong-manager/manager-web/sql/changes-1.6.0.sql
@@ -0,0 +1,53 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+-- This is the SQL change file from version 1.4.0 to the current version 1.5.0.
+-- When upgrading to version 1.5.0, please execute those SQLs in the DB (such
as MySQL) used by the Manager module.
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+USE `apache_inlong_manager`;
+
+
+ALTER TABLE `inlong_stream_field`
+ MODIFY COLUMN `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta
field name';
+
+ALTER TABLE `inlong_stream_field`
+ MODIFY COLUMN `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.';
+
+ALTER TABLE `stream_source_field`
+ MODIFY COLUMN `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta
field name';
+
+ALTER TABLE `stream_source_field`
+ MODIFY COLUMN `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.';
+
+ALTER TABLE `stream_transform_field`
+ MODIFY COLUMN `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta
field name';
+
+ALTER TABLE `stream_transform_field`
+ MODIFY COLUMN `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.';
+
+ALTER TABLE `stream_sink_field`
+ MODIFY COLUMN `meta_field_name` varchar(120) DEFAULT NULL COMMENT 'Meta
field name';
+
+ALTER TABLE `stream_sink_field`
+ MODIFY COLUMN `field_format` text DEFAULT NULL COMMENT 'Field format,
including: MICROSECONDS, MILLISECONDS, SECONDS, custom such as yyyy-MM-dd
HH:mm:ss, and serialize format of complex type or decimal precision, etc.';
+
+ALTER TABLE `stream_sink_field`
+ MODIFY COLUMN `source_field_name` varchar(120) DEFAULT NULL COMMENT
'Source field name';
+
