governance module together, the configuration of persistence in the configuration center is YAML format. Note: The YAML configuration file supports more than 3MB of configuration content. YAML configuration shardingsphere-jdbc ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of database name, mode configuration, data source map, rule highly readable. The dependencies between sharding rules can be quickly understood through the YAML format. ShardingSphere automatically creates the Sharding‐ SphereDataSource object according to YAML configuration

governance module together, the configuration of persistence in the configuration center is YAML format. Note: The YAML configuration file supports more than 3MB of configuration content. YAML configuration sphere-jdbc-core ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of database name, mode configuration, data source map, rule highly readable. The dependencies between sharding rules can be quickly understood through the YAML format. ShardingSphere automatically creates the Sharding‐ SphereDataSource object according to YAML configuration

governance module together, the configuration of persistence in the configuration center is YAML format. YAML configuration is the most common configuration mode, which can omit the complexity of pro‐ sphere-jdbc-core ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of database name, mode configuration, data source map, rule highly readable. The dependencies between sharding rules can be quickly understood through the YAML format. ShardingSphere automatically creates the Sharding‐ SphereDataSource object according to YAML configuration

governance module together, the configuration of persistence in the configuration center is YAML format. YAML configuration is the most common configuration mode, which can omit the complexity of pro‐ sphere-jdbc-core ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of database name, mode configuration, data source map, rule highly readable. The dependencies between sharding rules can be quickly understood through the YAML format. ShardingSphere automatically creates the Sharding‐ SphereDataSource object according to YAML configuration

they need to configure resources and rules through YAML file (or registry center). However, the format of YAML and habits changed by using registry center are not friendly to DBA. DistSQL enables users governance module together, the configuration of persistence in the configuration center is YAML format. YAML configuration is the most common configuration mode, which can omit the complexity of pro‐ sphere-jdbc-core ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of schema name, mode configuration, data source map, rule

## @param compute.serverConfig.authority.users[0].user Username,authorized host for compute node. Format: @ hostname is % or empty string means do not care about authorized host ## PARSE 相关链接 • 保留字 FORMAT SQL 描述 FORMAT SQL 语法用于解析并输出格式化后的 SQL 语句。 语法 FormatSql ::= 'FORMAT' sqlStatement 返回值说明 列 说明 formatted_result 格式化后的 SQL 语句 示例 • 解析并输出格式化后的 SQL 语句 FORMAT SELECT * FROM t_order; t_order; mysql> FORMAT SELECT * FROM t_order; +-------------------------+ | formatted_result | +-------------------------+ | SELECT * FROM t_order; | +-------------------------+ 1 row in set (0

## @param compute.serverConfig.authority.users[0].user Username,authorized host for compute node. Format: @ hostname is % or empty string means do not care about authorized host ## PARSE 相关链接 • 保留字 FORMAT SQL 描述 FORMAT SQL 语法用于解析并输出格式化后的 SQL 语句。 语法 FormatSql ::= 'FORMAT' sqlStatement 返回值说明 列 说明 formatted_result 格式化后的 SQL 语句 示例 • 解析并输出格式化后的 SQL 语句 FORMAT SELECT * FROM t_order; t_order; mysql> FORMAT SELECT * FROM t_order; +-------------------------+ | formatted_result | +-------------------------+ | SELECT * FROM t_order; | +-------------------------+ 1 row in set (0

## @param compute.serverConfig.authority.users[0].user Username,authorized host for compute node. Format: @ hostname is % or empty string means do not care about authorized host ## PARSE 相关链接 • 保留字 FORMAT SQL 描述 FORMAT SQL 语法用于解析并输出格式化后的 SQL 语句。 语法 FormatSql ::= 'FORMAT' sqlStatement 返回值说明 列 说明 formatted_result 格式化后的 SQL 语句 示例 • 解析并输出格式化后的 SQL 语句 FORMAT SELECT * FROM t_order; t_order; mysql> FORMAT SELECT * FROM t_order; +-------------------------+ | formatted_result | +-------------------------+ | SELECT * FROM t_order; | +-------------------------+ 1 row in set (0

they need to configure resources and rules through YAML file (or registry center). However, the format of YAML and habits changed by using registry center are not friendly to DBA. DistSQL enables users governance module together, the configuration of persistence in the configuration center is YAML format. YAML configuration is the most common configuration mode, which can omit the complexity of pro‐ sphere-jdbc-core ${shardingsphere.version} YAML Format ShardingSphere‐JDBC YAML file consists of schema name, mode configuration, data source map, rule

MySQL supported PostgreSQL supported SQLServer supported Oracle supported SQL92 supported • SQL format (developing) • SQL parameterize (developing) 3.1. Sharding 25 Apache ShardingSphere document, SQLVisitorEngine(databaseType, "STATEMENT "); SQLStatement sqlStatement = sqlVisitorEngine.visit(tree); • SQL Format /** * databaseType type:String values MySQL * useCache type:boolean whether use cache * @return ShardingSphere document, v5.0.0-beta SQLVisitorEngine sqlVisitorEngine = new SQLVisitorEngine(databaseType, "FORMAT"); String formatedSql = sqlVisitorEngine.visit(tree); example： 3.1. Sharding 27 Apache ShardingSphere