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/09 10:25:16 UTC
[GitHub] [shardingsphere] zhangwangren opened a new issue #12967: how can i use normal table(have no use sharding) join broadcast table?
zhangwangren opened a new issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967
## Question
how can i use normal table(have no use sharding) left join broadcast table?
for example:
#broadcast table
spring.shardingsphere.sharding.broadcast-tables=t_config
#normal table
t_order
when i try SELECT * FROM t_order LEFT JOIN t_config ON XXX
it throws Exception : Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Expression 'rwd.TM' is not being grouped
pls help!!!
--
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] zhangwangren closed issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren closed issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967
--
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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939678867
Excuse me，witch version is the master in spring-boot？ i can not find
--
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 #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939445879
@zhangwangren This seems to be a bug in beta version, can you try 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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939679322
Excuse me！witch version is the master in spring-boot? i can not find
--
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] zhangwangren edited a comment on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren edited a comment on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-943112300
im sorry! This seems to bring a new bug, when i use the master code, nomarl table can join broadcast table, but the sharding table doesn't work.
------------------------------------
# this is my config
spring.shardingsphere.sharding.broadcast-tables[0]=dict_station_belong_reservoir
spring.shardingsphere.sharding.tables.dict_station_belong_reservoir.actual-data-nodes=ds$->{0}.dict_station_belong_reservoir
--
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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939384415
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.0.0-beta</version>
</dependency>
--
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] zhangwangren removed a comment on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren removed a comment on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939678867
Excuse me，witch version is the master in spring-boot？ i can not find
--
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 #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939273599
@zhangwangren What version are you using?
--
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] zhangwangren removed a comment on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren removed a comment on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939679011
i can not find
--
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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-943112300
im sorry! This seems to bring a new bug, when i use the master code, nomarl table can join broadcast table, but the sharding table
doesn't work.
------------------------------------
# this is my config
spring.shardingsphere.sharding.broadcast-tables[0]=dict_station_belong_reservoir
spring.shardingsphere.sharding.tables.dict_station_belong_reservoir.actual-data-nodes=ds$->{0}.dict_station_belong_reservoir
--
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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-942078995
it work，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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangwangren closed issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren closed issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967
--
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] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-942078995
it work，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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangwangren commented on issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939679011
i can not find
--
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 #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967#issuecomment-939696611
@zhangwangren You can download the latest code, and building by yourself. You can refer this doc for building——https://github.com/apache/shardingsphere/wiki.
--
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] zhangwangren closed issue #12967: how can i use normal table(have no use sharding) join broadcast table?
Posted by GitBox <gi...@apache.org>.
zhangwangren closed issue #12967:
URL: https://github.com/apache/shardingsphere/issues/12967
--
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