Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Review Request 22996: HIVE-7090 Support session-level temporary tables in Hive


Copy link to this message
-
Re: Review Request 22996: HIVE-7090 Support session-level temporary tables in Hive

This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/22996/#review47005
What will happen if a user tries to create a view over a temp table?  I'm not sure if the creation will fail (since there's no table in the database) or succeed but fail later when the user tries to use the view.  Ideally it would give a nice error message, e.g. "views not supported over temp tables."
ql/src/java/org/apache/hadoop/hive/ql/metadata/SessionHiveMetaStoreClient.java
<https://reviews.apache.org/r/22996/#comment82599>

    AFAICT there are no security checks here on who can create tables in what database.  Not sure how we should handle this, as you'd like users to be able to create temp tables even when they don't have a database they own and thus can create temp tables in.  But explicitly creating them in databases they don't have permission on is going to look like a security breach.

ql/src/java/org/apache/hadoop/hive/ql/metadata/SessionHiveMetaStoreClient.java
<https://reviews.apache.org/r/22996/#comment82600>

    Same as comment above on being able to create a temp table on any db.  This allows moving a temp table into any db.
- Alan Gates
On June 28, 2014, 12:35 a.m., Jason Dere wrote: