hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-15318) Query "insert into table values()" creates the tmp table under the current database
Date Wed, 30 Nov 2016 22:15:58 GMT

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

Mime
View raw message