[
https://issues.apache.org/jira/browse/HIVE-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795615#comment-13795615
]
David Phillips commented on HIVE-2419:
--------------------------------------
[~appodictic], those are valid concerns but are orthogonal to the point of this
issue: address the asymmetry between {{CREATE TABLE}} and {{CREATE TABLE AS
SELECT}}, where the former creates the directory but the latter does not.
> 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
> Attachments: HIVE-2419.1.patch
>
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)
