Hive 问题
2024-09-17 13:22:13
hive 重启连接不上
异常信息:
FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
解决方法:
rm metastore_db/*.lck
一般情况下都可以解决,要是还不行,就把这个目录删了
参考:
https://stackoverflow.com/questions/22711364/java-lang-runtimeexceptionunable-to-instantiate-org-apache-hadoop-hive-metastor
schematool -dbType mysql -initSchema 执行失败的问题
一般就是配置文件有问题 改成这样
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
--><configuration>
<!-- WARNING!!! This file is auto generated for documentation purposes ONLY! -->
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<!-- WARNING!!! Any changes you make to this file will be ignored by Hive. -->
<!-- WARNING!!! You must make your changes in hive-site.xml instead. -->
<!-- Hive Execution Parameters -->
</configuration>
最新文章
- kuangbin_SegTree M (HDU 4553)
- PRML读书会第十三章 Sequential Data(Hidden Markov Models,HMM)
- ubuntu eclipse 不能新建javaweb项目解决方案
- 实习小记-python 内置函数__eq__函数引发的探索
- yii框架AR详解
- I.MX6 git patch
- cgroup的测试数据
- 132. Palindrome Partitioning II
- C#委托 Lamda表达式
- 【v2.x OGE课程 14】 控制使用
- NDEF消息解析实例[转]
- vue报错 Do not use built-in or reserved HTML elements as component id:header
- android PM2.5监控demo开发
- ansible学习基础知识和模块(一)
- docker 7 docker的帮助命令
- Android 永久保存简单数据
- 题解-APIO2010 特别行动队
- Docker概念(二)
- js取得background属性url的值--移动端【踩坑】
- 五 js对象简介