walterddr opened a new issue, #11237:
URL: https://github.com/apache/pinot/issues/11237
#10336 supported tenant-based v2 queries.
however it doesn't handle cross-tenant access when tables are residing in
different tenant but the broker has knowledge over all tables
the following table config will fail in controller query endpoint (but will
success in broker query endpoint) b/c controller cannot find the common broker
with the overlapping tenant configuration.
- table config
```
tableA: ...
"tenants": {
"broker": "TA",
"server": "TA"
},
tableB: ...
"tenants": {
"broker": "TB",
"server": "TB"
},
```
- instance conf
```
BROKER: ...
"TAG_LIST": [
"DefaultTenant_BROKER",
"TA_BROKER",
"TB_BROKER"
]
SERVER0: ...
"TAG_LIST": [
"TA_OFFLINE",
"TA_REALTIME"
]
SERVER1: ...
"TAG_LIST": [
"TB_OFFLINE",
"TB_REALTIME"
]
```
- query:
```
SELECT COUNT(*) FROM tableA JOIN tableB USING (key)
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
