[ 
https://issues.apache.org/jira/browse/HIVE-15318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aihua Xu resolved HIVE-15318.
-----------------------------
    Resolution: Duplicate
      Assignee:     (was: Aihua Xu)

> 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
>
> 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