hive启动错误总结
来源:互联网 发布:taft地震波数据下载 编辑:程序博客网 时间:2024/05/21 15:41
1,mysql加载的jar包未找到!
.........Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:232)at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:117)at org.datanucleus.store.rdbms.ConnectionFactoryImpl.<init>(ConnectionFactoryImpl.java:82)... 79 moreCaused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:213)... 81 more解决办法:
在mysql 官网下载 mysql-connector-java-5.0.8.tar.gz 的压缩包, 链接:mysql-connector下载 ,
下载好后解压,将mysql-connector-java-5.0.8-bin.jar文件移动到 hive的安装目录下的lib文件夹下。
tar -zxvf mysql-connector-java-5.0.8.tar.gz # 解压mv mysql-connector-java-5.0.8、mysql-connector-java-5.0.8-bin.jar hive/lib/ #其中 hive/lib 为你的安装目录注意:其中的 hive为你的安装hive安装目录。
2,MetaException(message 异常
Caused by: java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:423)at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1652)... 23 moreCaused by: MetaException(message:Version information not found in metastore. )at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:83)at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:92)at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6608)at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:239)at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70)... 28 moreCaused by: MetaException(message:Version information not found in metastore. )at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7754)解决方式:在hive/conf下的hive-site.xml文件中配置hive.metastore.schema.verification 属性为false:
<property> <name>hive.metastore.schema.verification</name> <value>false</value> </property>
其中hive.metastore.schema.verification防止架构版本不兼容时的 Metastore 操作。考虑将此设置为“True”,以减少 Metastore 操作期间发生架构损坏的可能性
3,MetaException(message:Hive metastore database is not initialized数据库没有初始化.
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Hive metastore database is not initialized. Please use schematool (e.g. ./schematool -initSchema -dbType ...) to create the schema. If needed, don't forget to include the option to auto-create the underlying database in your JDBC connection string (e.g. ?createDatabaseIfNotExist=true for mysql))at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3793)at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:244)at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:227)... 14 moreCaused by: MetaException(message:Hive metastore database is not initialized. Please use schematool (e.g. ./schematool -initSchema -dbType ...) to create the schema. If needed, don't forget to include the option to auto-create the underlying database in your JDBC connection string (e.g. ?createDatabaseIfNotExist=true for mysql))at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3556)at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3528)at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3790)... 16 more这是由于没有初始化数据库,生成元数据。 需要执行以下指令(在hive的bin目录下执行)
./schematool -initSchema -dbType mysql
阅读全文
0 0
- hive启动错误总结
- hive启动错误
- hive启动错误
- hive hwi 启动错误
- 0003.hive启动错误
- Hive 1.1.1 启动错误
- Hive安装出现错误总结
- 安装完hive,启动错误解决办法
- 启动hive报SafeModeException的错误
- hive源数据服务启动错误
- hadoop启动错误总结
- hive启动失败的小问题总结以及hive
- Hive总结(二) Hive导入时,格式不对错误
- hive学习中错误总结(一)
- hive第一次启动时,常出现的错误以及解决办法
- Spark1.4 和 Hive 1.1.1 启动错误
- 启动hive客户端对数据库进行操作时常有的错误
- HIVE 启动错误 :Name node is in safe mode
- 正则表达式三
- Navicat Premium连接oracle
- PAT乙级 1032题挖掘机技术哪家强
- js 实现table标题固定
- 记录N次失败的前端校招面试
- hive启动错误总结
- 尺取法(一)
- 学习密码学
- 微信开发之消息模板
- 判断字母顺序的问题,如AB...Z AA AB... ZZ这种如何判断
- ubuntu云服务器搭建jdk+mysql+tomcat
- keras框架
- 进程间通讯(一)管道
- nginx 支持thinkphp设置