gortiz commented on PR #12591: URL: https://github.com/apache/pinot/pull/12591#issuecomment-1992307722
Using the postgres terminology we are not defining databases but schemas. Databases are independent of each other and for example you cannot join tables in two different databases. AFAIK in MySQL _database_ and _schema_ is the same thing. As we can see in `PinotCatalog` (which extends Calcite `Schema`) the term in Calcite is also _schema_. I would strongly recommend to change the nomenclature to do not use _database_ in that case. The correct SQL term would be _schema_ but given we already use that term we may use _namespace_ instead. BTW, in any schema may contain other schemas. I don't know if we plan to support that as well right now, but even if we don't support that in a first implementation, we should let open that possibility for the future. -- 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-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
