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)