apucher commented on PR #8713: URL: https://github.com/apache/pinot/pull/8713#issuecomment-1129364660
There's precedence for using dots as separators across databases/schemas in MySQL, MSSQL, and others. It's tricky in the sense that underscores are much more commonly used in name tables. Both, underscores and dots, could ultimately work. My hunch is that we'll ultimately have to support dots (to some degree) as most cloud analytics systems already do: * mssql: https://stackoverflow.com/questions/11426929/can-we-use-join-for-two-different-database-tables (or the links already shared above) * big query: https://michaelhoweely.com/2020/09/24/how-to-combine-data-from-two-bigquery-public-datasets-using-sql/ * athena: https://stackoverflow.com/questions/58985607/unable-to-join-two-tables-from-two-different-databases-in-athena -- 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
