[HIVE-17520] Temp table with CTAS tries to create staging directory in the actual database directory

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Query Planning
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 12/Sep/17 18:37
• Updated: 12/Sep/17 19:09
• Resolved: 12/Sep/17 19:09

Description

User does not have FS permissions on the database directory.
Note that normal CREATE TEMPORARY TABLE (no CTAS) on that database does work.
However trying temp table with CTAS fails with the following error:

hive> create temporary table jdere_temp as select * from tpch_text_1000.nation;
FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://cn105-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/tpch_text_1000.db. Error encountered near token 'TOK_TMP_FILE'

Simple fix would be to set the staging directory to the temp table location for the case of temp tables.