Re: Help with 'alter is not possible' in metastore

2016-09-13 Thread Gopal Vijayaraghavan
> java.sql.SQLException: Error while processing statement: FAILED: Execution > Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to > alter partition. alter is not possible > Altering works fine in a test table in our dev env. The logs here aren't too > helpful. The

Help with 'alter is not possible' in metastore

2016-09-13 Thread Thomas Sun
Hi, We have an external table where we need to manually fix a corrupted location path for a few of its partitions. After successfully disabling security, I run into the following error when doing an alter table: Error: Error while processing statement: FAILED: Execution Error, return code 1 from