You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Aihua Xu (JIRA)" <ji...@apache.org> on 2016/11/30 14:19:58 UTC
[jira] [Created] (HIVE-15317) Query "insert into table values()"
creates the tmp table under the current database
Aihua Xu created HIVE-15317:
-------------------------------
Summary: Query "insert into table values()" creates the tmp table under the current database
Key: HIVE-15317
URL: https://issues.apache.org/jira/browse/HIVE-15317
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)