DataWorks如何通过阿里云实例配置的：数据库名：库名?-[阿里云_云淘科技]

匿名 • 2023年12月31日上午8:00 • 阿里云

DataWorks如何通过阿里云实例配置的：数据库名：库名?com.mysql.jdbc.faultInjection.serverCharsetIndex=45
脏数据中包含emoji、也包含一些不常见的字

以下为热心网友提供的参考意见

参考官方文档：https://help.aliyun.com/zh/analyticdb-for-mysql/overview-3

云原生数据仓库AnalyticDB MySQL版支持通过CREATE TABLE创建表，也支持通过CTAS将查询到的数据写入新表中
示例：
CREATE TABLE [IF NOT EXISTS] table_name
({column_name column_type [column_attributes] [ column_constraints ] [COMMENT ‘string’]
| table_constraints}
[, … ] )
table_attribute
[partition_options]
[storage_policy]
[block_size]
[engine]
[rt_engine]
[table_properties]
[AS] query_expression
COMMENT ‘string’

column_attributes:
[DEFAULT default_expr]
[AUTO_INCREMENT]

column_constraints:
[{NOT NULL|NULL} ]
[PRIMARY KEY]

table_constraints:
[{INDEX|KEY} [index_name] (column_name,…)]
[PRIMARY KEY [index_name] (column_name,…)]
[CLUSTERED KEY [index_name] (column_name,…)]

table_attribute:
DISTRIBUTED BY HASH(column_name,…) | DISTRIBUTED BY BROADCAST

partition_options:
PARTITION BY
{VALUE(column_name) | VALUE(date_format(column_name, ?))}
LIFECYCLE N

storage_policy:
STORAGE_POLICY= ‘HOT’|’COLD’|’MIXED’ [hot_partition_count=N]

block_size:
BLOCK_SIZE= VALUE

engine:
ENGINE= ‘XUANWU’

rt_engine：
RT_ENGINE= ‘COLUMNSTORE’

table_properties:
TABLE_PROPERTIES = ‘{“format”:”columnstore”}’

参数说明：