[HIVE-2742] InvalidOperationException "alter table is not possible" when using LOAD DATA INPATH OVERWRITE with database and partition

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7.1
• Component/s: Database/Schema, Metastore, Query Processor

Environment

reproduced on cdh3u2 (haven't tried other versions)

• Assignee: Unassigned
• Reporter: Maxime Brugidou
• Created: 24/Jan/12 11:15
• Updated: 08/Aug/13 18:18

Description

Here is a repeatable procedure:

$ echo "test" | hadoop fs -put - test.txt
$ echo "test2" | hadoop fs -put - test2.txt

Then in hive:

> create database catalog;
> use catalog;
> create table test_load (t string) partitioned by (p string);
> use default;

Then the problem arises:

> load data inpath 'test.txt' overwrite into table catalog.test_load partition (p='test');
Loading data to table catalog.test_load partition (p=test)
OK
Time taken: 0.175 seconds
> load data inpath 'test2.txt' overwrite into table catalog.test_load partition (p='test');
Loading data to table catalog.test_load partition (p=test)
Moved to trash: hdfs://mycluster/user/hive/warehouse/catalog.db/test_load/p=test
Failed with exception InvalidOperationException(message:alter is not possible)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask