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/02/06 07:21:54 UTC
[GitHub] [incubator-shardingsphere] succeo opened a new issue #4180: Inline
strategy cannot support range sharding
succeo opened a new issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180
sharding-jdbc version 4.0.0
sql select * from t_account where f_type = 1 and f_id >= 10000 and f_code in ("500","604","685") group by f_code;
An exception occurred during the 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4180:
Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-582877391
No, Inline strategy cannot support range sharding.
More details please reference document and example
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [shardingsphere] lishuo5263 commented on issue #4180: Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
lishuo5263 commented on issue #4180:
URL: https://github.com/apache/shardingsphere/issues/4180#issuecomment-635072242
> @succeo you can use latest version and turn on this feature like this in server.yaml:
>
> ```
> allow.range.query.with.inline.sharding: true
> ```
hi, KimmKing, I got same question, I fllow your way to try execute this sql (SELECT * FROM t_order WHERE order_id BETWEEN ? AND ?)
----------------------------------------------------------------
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] [incubator-shardingsphere] KomachiSion commented on issue #4180:
Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-582777165
What's your sharding configuration?
BTW, Inline strategy only support `=` and in condition for sharding column. If you want to use range sharding, you should use standard strategy.
More detail see documents
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] succeo commented on issue #4180: Inline
strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
succeo commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-582772184
Please help me solve this problem, thank you
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4180:
Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-586397606
@succeo you can use latest version and turn on this feature like this in server.yaml:
```
allow.range.query.with.inline.sharding: true
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4180:
Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-582785368
You should code a `RangeShardingAlgorithm` and configure it as your range algorithm.
example like : https://github.com/apache/incubator-shardingsphere-example/tree/dev/sharding-jdbc-example/sharding-example/sharding-raw-jdbc-example
use `sharding-databases-range.yaml`
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [shardingsphere] lishuo5263 edited a comment on issue #4180: Inline strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
lishuo5263 edited a comment on issue #4180:
URL: https://github.com/apache/shardingsphere/issues/4180#issuecomment-635072242
> @succeo you can use latest version and turn on this feature like this in server.yaml:
>
> ```
> allow.range.query.with.inline.sharding: true
> ```
hi, KimmKing, I got same question, I fllow your way to try execute this sql (SELECT * FROM t_order WHERE order_id BETWEEN ? AND ?)
and result is :
### Cause: java.lang.IllegalStateException: Inline strategy cannot support this type sharding:RangeRouteValue(columnName=order_id, tableName=t_order, valueRange=[472417022777995264‥482417022777995264])] with root cause
java.lang.IllegalStateException: Inline strategy cannot support this type sharding:RangeRouteValue(columnName=order_id, tableName=t_order, valueRange=[472417022777995264‥482417022777995264])
by the way ,my sharding-shpere jar version update to 4.1.0, How can i fix this 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] succeo commented on issue #4180: Inline
strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
succeo commented on issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180#issuecomment-582782882
config:
shardingColumn: f_id
If you have a query for the range of columns in a separate table, how will it be configured, such as f_id>= XXX
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu closed issue #4180: Inline
strategy cannot support range sharding
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4180: Inline strategy cannot support range sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/4180
----------------------------------------------------------------
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
With regards,
Apache Git Services