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