hive报错 Another instance of Derby may have already booted the database
来源：互联网 发布：极域电子教室软件 编辑：程序博客网 时间：2024/05/17 19:15
刚装好hive后，启动之后showtables;等正常，退出之后再进入，就发现会报错
Caused by: ERROR XSDB6: Another instance ofDerbymay have already booted the database /opt/apache-hive-0.13.1-bin/metastore_db.
这个原因是因为采用了derby这个内嵌数据库作为数据库，它不支持多用户同时访问,解决办法就是
1.重新换mysql作为元数据库，方法见点击打开链接如果怎么配置都不能成功，就重新解压安装包，重新开始，另外hive-site.xml里的配置不是无关紧要的，之所以把它删了都能正常工作，是因为用了默认配置，hive-env.sh会有效，里面有一项配置hiveconf,说的就是hive-site.xml
2.如果不想重新换数据库，就用pkill–uhadoop，杀死hadoop下所有进程，包括hadoop namenode什么的，或着转到hive-home底下，ls后，如果发现有derby.log和metastore_db文件，就说明这时hive的数据库仍是derby，把它俩删除后，hive就又能正常工作了
0 0
- hive报错 Another instance of Derby may have already booted the database
- 1.Spark启动时hive出现another instance of derby may have already booted the database的错误
- 报错：This generally means that another instance of this process was already running or is hung in the
- 报表工具FineReport报错：java.sql.SQLException: The database is already in use by another process: lockFile
- the file is already open in another instance of axure RP
- Java Database Derby Instance 1
- Java Database Derby Instance 2
- This generally means that another instance of this process was already running or is hung in the deb
- This generally means that another instance of this process was already running or is hung in the deb
- This generally means that another instance of this process was already running or is hung in the deb
- WP7 报 Element is already the child of another element. [Line: 0 Position: 0]
- SQL1047N The application is already connected to another database.
- Repository模式中，Update和Delete总是失败及其解析（报错“another entity of the same type already has the same primar”）
- MySQL启动报错Another MySQL daemon already running with the same unix socket.
- mysql启动报错：Another MySQL daemon already running with the same unix socket.
- mysql启动报错：Another MySQL daemon already running with the same unix socket.
- Node 2478301 does not exist in the cache. It may have been deleted already.
- Tomcat报错，May be locked by another process.
- Dom编程（树 收缩效果）
- Ubuntu apt-get详解
- 字符串分割(C++)
- java获取天气预报数据
- hdu 1879——继续畅通工程 最小生成树
- hive报错 Another instance of Derby may have already booted the database
- python列表操作
- WebBrowser控件禁用超链接转向、脚本错误提示、默认右键菜单和快捷键
- 矩阵分解
- CloudStack4.4开发，API调用java实例
- Log4j基本配置
- Hbase热点问题
- MVC 模型常见验证
- 总结的一些Java公用函数库
