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/11/22 10:29:27 UTC
[GitHub] [shardingsphere] xfzhaoGit opened a new issue #13739: support query information_schrma？sharding-jdbc5.0.0
xfzhaoGit opened a new issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739
## Question
**For English only**, other languages will not accept.
Before asking a question, make sure you have:
- Googled your question.
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
--
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] RaigorJiang closed issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739
--
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] xfzhaoGit closed issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit closed issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975714375
In my project, I use single database and partial table sharding, and I dont think sharding is used for the query and other operation of non-sharded tables. Is there an example of this?
--
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] RaigorJiang commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-1048641075
> 'show tables like ...' sql still error:
com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
Hi @xsong123
Looks like a parsing problem, you can create a new issue.
--
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] RaigorJiang commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975611294
Because ShardingSphere uses logical schemas and logical tables to handle distributed tasks.
Can `show databases` and `show tables` meet your requirements?
--
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] xfzhaoGit removed a comment on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit removed a comment on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975602762
![Uploading B859C907-C0BD-46D0-A594-17AFEC1303BF.jpeg…]()
--
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] xsong123 commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xsong123 commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-1048634552
'show tables like ...' sql still error:
com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2051)
at com.google.common.cache.LocalCache.get(LocalCache.java:3951)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:71)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:60)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:157)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:128)
at org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:78)
Caused by: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:68)
at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:49)
at org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:51)
at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
at org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:40)
at org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:29)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045)
... 78 more
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975632342
for queries like this I try not to use sharding, is there a similar configuration?
--
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] xfzhaoGit removed a comment on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit removed a comment on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975603949
![Uploading DCB4ACCF-89C7-4BD8-A8D8-751FB4A8B0D6.jpeg…]()
> ``
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975603949
![Uploading DCB4ACCF-89C7-4BD8-A8D8-751FB4A8B0D6.jpeg…]()
> ``
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975602534
There is a scenario in my project to determine whether the database table exists, I need to use the information_schema database, but shardingsphere reports an error message, and the information_schema does not exist。
--
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] RaigorJiang commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975639122
No, because information_schrma is not a logical database, ShardingSphere does not know which actual node the user wants to query.
--
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] RaigorJiang commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-976088801
> In my project, I use single database and partial table sharding, and I dont think sharding is used for the query and other operation of non-sharded tables. Is there an example of this?
The non-sharding tables does not need to be configured, ShardingSphere will recognize them. You can see those 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] RaigorJiang commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975590991
Hi @xfzhaoGit
ShardingSphere-JDBC does not yet support querying information_schrma.
By the way, your picture cannot be displayed, can you describe your scene?
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975602762
![Uploading B859C907-C0BD-46D0-A594-17AFEC1303BF.jpeg…]()
--
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] xfzhaoGit commented on issue #13739: support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-975379931
![Uploading EBEDD196-C04B-4934-B148-34BBAB70BD92.jpeg…]()
--
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] xfzhaoGit commented on issue #13739: whether to support query information_schrma？sharding-jdbc5.0.0
Posted by GitBox <gi...@apache.org>.
xfzhaoGit commented on issue #13739:
URL: https://github.com/apache/shardingsphere/issues/13739#issuecomment-976147999
ok thanks
--
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