You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "walterddr (via GitHub)" <gi...@apache.org> on 2023/08/01 17:17:02 UTC

[GitHub] [pinot] walterddr opened a new issue, #11237: [multistage] support common broker tenant

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: commits-unsubscribe@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] walterddr closed issue #11237: [multistage] support common broker tenant

Posted by "walterddr (via GitHub)" <gi...@apache.org>.
walterddr closed issue #11237: [multistage] support common broker tenant
URL: https://github.com/apache/pinot/issues/11237


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org