[HIVE-11427] Location of temporary table for CREATE TABLE SELECT broken by HIVE-7079

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.1.0
• Assignee: Yongzhi Chen
• Reporter: Gregory Trubetskoy
• Created: 31/Jul/15 18:26
• Updated: 19/Jan/20 11:26
• Resolved: 17/Apr/16 05:54

Description

If a user does not have HDFS write permissions to the default database, and attempts to create a table in a private database to which the user does have permissions using CREATE TABLE AS SELECT from a table in the default database, the following happens:

use default;
create table grisha.blahblah as select * from some_table;
FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://nn.example.com/user/hive/warehouse. Error encountered near token 'TOK_TMP_FILE’

I've edited this issue because my initial explanation was completely bogus. A more likely explanation is in https://github.com/apache/hive/commit/1614314ef7bd0c3b8527ee32a434ababf7711278

 -                fname = ctx.getExternalTmpPath(
 +                fname = ctx.getExtTmpPathRelTo(  
    // and then something incorrect happens in getExtTmpPathRelTo()

In any event - the bug is that the location chosen for the temporary storage is not in the same place as the target table. It should be same as the target table (/user/hive/warehouse/grisha.db in the above example) because this is where presumably the user running the query would have write permissions to.

Issue Links

• is related to: HIVE-7079 Hive logs errors about missing tables when parsing CTE expressions