API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 7th, 2017
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.11 KB | None | 0 0
raw download clone embed print report
  1. SLF4J: Class path contains multiple SLF4J bindings.
  2. SLF4J: Found binding in [jar:file:/home/server/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  3. SLF4J: Found binding in [jar:file:/home/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  4. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  5. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
  6.  
  7. Logging initialized using configuration in jar:file:/home/server/hive/lib/hive-common-2.1.1.jar!/hive-log4j2.properties Async: true
  8. Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  9. Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  10. Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  11. Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  12. Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  13. Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  14. Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  15. Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  16. Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  17. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:591)
  18. at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:531)
  19. at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705)
  20. at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)
  21. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  22. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  23. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  24. at java.lang.reflect.Method.invoke(Method.java:498)
  25. at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
  26. at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
  27. Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  28. at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:226)
  29. at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:366)
  30. at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:310)
  31. at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:290)
  32. at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:266)
  33. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:558)
  34. ... 9 more
  35. Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  36. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1654)
  37. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80)
  38. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130)
  39. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101)
  40. at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3367)
  41. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3406)
  42. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3386)
  43. at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3640)
  44. at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:236)
  45. at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:221)
  46. ... 14 more
  47. Caused by: java.lang.reflect.InvocationTargetException
  48. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  49. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  50. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  51. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  52. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1652)
  53. ... 23 more
  54. Caused by: MetaException(message:Version information not found in metastore. )
  55. at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7753)
  56. at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7731)
  57. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  58. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  59. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  60. at java.lang.reflect.Method.invoke(Method.java:498)
  61. at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)
  62. at com.sun.proxy.$Proxy21.verifySchema(Unknown Source)
  63. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:565)
  64. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:626)
  65. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416)
  66. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
  67. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
  68. at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6490)
  69. at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:238)
  70. at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70)
  71. ... 28 more
  72.  
  73. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  74. <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
  75. <configuration>
  76.  
  77. <property>
  78. <name>javax.jdo.option.ConnectionURL</name>
  79. <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
  80. </property>
  81.  
  82.  
  83. <property>
  84. <name>javax.jdo.option.ConnectionDriverName</name>
  85. <value>com.mysql.jdbc.Driver</value>
  86. </property>
  87.  
  88. <property>
  89. <name>javax.jdo.option.ConnectionUserName</name>
  90. <value>hive</value>
  91. </property>
  92.  
  93. <property>
  94. <name>javax.jdo.option.ConnectionPassword</name>
  95. <value>password</value>
  96. </property>
  97.  
  98. </configuration>
  99.  
  100. cd $HIVE_HOME/scripts/metastore/upgrade/mysql/
  101.  
  102. < Login into MySQL >
  103.  
  104. mysql> drop database IF EXISTS hive;
  105. mysql> create database hive;
  106. mysql> use hive;
  107. mysql> source hive-schema-2.1.1.mysql.sql;
  108.  
  109. ./bin/schematool -dbType derby -upgradeSchemaFrom 2.1.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!