Hi All- I am trying to export a table in Hive 0.9, then import it into Hive 0.10 staging. Essentially moving data from a production import to staging.
I used the EXPORT table command, however when I try to import the table back into staging I receive the following (pulled from the hive.log file). Could anyone help to point me in what i should be looking that could cause the problem? This is a hive managed table in the source instance, where it was originally moved into hive by Sqoop. Thanks, Brad 2013-09-17 14:10:27,482 INFO parse.ParseDriver (ParseDriver.java:parse(433)) - Parsing command: IMPORT FROM 'hdfs://user/hdfs/test_table' 2013-09-17 14:10:27,482 INFO parse.ParseDriver (ParseDriver.java:parse(450)) - Parse Completed 2013-09-17 14:10:27,486 ERROR ql.Driver (SessionState.java:printError(427)) - 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.run(CliDriver.java:759) 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.IllegalArgumentException: java.net.UnknownHostException: user at org.apache.hadoop.security.SecurityUtil.buildTokenService(SecurityUtil.java:414) at org.apache.hadoop.hdfs.NameNodeProxies.createNonHAProxy(NameNodeProxies.java:164) at org.apache.hadoop.hdfs.NameNodeProxies.createProxy(NameNodeProxies.java:129) at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:448) at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:410) at org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:128) at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2308) at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:87) at org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2342) at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2324) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:351) at org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer.analyzeInternal(ImportSemanticAnalyzer.java:87) ... 15 more Caused by: java.net.UnknownHostException: user ... 27 more 2013-09-17 14:10:27,487 INFO ql.Driver (PerfLogger.java:PerfLogEnd(115)) - </PERFLOG method=compile start=1379452227481 end=1379452227487 duration=6> 2013-09-17 14:10:27,487 INFO ql.Driver (PerfLogger.java:PerfLogBegin(88)) - <PERFLOG method=releaseLocks> 2013-09-17 14:10:27,487 INFO ql.Driver (PerfLogger.java:PerfLogEnd(115)) - </PERFLOG method=releaseLocks start=1379452227487 end=1379452227487 duration=0> 2013-09-17 14:10:27,487 INFO ql.Driver (PerfLogger.java:PerfLogBegin(88)) - <PERFLOG method=releaseLocks> 2013-09-17 14:10:27,487 INFO ql.Driver (PerfLogger.java:PerfLogEnd(115)) - </PERFLOG method=releaseLocks start=1379452227487 end=1379452227487 duration=0>
