Hive
  1. Hive
  2. HIVE-5858

Alter table fails with exception when fs.hdfs.impl.disable.cache is set false

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: Metastore
    • Labels:
      None

      Description

      http://www.mail-archive.com/user@hive.apache.org/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

          Activity

          Hide
          Navis added a comment -

          Good!

          Show
          Navis added a comment - Good!
          Hide
          Thejas M Nair added a comment -

          Looks good to me.
          I have same fix, with more comments in HIVE-3815 .
          Shall we use that ?

          Show
          Thejas M Nair added a comment - Looks good to me. I have same fix, with more comments in HIVE-3815 . Shall we use that ?
          Hide
          Hive QA added a comment -

          Overall: +1 all checks pass

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12614758/HIVE-5858.1.patch.txt

          SUCCESS: +1 4665 tests passed

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/372/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/372/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          

          This message is automatically generated.

          ATTACHMENT ID: 12614758

          Show
          Hive QA added a comment - Overall : +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12614758/HIVE-5858.1.patch.txt SUCCESS: +1 4665 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/372/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/372/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase This message is automatically generated. ATTACHMENT ID: 12614758

            People

            • Assignee:
              Navis
              Reporter:
              Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development