Github user marmbrus commented on the pull request:
https://github.com/apache/spark/pull/9588#issuecomment-156264329
> 1) A command such as SHOW TABLES would now have to go to two different
catalogs to get a full listing of temporary and non temporary tables ?
This is already the case. We have to go to Hive, and the second catalog is
just an in-memory hashtable.
> 2) Do we allow a permanent and temporary table with the same name ?
We do.
> 3) If we do, then we need to decide on the scoping rules , right ? If
some one does a drop/query table then we need to find out which one to
drop/query , right ?
Temporary tables will shadow permanent tables. If you want to access the
permanent table you can use `dbName.tableName`.
> Also michael, did you want me to close this PR ? In this PR, i was simply
addressing the defect with missing is_temporary attribute..
I'd like to avoid complicating the hive interface unless we are actually
going to use this feature. Given it seems better to just properly support SQL
DDL for creating temporary tables I'm not sure it make sense to add it.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
