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