Aihua Xu created HIVE-15318:
-------------------------------

             Summary: Query "insert into table values()" creates the tmp table 
under the current database
                 Key: HIVE-15318
                 URL: https://issues.apache.org/jira/browse/HIVE-15318
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
    Affects Versions: 2.2.0
            Reporter: Aihua Xu
            Assignee: Aihua Xu


The current implementation of "insert into db1.table1 values()" creates a tmp 
table under the current database while table1 may not be under current 
database. 

e.g.,

{noformat}
use default;
create database db1;
create table db1.table1(x int);
insert into db1.table1 values(3);
{noformat}

It will create the tmp table under default database. Now if authorization is 
turned on and the current user only has access to db1 but not default database, 
then it will cause access issue.

We may need to rethink the approach for the implementation. 





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to