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

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 0.9.0, 0.10.0
    • 0.13.0
    • Import/Export
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: