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/23 17:45:08 UTC
[GitHub] [shardingsphere] linghengqian opened a new issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
linghengqian opened a new issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240
## 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**.
After the project was upgraded to 5.0.0-alpha, I thought, INTERVAL, if datetime-interval-unit chooses DAYS and datetime-interval-amount chooses 1, in this case, how should actual-data-nodes be written?
Is it difficult to avoid the issue of different days in February in leap years and peace years?
By analogy, if INTERVAL chooses DAYS for datetime-interval-unit and 7 for datetime-interval-amount, in this case, actual-data-nodes is also difficult to write in line expressions? Can someone provide an idea?
The best way to deal with dates I have seen is to map dates to natural numbers of 1, 2,...N as shown by AUTO_INTERVAL. There is no such problem in actual-data-nodes. But this and INTERVAL are completely two ideas.
After all, AUTO_INTERVAL does not have the attribute configuration of a logical table. When I want to extend AUTO_INTERVAL, I can only use CLASS_BASED.
--
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] linghengqian edited a comment on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian edited a comment on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950436008
> @tuichenchuxin Can you help check this issue? I remember that we have fixed this problem in the master branch.
Sorry, I want to ask what fix is? Now doesn't `INTERVAL` need to define `actual-data-nodes`?
--
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] linghengqian edited a comment on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian edited a comment on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950519334
> @linghengqian I have to say that actual-data-nodes still needs to be configured, and currently supports writing groovy expressions. You can refer to https://shardingsphere.apache.org/document/5.0.0-alpha/cn/features/sharding/concept/inline-expression/
Thank you for your answer.
--
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] linghengqian commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-953811902
@tuichenchuxin My question is whether the `JAVA API` can be configured for `actual-data-nodes` separately, like `CLASS_BASE` custom sharding algorithm specifying a JAVA entity class. Because using the `Java API` entirely to configure the data source was not intuitive to me. `Shardingsphere-proxy` can only use YAML configuration. It is not possible to use `spring-boot-configuration-processor` in `Shardingsphere-proxy`?
--
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] linghengqian commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950436008
> @tuichenchuxin Can you help check this issue? I remember that we have fixed this problem in the master branch.
Sorry, I want to ask what fix is? Now doesn't INTERVAL need to define actual-data-Nodes?
--
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] tuichenchuxin commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950477917
@linghengqian I have to say that actual-data-nodes still needs to be configured, and currently supports writing groovy expressions. You can refer to https://shardingsphere.apache.org/document/5.0.0-alpha/cn/features/sharding/concept/inline-expression/
--
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] linghengqian edited a comment on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian edited a comment on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950519334
> @linghengqian I have to say that actual-data-nodes still needs to be configured, and currently supports writing groovy expressions. You can refer to https://shardingsphere.apache.org/document/5.0.0-alpha/cn/features/sharding/concept/inline-expression/
@tuichenchuxin Thank you for your answer.
Update 2021.10.26:
My question is whether the `JAVA API` can be configured for `actual-data-nodes` separately, like `CLASS_BASE` custom sharding algorithm specifying a JAVA entity class. Because using the `Java API` entirely to configure the data source was not intuitive to me. `Shardingsphere-proxy` can only use YAML configuration. It is not possible to use `spring-boot-configuration-processor` in `Shardingsphere-proxy`?
--
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] strongduanmu commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950427381
@tuichenchuxin Can you help check this issue? I remember that we have fixed this problem in the master branch.
--
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] linghengqian closed issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian closed issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240
--
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] linghengqian commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-994447214
I feel that it is better for me to put the unresolved issues in the newly opened `Open SphereEx Community`. I will close this 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] linghengqian commented on issue #13240: In terms of date ranges, there are some problems with actual-data-nodes
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #13240:
URL: https://github.com/apache/shardingsphere/issues/13240#issuecomment-950519334
> @linghengqian I have to say that actual-data-nodes still needs to be configured, and currently supports writing groovy expressions. You can refer to https://shardingsphere.apache.org/document/5.0.0-alpha/cn/features/sharding/concept/inline-expression/
Thank you for your answer.
--
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