hive> select * from dummy;
FAILED: Hive Internal Error: java.lang.RuntimeException(Error while making MR scratch directory - check filesystem config (null))
java.lang.RuntimeException: Error while making MR scratch directory - check filesystem config (null)
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Context.getMRScratchDir(Context.java:216)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Context.getMRTmpFileURI(Context.java:267)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1063)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7275)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:430)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Driver.run(Driver.java:889)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at sun.reflect.NativeMethodAccessorImpl<wbr>.invoke0(Native Method)</wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at sun.reflect.NativeMethodAccessorImpl<wbr>.invoke(NativeMethodAccessorImpl<wbr>.java:39)</wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at sun.reflect.DelegatingMethodAccessor<wbr>Impl.invoke(DelegatingMethodAccessor<wbr>Impl.java:25)</wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at java.lang.reflect.Method.invoke(Method.java:597)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.util.RunJar.main(RunJar.java:197)</wbr></wbr></wbr></wbr>
Caused by: java.lang.IllegalArgumentException<wbr>: Wrong FS: hdfs://172.16.27.115:9000/opt/hadoop-0.20.2-cdh3u3/hadoop-root/hive_2012-04-25_16-38-44_851_5689096273896907591, expected: hdfs://namenode115:9000</wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.fs.FileSystem.checkPath(FileSystem.java:410)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hdfs.DistributedFileSystem.checkPath(DistributedFileSystem.java:106)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.fs.FileSystem.makeQualified(FileSystem.java:322)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hdfs.DistributedFileSystem.makeQualified(DistributedFileSystem.java:123)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Context.getScratchDir(Context.java:164)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>at org.apache.hadoop.hive.ql.Context.getMRScratchDir(Context.java:210)</wbr></wbr></wbr></wbr>
<wbr><wbr><wbr><wbr>... 17 more</wbr></wbr></wbr></wbr>
进入 $hadoop_home vi conf/core-site.xml
之前配置是:
<property>
<name>fs.default.name</name>
<value>hdfs://172.16.27.115:9000</value>
</property>
查看vim /etc/hosts
172.16.27.115 namenode115
修改core-site.xml中ip为hostname
<property>
<name>fs.default.name</name>
<value>hdfs://namenode115<wbr>:9000</value></wbr>
</property>
重启hadoop,在进入hive查询即可
分享到:
相关推荐
"java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver" 解决方案 [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 解决了jsp连接 sql server 2000的问题
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 解决方法 ...
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
解决方案:Exceptionin thread "main" java.lang.UnsatisfiedLinkError:org.apache.hadoop.util.NativeCrc32.nativeCo
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 通过控制台的...
Hive错误之 Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask错误分析_xiaohu21的博客-CSDN博客.mht
[HiveServer2-Handler-Pool: Thread-55]: Error opening session: org.apache.hive.service.cli.HiveSQLException: Failed to open new session: java.lang.IllegalArgumentException: Cannot modify hive.query....
hive 开发UDF 使用maven工程 引发jar包缺失 hive 开发UDF 使用maven工程 引发jar包缺失
大数据管理与监控:Ambari:Hive数据仓库管理.docx
当遇到此运行时异常时,可以尝试禁用向量化执行或者混合Grace Hash Join,设置`hive.vectorized.execution.enabled`为false,以及`hive.mapjoin.hybridgrace.hashtable`和`hive.vectorized.execution.reduce....
- 类名:org.apache.hive.jdbc.HiveDriver - 驱动库:浏览并选择你刚刚下载的"hive-jdbc-uber-2.6.5.0-292.jar"文件。 3. 配置连接:在驱动配置完成后,创建一个新的数据库连接。输入Hive服务器的相关信息,如...
错误: 代理抛出异常错误: java.rmi.server.ExportException: Port already in use: 1099; nested exception is: java.net.BindException: Address already in use: JVM_Bind 这里说的是1099端口被其它进程占用...
出现此问题时使用:java.lang.NullPointerException at org.json.JSONObject.(JSONObject.java:144) at org.apache.sqoop.util.SqoopJsonUtil.getJsonStringforMap(SqoopJsonUtil.java:43) at org.apache.sqoop....
读书笔记:Hive与Scala编程相关工具
在Java编程中,`NoSuchMethodError` 是一个常见的运行时异常,它表示在类加载时找到了该类,但在该类中却找不到特定方法的定义。这个问题通常发生在不同版本的库之间存在不兼容的情况,即在编译时使用的库版本包含了...
driver = "org.apache.hive.jdbc.HiveDriver" user = "hive" password = "hive" table = ods_wjw_jb_gxy_hz_glk query = "select a,b,c from ods_wjw_jb_gxy_hz_glk" fetch_size = 300 } }
在使用Hive的Beeline客户端进行连接时,可能会遇到错误提示"Could not open client transport with JDBC Uri: jdbc:hive2://hcmaster:10000/default"。这个错误通常意味着Beeline无法通过JDBC URL成功建立到Hive ...
一、hive版本验证,FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata....解决方法 ...
SparkSQL通过Hive创建DataFrame问题分析 问题一 Caused by: org.apache.spark.sql.catalyst.analysis.NoSuchTableException: Table or view 'stu' not found in database 'default'; 分析:确实没有临时表View,...