This is an automated email from the ASF dual-hosted git repository.
wanghailin pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/seatunnel.git
The following commit(s) were added to refs/heads/dev by this push:
new 5fd98eab9e [Fix][Doc] Fixed typography error in starrocks sink
document (#6579)
5fd98eab9e is described below
commit 5fd98eab9ec5b11de06ee1381fc6b771929dfb13
Author: Jia Fan <[email protected]>
AuthorDate: Wed Mar 27 10:29:27 2024 +0800
[Fix][Doc] Fixed typography error in starrocks sink document (#6579)
---
docs/en/connector-v2/sink/Doris.md | 22 ++++++----
docs/en/connector-v2/sink/StarRocks.md | 76 +++++++++++++++++-----------------
2 files changed, 52 insertions(+), 46 deletions(-)
diff --git a/docs/en/connector-v2/sink/Doris.md
b/docs/en/connector-v2/sink/Doris.md
index 7e8d9c6341..453a410bbe 100644
--- a/docs/en/connector-v2/sink/Doris.md
+++ b/docs/en/connector-v2/sink/Doris.md
@@ -73,16 +73,20 @@ We use templates to automatically create Doris tables,
which will create corresponding table creation statements based on the type of
upstream data and schema type,
and the default template can be modified according to the situation.
+Default template:
+
```sql
-CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}`
-(
- ${rowtype_fields}
-) ENGINE = OLAP UNIQUE KEY (${rowtype_primary_key})
- DISTRIBUTED BY HASH (${rowtype_primary_key})
- PROPERTIES
-(
- "replication_num" = "1"
-);
+CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}` (
+${rowtype_fields}
+) ENGINE=OLAP
+ UNIQUE KEY (${rowtype_primary_key})
+DISTRIBUTED BY HASH (${rowtype_primary_key})
+ PROPERTIES (
+"replication_allocation" = "tag.location.default: 1",
+"in_memory" = "false",
+"storage_format" = "V2",
+"disable_auto_compaction" = "false"
+)
```
If a custom field is filled in the template, such as adding an `id` field
diff --git a/docs/en/connector-v2/sink/StarRocks.md
b/docs/en/connector-v2/sink/StarRocks.md
index 03afca211b..b6dc18e8ea 100644
--- a/docs/en/connector-v2/sink/StarRocks.md
+++ b/docs/en/connector-v2/sink/StarRocks.md
@@ -48,6 +48,45 @@ We use templates to automatically create starrocks tables,
which will create corresponding table creation statements based on the type of
upstream data and schema type,
and the default template can be modified according to the situation. Only work
on multi-table mode at now.
+Default template:
+
+```sql
+CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}` (
+${rowtype_primary_key},
+${rowtype_fields}
+) ENGINE=OLAP
+PRIMARY KEY (${rowtype_primary_key})
+DISTRIBUTED BY HASH (${rowtype_primary_key})PROPERTIES (
+"replication_num" = "1"
+)
+```
+
+If a custom field is filled in the template, such as adding an `id` field
+
+```sql
+CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}`
+(
+ id,
+ ${rowtype_fields}
+) ENGINE = OLAP DISTRIBUTED BY HASH (${rowtype_primary_key})
+ PROPERTIES
+(
+ "replication_num" = "1"
+);
+```
+
+The connector will automatically obtain the corresponding type from the
upstream to complete the filling,
+and remove the id field from `rowtype_fields`. This method can be used to
customize the modification of field types and attributes.
+
+You can use the following placeholders
+
+- database: Used to get the database in the upstream schema
+- table_name: Used to get the table name in the upstream schema
+- rowtype_fields: Used to get all the fields in the upstream schema, we will
automatically map to the field
+ description of StarRocks
+- rowtype_primary_key: Used to get the primary key in the upstream schema
(maybe a list)
+- rowtype_unique_key: Used to get the unique key in the upstream schema (maybe
a list)
+
### table [string]
Use `database` and this `table-name` auto-generate sql and receive upstream
input datas write to database.
@@ -82,43 +121,6 @@ Option introduction：
When data_save_mode selects CUSTOM_PROCESSING, you should fill in the
CUSTOM_SQL parameter. This parameter usually fills in a SQL that can be
executed. SQL will be executed before synchronization tasks.
-```sql
-CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}`
-(
- ${rowtype_fields}
-) ENGINE = OLAP DISTRIBUTED BY HASH (${rowtype_primary_key})
- PROPERTIES
-(
- "replication_num" = "1"
-);
-```
-
-If a custom field is filled in the template, such as adding an `id` field
-
-```sql
-CREATE TABLE IF NOT EXISTS `${database}`.`${table_name}`
-(
- id,
- ${rowtype_fields}
-) ENGINE = OLAP DISTRIBUTED BY HASH (${rowtype_primary_key})
- PROPERTIES
-(
- "replication_num" = "1"
-);
-```
-
-The connector will automatically obtain the corresponding type from the
upstream to complete the filling,
-and remove the id field from `rowtype_fields`. This method can be used to
customize the modification of field types and attributes.
-
-You can use the following placeholders
-
-- database: Used to get the database in the upstream schema
-- table_name: Used to get the table name in the upstream schema
-- rowtype_fields: Used to get all the fields in the upstream schema, we will
automatically map to the field
- description of StarRocks
-- rowtype_primary_key: Used to get the primary key in the upstream schema
(maybe a list)
-- rowtype_unique_key: Used to get the unique key in the upstream schema (maybe
a list)
-
## Data Type Mapping
| StarRocks Data type | SeaTunnel Data type |
