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/07/20 00:34:06 UTC

[GitHub] [shardingsphere] phdbutbachelor commented on issue #18207: does version 5.1.1 support "count" and "group by"?

phdbutbachelor commented on issue #18207:
URL: https://github.com/apache/shardingsphere/issues/18207#issuecomment-1189677766

   @strongduanmu the configuration is: 
   
   schemaName: eeb
   
   dataSources:
     main:
       dataSourceClassName: com.zaxxer.hikari.HikariDataSource
       driverClassName: com.mysql.cj.jdbc.Driver
       jdbcUrl: jdbc:mysql://x.x.x.x/eeb?useUnicode=TRUE&characterEncoding=UTF-8&nullCatalogMeansCurrent=true&serverTimezone=PRC
       username: x
       password: x
   
   rules:
   - !SHARDING
     tables:
       set_info_logs:
         actualDataNodes: main.set_info_logs
         tableStrategy:
           standard:
             shardingColumn: startTime
             shardingAlgorithmName: shardingLogsByMonths
       set_error_logs:
         actualDataNodes: main.set_error_logs
         tableStrategy:
           standard:
             shardingColumn: startTime
             shardingAlgorithmName: shardingLogsByMonths
     shardingAlgorithms:
       shardingLogsByMonths:
         type: SHARDING_LOGS_BY_MONTHS
   
   props:
     sql-show: true
     check-table-metadata-enabled: true


-- 
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