You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/28 06:22:16 UTC
[GitHub] [shardingsphere] Huletian commented on issue #17166: kettle to import data into shardingsphere-proxy:Parameter index out of bounds
Huletian commented on issue #17166:
URL: https://github.com/apache/shardingsphere/issues/17166#issuecomment-1111793194
> @Huletian Can you provide more information——ShardingSphere version and your sharding configuration?
ShardingSphere version:5.0.0(Updated on 2022.03.11)
# configuration:
## server.yaml:
```
mode:
type: Standalone
repository:
type: File
overwrite: false
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
- !TRANSACTION
defaultType: XA
providerType: Atomikos
- !SQL_PARSER
sqlCommentParseEnabled: true
props:
sql-comment-parse-enabled: true
check-table-metadata-enabled: false
proxy-backend-query-fetch-size: 10000
proxy-backend-executor-suitable: OLTP
proxy-frontend-max-connections: 0
```
# DistSQL
```
CREATE sharding TABLE rule dw_student (
datanodes ( "ds_${['ceshi1','ceshi2']}.dw_student" ),
database_strategy (
type = standard,
sharding_column = school_code,
sharding_algorithm (
TYPE (
NAME = inline,
PROPERTIES ( "algorithm-expression" = "ds_${school_code}" ))))
);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org