You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Thomas Sun <th...@twitter.com> on 2016/09/13 20:36:57 UTC

Help with 'alter is not possible' in metastore

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 org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter
partition. alter is not possible (state=08S01,code=1)

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

at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)

at org.apache.hive.beeline.Commands.execute(Commands.java:849)

at org.apache.hive.beeline.Commands.sql(Commands.java:714)

at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973)

at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813)

at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771)

at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(
BeeLine.java:484)

at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.hadoop.util.RunJar.run(RunJar.java:221)

at org.apache.hadoop.util.RunJar.main(RunJar.java:136)


Altering works fine in a test table in our dev env. The logs here aren't
too helpful. From reading the source code, there's some invalidObject(Not
missing partition, it would throw Partition does not exist). However, when
I do a describe on the partition, everything looks ok.


Please help!

Thanks,

Tom

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

Posted by Gopal Vijayaraghavan <go...@apache.org>.
> 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 hiveserver2 logs might have a different backtrace than this, with more information in it.

FYI, you can check the backend DB for the actual value.

Cheers,
Gopal