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”}’
参数说明：
转转请注明出处：https://www.yunxiaoer.com/181432.html