Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5318

Import Throws Error when Importing from a table export Hive 0.9 to Hive 0.10

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.9.0, 0.10.0
    • Fix Version/s: 0.13.0
    • Component/s: Import/Export
    • Labels:
      None

      Description

      When Exporting hive tables using the hive command in Hive 0.9 "EXPORT table TO 'hdfs_path'" then importing to another hive 0.10 instance using "IMPORT FROM 'hdfs_path'", hive throws this error:

      13/09/18 13:14:02 ERROR ql.Driver: FAILED: SemanticException Exception while processing
      org.apache.hadoop.hive.ql.parse.SemanticException: Exception while processing
      	at org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer.analyzeInternal(ImportSemanticAnalyzer.java:277)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:459)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:349)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:938)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:902)
      	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:412)
      	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)
      	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:706)
      	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
      	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.util.RunJar.main(RunJar.java:208)
      Caused by: java.lang.NullPointerException
      	at java.util.ArrayList.<init>(ArrayList.java:131)
      	at org.apache.hadoop.hive.ql.plan.CreateTableDesc.<init>(CreateTableDesc.java:128)
      	at org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer.analyzeInternal(ImportSemanticAnalyzer.java:99)
      	... 16 more
      
      13/09/18 13:14:02 INFO ql.Driver: </PERFLOG method=compile start=1379535241411 end=1379535242332 duration=921>
      13/09/18 13:14:02 INFO ql.Driver: <PERFLOG method=releaseLocks>
      13/09/18 13:14:02 INFO ql.Driver: </PERFLOG method=releaseLocks start=1379535242332 end=1379535242332 duration=0>
      13/09/18 13:14:02 INFO ql.Driver: <PERFLOG method=releaseLocks>
      13/09/18 13:14:02 INFO ql.Driver: </PERFLOG method=releaseLocks start=1379535242333 end=1379535242333 duration=0>
      

      This is probably a critical blocker for people who are trying to test Hive 0.10 in their staging environments prior to the upgrade from 0.9

        Attachments

        1. HIVE-5318.1.patch
          8 kB
          Xuefu Zhang
        2. HIVE-5318.patch
          3 kB
          Xuefu Zhang

          Activity

            People

            • Assignee:
              xuefuz Xuefu Zhang
              Reporter:
              bradruderman Brad Ruderman
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: