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