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