InvalidOperationException "alter table is not possible" when using LOAD DATA
INPATH OVERWRITE with database and partition
-------------------------------------------------------------------------------------------------------------------------
Key: HIVE-2742
URL: https://issues.apache.org/jira/browse/HIVE-2742
Project: Hive
Issue Type: Bug
Components: Metastore, Query Processor
Affects Versions: 0.7.1
Environment: reproduced on cdh3u2 (haven't tried other versions)
Reporter: Maxime Brugidou
Here is a repeatable procedure:
{code}
$ echo "test" | hadoop fs -put - test.txt
$ echo "test2" | hadoop fs -put - test2.txt
{code}
Then in hive:
{code}
> create database catalog;
> use catalog;
> create table test_load (t string) partitioned by (p string);
> use default;
{code}
Then the problem arises:
{code}
> 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
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
