devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Hive之——启动问题及解决方案_datanucleus.schema.autocreateall

作者：花生_TL007 | 2024-06-14 19:44:18

赞

踩

datanucleus.schema.autocreateall

转载请注明出处：http://blog.csdn.net/l1028386804/article/details/51566262

问题1：

Caused by: javax.jdo.JDODataStoreException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
NestedThrowables:
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:461)
        at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
        at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
        at org.apache.hadoop.hive.metastore.ObjectStore.setMetaStoreSchemaVersion(ObjectStore.java:6664)
解决方法：
查看并跟踪hive的源码得出 

  1.  if ((this.readOnlyDatastore) || (this.fixedDatastore))  
  2.  {  
  3.    this.autoCreateTables = false;  
  4.    this.autoCreateColumns = false;  
  5.    this.autoCreateConstraints = false;  
  6.  }  
  7.  else  
  8.  {  
  9.    boolean autoCreateSchema = conf.getBooleanProperty("datanucleus.autoCreateSchema");  
  10.    if (autoCreateSchema)  
  11.    {  
  12.      this.autoCreateTables = true;  
  13.      this.autoCreateColumns = true;  
  14.      this.autoCreateConstraints = true;  
  15.    }  
  16.    else
  17.    {  
  18.      this.autoCreateColumns = conf.getBooleanProperty("datanucleus.autoCreateColumns");  
  19.      this.autoCreateTables = conf.getBooleanProperty("datanucleus.autoCreateTables");  
  20.      this.autoCreateConstraints = conf.getBooleanProperty("datanucleus.autoCreateConstraints");  
  21.    }
  22.  }
看来关键是 this.readOnlyDatastore和this.fixedDatastore 这2个字段而且autoCreateSchema 这个设置为true 就可以决定了其他的设置，所以其他设置在此都无效了。继续追踪org.datanucleus.store.AbstractStoreManager 发现了这2个字段的设置代码 

  1.   this.readOnlyDatastore = conf.getBooleanProperty("datanucleus.readOnlyDatastore");
  2.   this.fixedDatastore = conf.getBooleanProperty("datanucleus.fixedDatastore");
修改的配置的内容如下 

  1. <property>
  2.     <name>datanucleus.readOnlyDatastore</name>
  3.     <value>false</value>
  4. </property>
  5. <property> 
  6.     <name>datanucleus.fixedDatastore</name>
  7.     <value>false</value> 
  8. </property>
  9. <property> 
  10.     <name>datanucleus.autoCreateSchema</name> 
  11.     <value>true</value> 
  12. </property>
  13. <property>
  14.     <name>datanucleus.autoCreateTables</name>
  15.     <value>true</value>
  16. </property>
  17. <property>
  18.     <name>datanucleus.autoCreateColumns</name>
  19.     <value>true</value>
  20. </property>

或者将：

  1. <property>
  2.     <name>datanucleus.schema.autoCreateAll</name>
  3.     <value>false</value>
  4.     <description>creates necessary schema on a startup if one doesn't exist. set this to false, after creating it once</description>
  5.  </property>
修改为 

  1. <property>
  2.     <name>datanucleus.schema.autoCreateAll</name>
  3.     <value>true</value>
  4.     <description>creates necessary schema on a startup if one doesn't exist. set this to false, after creating it once</description>
  5.  </property>

问题2：

16/06/02 10:49:52 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
16/06/02 10:49:52 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.properties
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: The root scratch dir: /tmp/hive on HDFS should be writable. Current permissions are: rwx--x--x
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
Caused by: java.lang.RuntimeException: The root scratch dir: /tmp/hive on HDFS should be writable. Current permissions are: rwx--x--x
        at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:529)
        at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:478)
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)
        ... 7 more
解决方法： 
[root@hadoop ~]# hadoop fs -chmod -R 777 /tmp/hive
[root@hadoop ~]# hadoop fs -ls /tmp
Found 1 items
drwxrwxrwx   - root supergroup          0 2016-06-02 08:48 /tmp/hive
问题3： 
16/06/02 09:33:13 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
16/06/02 09:33:13 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.properties
Exception in thread "main" java.lang.RuntimeException: java.net.ConnectException: Call to hadoop/192.168.52.139:9000 failed on connection exception: java.net.ConnectException: Connection refused
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
Caused by: java.net.ConnectException: Call to hadoop/192.168.52.139:9000 failed on connection exception: java.net.ConnectException: Connection refused
解决方法:
此问题是因为 hadoop没有启动，启动hadoop后问题解决
问题4： 

[root@hadoop ~]# hive
16/06/02 09:38:06 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
16/06/02 09:38:06 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.properties
hive>
解决方法：
在0.10  0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用。
在配置文件里面： 
  1.  <property>
  2.  	<name>hive.metastore.local</name>
  3.   	<value>false</value>
  4.   	<description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description>
  5. </property>
删除掉，再次登录警告就消失了
问题5： 
Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
Caused by: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
        at org.apache.hadoop.fs.Path.initialize(Path.java:148)
        at org.apache.hadoop.fs.Path.<init>(Path.java:126)
        at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:487)
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)
        ... 7 more
Caused by: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
        at java.net.URI.checkPath(URI.java:1804)
        at java.net.URI.<init>(URI.java:752)
        at org.apache.hadoop.fs.Path.initialize(Path.java:145)
        ... 10 more
解决方法：
在配置文件hive-site.xml里找"system:java.io.tmpdir"把他们都换成绝对路径如：/home/grid/apache-hive-0.14.0-bin/iotmp
hive-site.xml 完整的内容如下： 

  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  2. <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
  3.  
  4. <configuration>
  5.  
  6.     <property> 
  7.         <name>javax.jdo.option.ConnectionURL</name> 
  8.         <value>jdbc:mysql://192.168.52.139:3306/hive?createDatabaseIfNotExsit=true;characterEncoding=UTF-8</value> 
  9.     </property> 
  10.     <property> 
  11.         <name>javax.jdo.option.ConnectionDriverName</name> 
  12.         <value>com.mysql.jdbc.Driver</value>
  13.     </property>
  14.     <property>
  15.         <name>javax.jdo.option.ConnectionUserName</name>
  16.         <value>hive</value>
  17.     </property>
  18.     <property> 
  19.         <name>javax.jdo.option.ConnectionPassword</name> 
  20.         <value>hive</value> 
  21.     </property> 
  22.  
  23.     <property>
  24.         <name>datanucleus.readOnlyDatastore</name>
  25.         <value>false</value>
  26.     </property>
  27.     <property> 
  28.         <name>datanucleus.fixedDatastore</name>
  29.         <value>false</value> 
  30.     </property>
  31.  
  32.     <property> 
  33.         <name>datanucleus.autoCreateSchema</name> 
  34.         <value>true</value> 
  35.     </property>
  36.     
  37.     <property>
  38.         <name>datanucleus.autoCreateTables</name>
  39.         <value>true</value>
  40.     </property>
  41.  
  42.     <property>
  43.         <name>datanucleus.autoCreateColumns</name>
  44.         <value>true</value>
  45.     </property>
  46.  
  47. </configuration>

问题6：

hive> show tables;
FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
分析：

由于mysql的最大索引长度导致，MySQL的varchar主键只支持不超过768个字节 或者 768/2=384个双字节 或者 768/3=256个三字节的字段 而 GBK是双字节的，UTF-8是三字节的。

解决方案：

数据库的字符集除了system为utf8，其他最好为latin1，否则可能出现如上异常，在mysql机器的上运行:

  1. mysql> show variables like '%char%';
  2. mysql>alter database 库名 character set latin1;
  3. mysql>flush privileges;

声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号