I'm not sure but when you need to make a remote connection, you may try using the filesystem confs(hdfs-site.xml and core-site.xml) of remote DFS(hadoop-1xx:9000) in the classpath of hive client of cluster(ds-1xx)(remember to exclude the local hdfs-site.xml and core-site.xml)
Regards Tanvi Thacker On Mon, Oct 22, 2018 at 5:28 AM Anup Tiwari <anupsdtiw...@gmail.com> wrote: > Hi All, > > I have Hive 2.1.1 installed on one of our cluster(hadoop-1xx:9000) and now > i am trying to read it from another Hive(2.1.1) cluster(ds-1xx) but it is > throwing me below error, also it seems like HIVE-14380 > <https://jira.apache.org/jira/browse/HIVE-14380> so do we have any > workaround for this OR upgrading hive is the only option :- > > *ERROR :-* > > 2018-10-22T17:13:40,100 ERROR [main] ql.Driver: FAILED: SemanticException > Unable to determine if hdfs://hadoop-1xx:9000/usr/hive/warehouse/cad_s3 is > encrypted: java.lang.IllegalArgumentException: Wrong FS: > hdfs://hadoop-1xx:9000/usr/hive/warehouse/cad_s3, expected: > hdfs://ds-1xx:9000 > org.apache.hadoop.hive.ql.parse.SemanticException: Unable to determine if > hdfs://hadoop-1xx:9000/usr/hive/warehouse/cad_s3 is encrypted: > java.lang.IllegalArgumentException: Wrong FS: > hdfs://hadoop-1xx:9000/usr/hive/warehouse/cad_s3, expected: > hdfs://ds-1xx:9000 > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1860) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10775) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10826) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:246) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:250) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:477) > at > org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1242) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1384) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1171) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1161) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:232) > at > org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:183) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:399) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:776) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:714) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:239) > at org.apache.hadoop.util.RunJar.main(RunJar.java:153) > > > Regards, > Anup Tiwari >