Jason Dere created HIVE-17520:
---------------------------------
Summary: Temp table with CTAS tries to create staging directory in
the actual database directory
Key: HIVE-17520
URL: https://issues.apache.org/jira/browse/HIVE-17520
Project: Hive
Issue Type: Bug
Components: Query Planning
Reporter: Jason Dere
Assignee: Jason Dere
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:
{noformat}
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'
{noformat}
Simple fix would be to set the staging directory to the temp table location for
the case of temp tables.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
