[HIVE-5858] Alter table fails with exception when fs.hdfs.impl.disable.cache is set false

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 0.13.0
• Component/s: Metastore
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 20/Nov/13 01:21
• Updated: 23/Mar/14 17:52
• Resolved: 21/Nov/13 10:44

Description

http://www.mail-archive.com/[e-mail]/msg10098.html

2013-11-20 10:07:05,759 ERROR metastore.RetryingHMSHandler (RetryingHMSHandler.java:invoke(141)) - InvalidOperationException(message:table new location hdfs://localhost:9000/user/hive/warehouse/xa is on a different file system than the old location hdfs://localhost:9000/user/hive/warehouse/zz. This operation is not supported)
        at org.apache.hadoop.hive.metastore.HiveAlterHandler.alterTable(HiveAlterHandler.java:146)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.alter_table_with_environment_context(HiveMetaStore.java:2352)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:103)
        at com.sun.proxy.$Proxy9.alter_table_with_environment_context(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.alter_table(HiveMetaStoreClient.java:216)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.alter_table(HiveMetaStoreClient.java:211)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
        at com.sun.proxy.$Proxy10.alter_table(Unknown Source)
        at org.apache.hadoop.hive.ql.metadata.Hive.alterTable(Hive.java:385)
        at org.apache.hadoop.hive.ql.exec.DDLTask.alterTable(DDLTask.java:3432)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:306)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:149)
        at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:87)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1485)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1256)
        at org.apache.hadoop.hive.ql.Driver.executePlan(Driver.java:1054)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:969)
        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:764)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)

Issue Links

• duplicates: HIVE-3815 hive table rename fails if filesystem cache is disabled