[GitHub] [iceberg] pvary commented on issue #2833: Unified syntax for system table names

[GitBox <gi...@apache.org>]

pvary commented on issue #2833:
URL: https://github.com/apache/iceberg/issues/2833#issuecomment-881315289


   We had a related discussion with @marton-bod this morning.
   
   The problem we found is that if we have a query `USE default; SELECT * from customers.history;` in Hive it could be either db=`customers` table=`history`, or after introducing metadata tables it could be db=`default` table=`customers` metaType=`history`. We could only come up with the lame solution of "you have to always provide the db if you want to access the metadata tables, like `SELECT * from default.customers.history`"
   
   Choosing another delimiter would fix this issue.
   
   I have also seen `__` as a delimiter in this [PR](https://github.com/apache/iceberg/pull/1103/files#diff-572bca25ff182a00d652047c2a5299f6fd61e3af05f53d32a18188741ca58b60R54-R54) by @cmathiesen
   ```
     public static final String SNAPSHOT_TABLE = "iceberg.snapshots.table";
     public static final String SNAPSHOT_TABLE_SUFFIX = "__snapshots";
   ```
   The other part of the code never made it into upstream so these configs were eventually removed.
   
   It would be really good to be able to access the metadata tables in an unified way.
   
   Maybe @boroknagyz is also interested in this from Impala side.
   
   Thanks,
   Peter


-- 
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: issues-unsubscribe@iceberg.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org