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 2020/07/27 08:36:34 UTC
[GitHub] [shardingsphere] johnny2002 opened a new issue #6463: to support arbitrary SQL with HintShardingAlgorithm
johnny2002 opened a new issue #6463:
URL: https://github.com/apache/shardingsphere/issues/6463
## Feature Request
Since we have an ETL Job need to use very complex SQL, we suggest sharding-jdbc can skip SQL parsing to support arbitrary SQL.
As I understand, with HintShardingAlgorithm, sharding-jdbc still need to parse SQL to get logicTableName so that it can get sharding configuration.
So, I suggest sharding-jdbc provide some method to let developer to set the logicTableName, so that it can skip SQL parsing. In this way, sharding-jdbc can support any complex SQL.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #6463: to support arbitrary SQL with HintShardingAlgorithm
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6463:
URL: https://github.com/apache/shardingsphere/issues/6463
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] johnny2002 commented on issue #6463: to support arbitrary SQL with HintShardingAlgorithm
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #6463:
URL: https://github.com/apache/shardingsphere/issues/6463#issuecomment-664205121
For an example:
HintManager hintManager = HintManager.getInstance();
hintManager.setDatabaseShardingValue("0");
**hintManager.setLogicTableName("tab_user");** //add this method to set logic table name, so that parsing sql is not neccesary
boolean rst = statement.execute("insert into ... select ... from .... group by ... having...");
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #6463: to support arbitrary SQL with HintShardingAlgorithm
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6463:
URL: https://github.com/apache/shardingsphere/issues/6463#issuecomment-664212165
duplicated with #6458
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org