You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "PeiMouRen (via GitHub)" <gi...@apache.org> on 2023/05/12 01:26:09 UTC
[GitHub] [shardingsphere] PeiMouRen opened a new issue, #25596: Proxy：How to handle views that use sub database tables
PeiMouRen opened a new issue, #25596:
URL: https://github.com/apache/shardingsphere/issues/25596
# How to handle views that use sub database tables
for example, now there is a `t_order` table requires sharding(like `ds_${0..1}.t_order`), but there is another view that uses the sharding table `t_order`，like
```sql
CREATE
OR REPLACE VIEW v_order_detail ( orderId, orderDate, orderItemId, orderItemName ) AS SELECT
t1.ID,
t1.DATE,
t2.ID,
t2.NAME
FROM
t_order t1
JOIN t_order_item t2 ON t1.ID = t2.orderId
```
what should I do with this view in this scenario? create this view in all dbs, or only create in one of the dbs? Is there has other way to handle it?
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] PeiMouRen commented on issue #25596: Proxy：How to handle views that use sharding tables
Posted by "PeiMouRen (via GitHub)" <gi...@apache.org>.
PeiMouRen commented on issue #25596:
URL: https://github.com/apache/shardingsphere/issues/25596#issuecomment-1545313950
@FlyingZC
Thank you for your answer, May I ask where there are explaination and examples about the `sql-federation-type`attriubte.
--
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] PeiMouRen closed issue #25596: Proxy：How to handle views that use sharding tables
Posted by "PeiMouRen (via GitHub)" <gi...@apache.org>.
PeiMouRen closed issue #25596: Proxy：How to handle views that use sharding tables
URL: https://github.com/apache/shardingsphere/issues/25596
--
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] FlyingZC commented on issue #25596: Proxy：How to handle views that use sharding tables
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #25596:
URL: https://github.com/apache/shardingsphere/issues/25596#issuecomment-1545115482
You can enalbe `sql-federation-type: ADVANCED` to support cross-shard view, sql-federation is currently an experimental function.
--
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] FlyingZC commented on issue #25596: Proxy：How to handle views that use sharding tables
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #25596:
URL: https://github.com/apache/shardingsphere/issues/25596#issuecomment-1547072970
Since it is an experimental function, there is no corresponding document, you can configure `sql-federation-type: ADVANCED` to try. https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/yaml-config/props/
--
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