CREATE TABLE AS SELECT should create warehouse directory
--------------------------------------------------------
Key: HIVE-2419
URL: https://issues.apache.org/jira/browse/HIVE-2419
Project: Hive
Issue Type: Bug
Reporter: David Phillips
If you run a CTAS statement on a fresh Hive install without a warehouse
directory (as is the case with Amazon EMR), it runs the query but errors out at
the end:
{quote}
hive> create table foo as select * from t_message limit 1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
...
Ended Job = job_201108301753_0001
Moving data to:
hdfs://ip-10-202-22-194.ec2.internal:9000/mnt/hive_07_1/warehouse/foo
Failed with exception Unable to rename:
hdfs://ip-10-202-22-194.ec2.internal:9000/mnt/var/lib/hive_07_1/tmp/scratch/hive_2011-08-30_18-04-36_809_6130923980133666976/-ext-10001
to: hdfs://ip-10-202-22-194.ec2.internal:9000/mnt/hive_07_1/warehouse/foo
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask
{quote}
This is different behavior from a simple CREATE TABLE, which creates the
warehouse directory.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
