[HIVE-5318] Import Throws Error when Importing from a table export Hive 0.9 to Hive 0.10

• 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
• Assignee: Xuefu Zhang
• Reporter: Brad Ruderman
• Created: 19/Sep/13 06:41
• Updated: 06/Nov/13 16:13
• Resolved: 25/Sep/13 23:03

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

Issue Links

• links to: https://reviews.apache.org/r/14321/