https://pinot.apache.org/ logo
#troubleshooting
Title
# troubleshooting
l

Lakshmanan Velusamy

03/28/2022, 6:45 PM
Hi Community, Can the dimension tables be created across different tenants with the same name ?
cc @User @User
m

Mayank

03/28/2022, 6:46 PM
Table names need to be unique within a Pinot cluster.
m

Mingfeng Tan

03/28/2022, 6:47 PM
To my understanding, a table can only be associated with one tenant. If tenant is not specified, then it goes to DeafultTeant. But since dimension table normally is small, it’s would be fine to duplicate with it in another tenant but with different name.
Correct me if I’m wrong.
m

Mayank

03/28/2022, 6:48 PM
Yes, it can be duplicated (with different name of course). You can still have a single push job that can push data to multiple tables.
l

Lakshmanan Velusamy

03/28/2022, 6:49 PM
With hybrid table, the lookup() query becomes tricky if the realtime and offline tables are in different tenants (as the dimension table names are different).
m

Mayank

03/28/2022, 6:52 PM
But you can have multiple tenants for a server/broker. So you could create a dedicated tenant for dim table and mark the realtime and offline servers with that additional tenant.
l

Lakshmanan Velusamy

03/29/2022, 5:04 PM
Thanks @User. Is there a document on
mark the realtime and offline servers with that additional tenant
?