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/31 05:37:19 UTC
[GitHub] [shardingsphere] peng-ran opened a new issue #6548: The timing of Hint's use
peng-ran opened a new issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548
Do you have any good Suggestions on the timing of setting Hint and releasing Hint?I don't want to do AOP interception with annotations because it would be too intrusive for your code.
----------------------------------------------------------------
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] peng-ran commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667791475
Following the Sharding-JDBC approach, I now have to define all tables (because normal tables may be sharding-dababase) and have to intercept all persistent methods for set hint
----------------------------------------------------------------
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] tristaZero commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-668355772
If users do not set sharding key to `hint manager`, how do users tell the specific values of sharding key to sharding JDBC.
Do you have any other better ideas?
BTW, I guess you wrote comments with the help of Google or Baidu translation tools, didn't you? I suggest you review these translation scripts firstly since this translation confused me a lot. If I could not catch what you said, I would not give you any answers, right?
@peng-ran
----------------------------------------------------------------
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] peng-ran edited a comment on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran edited a comment on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667791475
Following the Sharding-JDBC approach, I now have to define all tables (because normal tables may be sharding-dababase) and have to intercept all persistent methods for set hint，So I put forward this question, I want to ask for the opinions of all the experts。
----------------------------------------------------------------
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] peng-ran commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667886192
@tristaZero
Yes, sharding doesn't need to be calculated, I have a mapping, I just want to be able to fire the algorithm class when Sharding-JDBC parses the logical table in 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] peng-ran edited a comment on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran edited a comment on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667065332
How to make Sharding-JDBC parse to the table to trigger the callback algorithm, skipping the hint, the sharding value will be managed in my program, no need to provide sharding-JDBC, if I use the hint, I have to set it every time I execute SQL, because no setting will not trigger the algorithm back
----------------------------------------------------------------
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] peng-ran commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667790417
@kimmking
I'm on the outside of the program, maintained the shard of tenants and database, table routing relationship, when sharding - JDBC in analytic to SQL table callback fired when algorithm, I, a logical table based on routing table and fact table match, so I don't need to give sharding - JDBC defines all of the tables, and there is no scene every time executing SQL sets the hint, I understand that I only need a SQL parsing table after the callback.
----------------------------------------------------------------
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] tristaZero commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-668944429
Hi @peng-ran Sorry, we have to talk in English since this is an international Apache community.
1. You can configure non-sharding-table with `NoneShardingStrategy and actual dataNode`.
2. As I said before, If users do not set sharding key to hint manager, how do users tell the specific values of sharding key to sharding JDBC. Do you have any other better ideas?
----------------------------------------------------------------
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] peng-ran commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667065332
How to parse the sub-table on the callback algorithm, skipping the hint, sharding value will be managed in my program, no need to provide sharding-JDBC, if I use hint, I have to set it every time I execute SQL, because no setting will not trigger the algorithm callback
----------------------------------------------------------------
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] tristaZero commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667834964
@peng-ran Sorry I did not catch you.
You do not want to set `hint manager` every time you execute 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 commented on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667496031
Can you show a concrete scenario？
----------------------------------------------------------------
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] peng-ran closed issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran closed issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548
----------------------------------------------------------------
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] peng-ran edited a comment on issue #6548: The timing of Hint's use
Posted by GitBox <gi...@apache.org>.
peng-ran edited a comment on issue #6548:
URL: https://github.com/apache/shardingsphere/issues/6548#issuecomment-667790417
@kimmking
I'm on the outside of the program, maintained the shard of tenants and database, table routing relationship, when sharding - JDBC in analytic to SQL table callback fired when algorithm, I, a logical table based on routing table and fact table match, so I don't need to give sharding - JDBC defines all of the tables, and there is no scene every time executing SQL sets the hint, I understand that I only need a SQL parsing trigger callback mechanism.
----------------------------------------------------------------
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