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 2021/10/20 02:49:40 UTC

[GitHub] [shardingsphere] CrackerSuperior opened a new issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

CrackerSuperior opened a new issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162


   Version : master
   
   Configuration file:
   ``` yaml
   schemaName: sharding_db
   
   dataSources:
     ds_0:
       url: jdbc:mysql://172.18.40.243:3310/db01?serverTimezone=UTC&useSSL=false
       username: hotdb_datasource
       password: hotdb_datasource
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
     ds_1:
       url: jdbc:mysql://172.18.40.243:3311/db01?serverTimezone=UTC&useSSL=false
       username: hotdb_datasource
       password: hotdb_datasource
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
     ds_2:
       url: jdbc:mysql://172.18.40.244:3310/db02?serverTimezone=UTC&useSSL=false
       username: hotdb_datasource
       password: hotdb_datasource
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
     ds_3:
       url: jdbc:mysql://172.18.40.244:3311/db02?serverTimezone=UTC&useSSL=false
       username: hotdb_datasource
       password: hotdb_datasource
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
   
   rules:
   - !SHARDING
     tables:
       acct_retn_evt_c_lxy:
         actualDataNodes: ds_${0..3}.acct_retn_evt_c_lxy
         keyGenerateStrategy:
           column: acct_retn_detl_id
           keyGeneratorName: snowflake
     defaultDatabaseStrategy:
       standard:
         shardingColumn: acct_retn_detl_id
         shardingAlgorithmName: database_inline
     defaultTableStrategy:
       none:
     
     shardingAlgorithms:
       database_inline:
         type: INLINE
         props:
           algorithm-expression: ds_${acct_retn_detl_id % 4}
     
     keyGenerators:
       snowflake:
         type: SNOWFLAKE
         props:
           worker-id: 123
   ```
   
   My intention is to let it only see the "acct_retn_evt_c_lxy" table, but it found many other tables through "show tables"


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



[GitHub] [shardingsphere] CrackerSuperior edited a comment on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
CrackerSuperior edited a comment on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947288133


   > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   
   This is not what I want, what I want is "show tables"; "show sharding table rules" This is for "rules". By the way, you can see the table to which "rules" is allocated.


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



[GitHub] [shardingsphere] CrackerSuperior commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947286113


   > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   
   I want to know if there is any configuration setting the table that users can access; for example, I want the user "sharding" to only access the table "t_test1" in the database


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



[GitHub] [shardingsphere] CrackerSuperior commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947288133


   > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   
   This is not what I want, what I want is "show table"; "show sharding table rules" This is for "rules". By the way, you can see the table to which "rules" is allocated.


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



[GitHub] [shardingsphere] lanchengx commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947290514


   > > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   > 
   > I want to know if there is any configuration setting the table that users can access; for example, I want the user "sharding" to only access the table "t_test1" in the database
   
   Sorry, authority will be improved in the next major version.


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



[GitHub] [shardingsphere] terrymanu closed issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162


   


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



[GitHub] [shardingsphere] lanchengx commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947283717


   Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to  [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?


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



[GitHub] [shardingsphere] lanchengx edited a comment on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
lanchengx edited a comment on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947295709


   > > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   > 
   > This is not what I want, what I want is "show table"; "show sharding table rules" This is a statement to view the sharding rules
   
   If you just want to view the table to which the rules are assigned, there is no support yet, we will consider whether it needs to be enhanced


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



[GitHub] [shardingsphere] terrymanu commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-1046269151


   I just close this issue because no response for long time.


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



[GitHub] [shardingsphere] lanchengx commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947458012


   Hi @CrackerSuperior ,
   we think that the definition of `show tables` is to show that all tables managed by `ShardingSphere` are not just sharding rules.
   If you only want to show tables with sharding rules, you can only pass `show sharding table rules`.


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



[GitHub] [shardingsphere] CrackerSuperior edited a comment on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
CrackerSuperior edited a comment on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947288133


   > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   
   This is not what I want, what I want is "show table"; "show sharding table rules" This is a statement to view the sharding rules


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



[GitHub] [shardingsphere] lanchengx commented on issue #13162: If my data source itself has many tables, but these tables are not configured in the configuration file, but they can be viewed through "show tables"?

Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13162:
URL: https://github.com/apache/shardingsphere/issues/13162#issuecomment-947295709


   > > Hi @CrackerSuperior ,`acct_retn_evt_c_lxy` belongs to the logical table in the sharding rules. You can use `show sharding table rules`. For details, please refer to [RQL](https://shardingsphere.apache.org/document/current/cn/concepts/distsql/syntax/rql/rql-sharding-rule/), I wonder if it can solve your problem?
   > 
   > This is not what I want, what I want is "show table"; "show sharding table rules" This is a statement to view the sharding rules
   
   If you just want to view the table to which the rules are assigned, and there is no support yet, we will consider whether it needs to be enhanced


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