[root@master conf]# jps
1648 SupportToolServer
58545 NodeManager
113575 HMaster
15447 NameNode
16952 Jps
58248 ResourceManager
57883 QuorumPeerMain
15084 DataNode
113901 HRegionServer
1581 AmbariServer
[root@master conf]# [root@bigdata1 lib]# netstat -anp|grep 10000
-bash: [root@bigdata1: command not found
[root@master conf]# netstat -anp|grep 10000
[root@master conf]# netstat -tnlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 192.168.70.143:8020 0.0.0.0:* LISTEN 15447/java
tcp 0 0 192.168.70.143:50070 0.0.0.0:* LISTEN 15447/java
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 935/sshd
tcp 0 0 0.0.0.0:50010 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:50075 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:8670 0.0.0.0:* LISTEN 1389/python
tcp 0 0 127.0.0.1:44995 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:8010 0.0.0.0:* LISTEN 15084/java
tcp6 0 0 :::8141 :::* LISTEN 18168/java
tcp6 0 0 :::41646 :::* LISTEN 18765/java
tcp6 0 0 :::45454 :::* LISTEN 17850/java
tcp6 0 0 192.168.70.143:3888 :::* LISTEN 18765/java
tcp6 0 0 :::8080 :::* LISTEN 1581/java
tcp6 0 0 :::80 :::* LISTEN 934/httpd
tcp6 0 0 :::8050 :::* LISTEN 18168/java
tcp6 0 0 192.168.70.143:16020 :::* LISTEN 113901/java
tcp6 0 0 :::22 :::* LISTEN 935/sshd
tcp6 0 0 :::7447 :::* LISTEN 17850/java
tcp6 0 0 :::8088 :::* LISTEN 18168/java
tcp6 0 0 :::8440 :::* LISTEN 1581/java
tcp6 0 0 :::8025 :::* LISTEN 18168/java
tcp6 0 0 :::8441 :::* LISTEN 1581/java
tcp6 0 0 :::13562 :::* LISTEN 17850/java
tcp6 0 0 :::8030 :::* LISTEN 18168/java
tcp6 0 0 :::16030 :::* LISTEN 113901/java
tcp6 0 0 192.168.70.143:16000 :::* LISTEN 113575/java
tcp6 0 0 :::9440 :::* LISTEN 1648/java
tcp6 0 0 :::9441 :::* LISTEN 1648/java
tcp6 0 0 :::2181 :::* LISTEN 18765/java
tcp6 0 0 :::8040 :::* LISTEN 17850/java
tcp6 0 0 :::9000 :::* LISTEN 1648/java
tcp6 0 0 :::7337 :::* LISTEN 17850/java
tcp6 0 0 :::8042 :::* LISTEN 17850/java
tcp6 0 0 :::16010 :::* LISTEN 113575/java
tcp6 0 0 :::3306 :::* LISTEN 1202/mysqld
[root@master conf]# hadoop version
Hadoop 2.7.3.2.6.3.0-235
Subversion git@github.com:hortonworks/hadoop.git -r 45bfd33bba8acadfa0e6024c80981c023b28d454
Compiled by jenkins on 2017-10-30T02:33Z
Compiled with protoc 2.5.0
From source with checksum cd1a4a466ef450f547c279989f3aa3
This command was run using /usr/hdp/2.6.3.0-235/hadoop/hadoop-common-2.7.3.2.6.3.0-235.jar
[root@master conf]# hive
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
Logging initialized using configuration in file:/etc/hive/2.6.3.0-235/0/hive-log4j.properties
hive> show databases;
OK
default
Time taken: 1.676 seconds, Fetched: 1 row(s)
hive> show tables;
OK
Time taken: 1.749 seconds
hive> quit;\
>
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# clear
[root@master conf]# ls
beeline-log4j.properties.template hive-env.sh.template ivysettings.xml
conf.server hive-exec-log4j.properties mapred-site.xml
hive-default.xml.template hive-log4j.properties parquet-logging.properties
hive-env.sh hive-site.xml
[root@master conf]# pwd
/usr/hdp/2.6.3.0-235/hive/conf
[root@master conf]# ls
beeline-log4j.properties.template hive-env.sh.template ivysettings.xml
conf.server hive-exec-log4j.properties mapred-site.xml
hive-default.xml.template hive-log4j.properties parquet-logging.properties
hive-env.sh hive-site.xml
[root@master conf]# vi hive-site.xml
[root@master conf]# netstat -tnlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 192.168.70.143:8020 0.0.0.0:* LISTEN 15447/java
tcp 0 0 192.168.70.143:50070 0.0.0.0:* LISTEN 15447/java
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 935/sshd
tcp 0 0 0.0.0.0:50010 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:50075 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:8670 0.0.0.0:* LISTEN 1389/python
tcp 0 0 127.0.0.1:44995 0.0.0.0:* LISTEN 15084/java
tcp 0 0 0.0.0.0:8010 0.0.0.0:* LISTEN 15084/java
tcp6 0 0 :::8141 :::* LISTEN 18168/java
tcp6 0 0 :::41646 :::* LISTEN 18765/java
tcp6 0 0 :::45454 :::* LISTEN 17850/java
tcp6 0 0 192.168.70.143:3888 :::* LISTEN 18765/java
tcp6 0 0 :::8080 :::* LISTEN 1581/java
tcp6 0 0 :::80 :::* LISTEN 934/httpd
tcp6 0 0 :::8050 :::* LISTEN 18168/java
tcp6 0 0 192.168.70.143:16020 :::* LISTEN 113901/java
tcp6 0 0 :::22 :::* LISTEN 935/sshd
tcp6 0 0 :::7447 :::* LISTEN 17850/java
tcp6 0 0 :::8088 :::* LISTEN 18168/java
tcp6 0 0 :::8440 :::* LISTEN 1581/java
tcp6 0 0 :::8025 :::* LISTEN 18168/java
tcp6 0 0 :::8441 :::* LISTEN 1581/java
tcp6 0 0 :::13562 :::* LISTEN 17850/java
tcp6 0 0 :::8030 :::* LISTEN 18168/java
tcp6 0 0 :::16030 :::* LISTEN 113901/java
tcp6 0 0 192.168.70.143:16000 :::* LISTEN 113575/java
tcp6 0 0 :::9440 :::* LISTEN 1648/java
tcp6 0 0 :::9441 :::* LISTEN 1648/java
tcp6 0 0 :::2181 :::* LISTEN 18765/java
tcp6 0 0 :::8040 :::* LISTEN 17850/java
tcp6 0 0 :::9000 :::* LISTEN 1648/java
tcp6 0 0 :::7337 :::* LISTEN 17850/java
tcp6 0 0 :::8042 :::* LISTEN 17850/java
tcp6 0 0 :::16010 :::* LISTEN 113575/java
tcp6 0 0 :::3306 :::* LISTEN 1202/mysqld
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# free -h
total used free shared buff/cache available
Mem: 3.7G 3.3G 199M 3.1M 212M 190M
Swap: 2.0G 1.0G 987M
[root@master conf]# clear
[root@master conf]# ls
beeline-log4j.properties.template hive-default.xml.template hive-env.sh.template hive-log4j.properties ivysettings.xml parquet-logging.properties
conf.server hive-env.sh hive-exec-log4j.properties hive-site.xml mapred-site.xml
[root@master conf]# hive --service metastore &
[1] 36832
[root@master conf]# Starting Hive Metastore Server
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# hive --service hiveserver2 &
[2] 37084
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# MetaException(message:javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:671)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:834)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
NestedThrowablesStackTrace:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor61.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:330)
at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:203)
at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:162)
at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:284)
at sun.reflect.GeneratedConstructorAccessor60.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContextHelper.createStoreManagerForProperties(NucleusContextHelper.java:133)
at org.datanucleus.PersistenceNucleusContextImpl.initialise(PersistenceNucleusContextImpl.java:420)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:821)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
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)
... 59 more
Caused 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)
... 61 more
)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:82)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
Caused by: MetaException(message:javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:671)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:834)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
NestedThrowablesStackTrace:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor61.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:330)
at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:203)
at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:162)
at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:284)
at sun.reflect.GeneratedConstructorAccessor60.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContextHelper.createStoreManagerForProperties(NucleusContextHelper.java:133)
at org.datanucleus.PersistenceNucleusContextImpl.initialise(PersistenceNucleusContextImpl.java:420)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:821)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
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)
... 59 more
Caused 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)
... 61 more
)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:212)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
... 11 more
Exception in thread "main" MetaException(message:javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:671)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:834)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
NestedThrowablesStackTrace:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor61.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:330)
at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:203)
at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:162)
at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:284)
at sun.reflect.GeneratedConstructorAccessor60.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContextHelper.createStoreManagerForProperties(NucleusContextHelper.java:133)
at org.datanucleus.PersistenceNucleusContextImpl.initialise(PersistenceNucleusContextImpl.java:420)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:821)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
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)
... 59 more
Caused 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)
... 61 more
)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:82)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
Caused by: MetaException(message:javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:671)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:834)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
NestedThrowablesStackTrace:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor61.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:330)
at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:203)
at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:162)
at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:284)
at sun.reflect.GeneratedConstructorAccessor60.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContextHelper.createStoreManagerForProperties(NucleusContextHelper.java:133)
at org.datanucleus.PersistenceNucleusContextImpl.initialise(PersistenceNucleusContextImpl.java:420)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:821)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at javax.jdo.JDOHelper$16.run(JDOHelper.java:1975)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1970)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1177)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:814)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:702)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:495)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:524)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:385)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:322)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:283)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:620)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:651)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:91)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6391)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6658)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6575)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
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)
... 59 more
Caused 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)
... 61 more
)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:212)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
... 11 more
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
[1]- Exit 1 hive --service metastore
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# jps
1648 SupportToolServer
37665 Jps
113575 HMaster
15447 NameNode
18168 ResourceManager
17850 NodeManager
37084 RunJar
15084 DataNode
113901 HRegionServer
1581 AmbariServer
18765 QuorumPeerMain
[root@master conf]# clear
[root@master conf]# ls
beeline-log4j.properties.template hive-default.xml.template hive-env.sh.template hive-log4j.properties ivysettings.xml parquet-logging.properties
conf.server hive-env.sh hive-exec-log4j.properties hive-site.xml mapred-site.xml
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]#
[root@master conf]# cd ..
[root@master hive]# ls
bin conf doc hive.tar.gz jdbc lib log man metastore scripts
[root@master hive]# cd jdbc/
[root@master jdbc]# ls
hive-jdbc-1.2.1000.2.6.3.0-235-standalone.jar
[root@master jdbc]# cd ..
[root@master hive]# ls
bin conf doc hive.tar.gz jdbc lib log man metastore scripts
[root@master hive]# cd lib/
[root@master lib]# ls
accumulo-core-1.7.0.2.6.3.0-235.jar curator-recipes-2.6.0.jar hive-metastore.jar log4j-1.2.16.jar
accumulo-fate-1.7.0.2.6.3.0-235.jar datanucleus-api-jdo-4.2.1.jar hive-serde-1.2.1000.2.6.3.0-235.jar mail-1.4.1.jar
accumulo-start-1.7.0.2.6.3.0-235.jar datanucleus-core-4.1.6.jar hive-serde.jar maven-scm-api-1.4.jar
accumulo-trace-1.7.0.2.6.3.0-235.jar datanucleus-rdbms-4.1.7.jar hive-service-1.2.1000.2.6.3.0-235.jar maven-scm-provider-svn-commons-1.4.jar
activation-1.1.jar derby-10.10.2.0.jar hive-service.jar maven-scm-provider-svnexe-1.4.jar
ant-1.9.1.jar dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar hive-shims-0.20S-1.2.1000.2.6.3.0-235.jar metrics-core-3.1.0.jar
ant-launcher-1.9.1.jar eigenbase-properties-1.1.5.jar hive-shims-0.23-1.2.1000.2.6.3.0-235.jar metrics-json-3.1.0.jar
antlr-2.7.7.jar geronimo-annotation_1.0_spec-1.1.1.jar hive-shims-1.2.1000.2.6.3.0-235.jar metrics-jvm-3.1.0.jar
antlr-runtime-3.4.jar geronimo-jaspic_1.0_spec-1.0.jar hive-shims-common-1.2.1000.2.6.3.0-235.jar netty-3.7.0.Final.jar
apache-curator-2.6.0.pom geronimo-jta_1.1_spec-1.1.1.jar hive-shims-common.jar ojdbc6.jar
apache-log4j-extras-1.2.17.jar groovy-all-2.4.11.jar hive-shims.jar opencsv-2.3.jar
asm-commons-3.1.jar guava-14.0.1.jar hive-shims-scheduler-1.2.1000.2.6.3.0-235.jar oro-2.0.8.jar
asm-tree-3.1.jar HikariCP-2.5.1.jar hive-shims-scheduler.jar paranamer-2.3.jar
avatica-1.8.0.2.6.3.0-235.jar hive-accumulo-handler-1.2.1000.2.6.3.0-235.jar htrace-core-3.1.0-incubating.jar parquet-hadoop-bundle-1.8.1.jar
avatica-metrics-1.8.0.2.6.3.0-235.jar hive-accumulo-handler.jar httpclient-4.4.jar pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
avro-1.7.5.jar hive-ant-1.2.1000.2.6.3.0-235.jar httpcore-4.4.jar php
bonecp-0.8.0.RELEASE.jar hive-ant.jar ivy-2.4.0.jar plexus-utils-1.5.6.jar
calcite-core-1.2.0.2.6.3.0-235.jar hive-beeline-1.2.1000.2.6.3.0-235.jar jackson-annotations-2.4.0.jar protobuf-java-2.5.0.jar
calcite-linq4j-1.2.0.2.6.3.0-235.jar hive-beeline.jar jackson-core-2.4.2.jar py
commons-cli-1.2.jar hive-cli-1.2.1000.2.6.3.0-235.jar jackson-databind-2.4.2.jar ranger-hive-plugin-impl
commons-codec-1.4.jar hive-cli.jar janino-2.7.6.jar ranger-hive-plugin-shim-0.7.0.2.6.3.0-235.jar
commons-collections-3.2.2.jar hive-common-1.2.1000.2.6.3.0-235.jar javax.jdo-3.2.0-m3.jar ranger-plugin-classloader-0.7.0.2.6.3.0-235.jar
commons-compiler-2.7.6.jar hive-common.jar jcommander-1.32.jar regexp-1.3.jar
commons-compress-1.4.1.jar hive-contrib-1.2.1000.2.6.3.0-235.jar jdo-api-3.0.1.jar servlet-api-2.5.jar
commons-dbcp-1.4.jar hive-contrib.jar jetty-all-7.6.0.v20120127.jar snappy-java-1.0.5.jar
commons-httpclient-3.0.1.jar hive-exec-1.2.1000.2.6.3.0-235.jar jetty-all-server-7.6.0.v20120127.jar ST4-4.0.4.jar
commons-io-2.4.jar hive-exec.jar jline-2.12.jar stax-api-1.0.1.jar
commons-lang-2.6.jar hive-hbase-handler-1.2.1000.2.6.3.0-235.jar joda-time-2.8.1.jar stringtemplate-3.2.1.jar
commons-logging-1.1.3.jar hive-hbase-handler.jar jpam-1.1.jar super-csv-2.2.0.jar
commons-math-2.1.jar hive-hwi-1.2.1000.2.6.3.0-235.jar json-20090211.jar transaction-api-1.1.jar
commons-pool-1.5.4.jar hive-hwi.jar jsr305-3.0.0.jar velocity-1.5.jar
commons-vfs2-2.0.jar hive-jdbc-1.2.1000.2.6.3.0-235.jar jta-1.1.jar xz-1.0.jar
curator-client-2.6.0.jar hive-jdbc.jar libfb303-0.9.3.jar zookeeper-3.4.6.2.6.3.0-235.jar
curator-framework-2.6.0.jar hive-metastore-1.2.1000.2.6.3.0-235.jar libthrift-0.9.3.jar
[root@master lib]# hive
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
Logging initialized using configuration in file:/etc/hive/2.6.3.0-235/0/hive-log4j.properties
hive>
>
>
>
>
> create database test66;
OK
Time taken: 2.377 seconds
hive> quit;
[root@master lib]# dfs dfs -ls /
-bash: dfs: command not found
[root@master lib]# hdfs dfs -ls /
Found 15 items
drwxrwxrwx - yarn hadoop 0 2024-07-18 15:07 /app-logs
drwxr-xr-x - hdfs hdfs 0 2024-07-04 21:06 /apps
drwxr-xr-x - yarn hadoop 0 2024-07-04 19:12 /ats
drwxr-xr-x - hdfs hdfs 0 2024-07-17 17:49 /byjava
drwxr-xr-x - hdfs hdfs 0 2024-07-17 19:45 /byjava2
drwxr-xr-x - hdfs hdfs 0 2024-07-16 13:51 /hdfsdir
drwxr-xr-x - hdfs hdfs 0 2024-07-04 19:12 /hdp
-rw-r--r-- 3 hdfs hdfs 21 2024-07-17 19:41 /hhh.txt
drwxr-xr-x - mapred hdfs 0 2024-07-04 19:12 /mapred
drwxrwxrwx - mapred hadoop 0 2024-07-04 19:13 /mr-history
drwxrwxrwx - spark hadoop 0 2024-07-06 17:00 /spark-history
drwxrwxrwx - spark hadoop 0 2024-07-06 17:01 /spark2-history
drwxrwxrwx - hdfs hdfs 0 2024-07-04 19:15 /tmp
drwxrwxrwx - hdfs hdfs 0 2024-07-18 15:07 /user
drwxr-xr-x - hdfs hdfs 0 2024-07-04 19:13 /webhdfs
[root@master lib]# hdfs dfs -ls /user
Found 6 items
drwxrwx--- - ambari-qa hdfs 0 2024-07-04 19:12 /user/ambari-qa
drwxr-xr-x - hbase hdfs 0 2024-07-04 19:12 /user/hbase
drwxr-xr-x - hcat hdfs 0 2024-07-04 21:06 /user/hcat
drwxr-xr-x - hive hdfs 0 2024-07-04 21:06 /user/hive
drwxr-xr-x - root hdfs 0 2024-07-18 15:07 /user/root
drwxrwxr-x - spark hdfs 0 2024-07-04 19:12 /user/spark
[root@master lib]# hdfs dfs -ls /user/hive
[root@master lib]# clear
[root@master lib]# ls
accumulo-core-1.7.0.2.6.3.0-235.jar curator-recipes-2.6.0.jar hive-metastore.jar log4j-1.2.16.jar
accumulo-fate-1.7.0.2.6.3.0-235.jar datanucleus-api-jdo-4.2.1.jar hive-serde-1.2.1000.2.6.3.0-235.jar mail-1.4.1.jar
accumulo-start-1.7.0.2.6.3.0-235.jar datanucleus-core-4.1.6.jar hive-serde.jar maven-scm-api-1.4.jar
accumulo-trace-1.7.0.2.6.3.0-235.jar datanucleus-rdbms-4.1.7.jar hive-service-1.2.1000.2.6.3.0-235.jar maven-scm-provider-svn-commons-1.4.jar
activation-1.1.jar derby-10.10.2.0.jar hive-service.jar maven-scm-provider-svnexe-1.4.jar
ant-1.9.1.jar dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar hive-shims-0.20S-1.2.1000.2.6.3.0-235.jar metrics-core-3.1.0.jar
ant-launcher-1.9.1.jar eigenbase-properties-1.1.5.jar hive-shims-0.23-1.2.1000.2.6.3.0-235.jar metrics-json-3.1.0.jar
antlr-2.7.7.jar geronimo-annotation_1.0_spec-1.1.1.jar hive-shims-1.2.1000.2.6.3.0-235.jar metrics-jvm-3.1.0.jar
antlr-runtime-3.4.jar geronimo-jaspic_1.0_spec-1.0.jar hive-shims-common-1.2.1000.2.6.3.0-235.jar netty-3.7.0.Final.jar
apache-curator-2.6.0.pom geronimo-jta_1.1_spec-1.1.1.jar hive-shims-common.jar ojdbc6.jar
apache-log4j-extras-1.2.17.jar groovy-all-2.4.11.jar hive-shims.jar opencsv-2.3.jar
asm-commons-3.1.jar guava-14.0.1.jar hive-shims-scheduler-1.2.1000.2.6.3.0-235.jar oro-2.0.8.jar
asm-tree-3.1.jar HikariCP-2.5.1.jar hive-shims-scheduler.jar paranamer-2.3.jar
avatica-1.8.0.2.6.3.0-235.jar hive-accumulo-handler-1.2.1000.2.6.3.0-235.jar htrace-core-3.1.0-incubating.jar parquet-hadoop-bundle-1.8.1.jar
avatica-metrics-1.8.0.2.6.3.0-235.jar hive-accumulo-handler.jar httpclient-4.4.jar pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
avro-1.7.5.jar hive-ant-1.2.1000.2.6.3.0-235.jar httpcore-4.4.jar php
bonecp-0.8.0.RELEASE.jar hive-ant.jar ivy-2.4.0.jar plexus-utils-1.5.6.jar
calcite-core-1.2.0.2.6.3.0-235.jar hive-beeline-1.2.1000.2.6.3.0-235.jar jackson-annotations-2.4.0.jar protobuf-java-2.5.0.jar
calcite-linq4j-1.2.0.2.6.3.0-235.jar hive-beeline.jar jackson-core-2.4.2.jar py
commons-cli-1.2.jar hive-cli-1.2.1000.2.6.3.0-235.jar jackson-databind-2.4.2.jar ranger-hive-plugin-impl
commons-codec-1.4.jar hive-cli.jar janino-2.7.6.jar ranger-hive-plugin-shim-0.7.0.2.6.3.0-235.jar
commons-collections-3.2.2.jar hive-common-1.2.1000.2.6.3.0-235.jar javax.jdo-3.2.0-m3.jar ranger-plugin-classloader-0.7.0.2.6.3.0-235.jar
commons-compiler-2.7.6.jar hive-common.jar jcommander-1.32.jar regexp-1.3.jar
commons-compress-1.4.1.jar hive-contrib-1.2.1000.2.6.3.0-235.jar jdo-api-3.0.1.jar servlet-api-2.5.jar
commons-dbcp-1.4.jar hive-contrib.jar jetty-all-7.6.0.v20120127.jar snappy-java-1.0.5.jar
commons-httpclient-3.0.1.jar hive-exec-1.2.1000.2.6.3.0-235.jar jetty-all-server-7.6.0.v20120127.jar ST4-4.0.4.jar
commons-io-2.4.jar hive-exec.jar jline-2.12.jar stax-api-1.0.1.jar
commons-lang-2.6.jar hive-hbase-handler-1.2.1000.2.6.3.0-235.jar joda-time-2.8.1.jar stringtemplate-3.2.1.jar
commons-logging-1.1.3.jar hive-hbase-handler.jar jpam-1.1.jar super-csv-2.2.0.jar
commons-math-2.1.jar hive-hwi-1.2.1000.2.6.3.0-235.jar json-20090211.jar transaction-api-1.1.jar
commons-pool-1.5.4.jar hive-hwi.jar jsr305-3.0.0.jar velocity-1.5.jar
commons-vfs2-2.0.jar hive-jdbc-1.2.1000.2.6.3.0-235.jar jta-1.1.jar xz-1.0.jar
curator-client-2.6.0.jar hive-jdbc.jar libfb303-0.9.3.jar zookeeper-3.4.6.2.6.3.0-235.jar
curator-framework-2.6.0.jar hive-metastore-1.2.1000.2.6.3.0-235.jar libthrift-0.9.3.jar
[root@master lib]#
[root@master lib]# ll
total 90412
-rw-r--r-- 1 root root 4922276 Oct 30 2017 accumulo-core-1.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 112774 Oct 30 2017 accumulo-fate-1.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 64205 Oct 30 2017 accumulo-start-1.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 16672 Oct 30 2017 accumulo-trace-1.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 62983 Oct 22 2016 activation-1.1.jar
-rw-r--r-- 1 root root 1997485 Oct 22 2016 ant-1.9.1.jar
-rw-r--r-- 1 root root 18336 Oct 22 2016 ant-launcher-1.9.1.jar
-rw-r--r-- 1 root root 445288 Oct 22 2016 antlr-2.7.7.jar
-rw-r--r-- 1 root root 164368 Oct 22 2016 antlr-runtime-3.4.jar
-rw-r--r-- 1 root root 30359 Oct 22 2016 apache-curator-2.6.0.pom
-rw-r--r-- 1 root root 448794 Oct 22 2016 apache-log4j-extras-1.2.17.jar
-rw-r--r-- 1 root root 32693 Oct 22 2016 asm-commons-3.1.jar
-rw-r--r-- 1 root root 21879 Oct 22 2016 asm-tree-3.1.jar
-rw-r--r-- 1 root root 5675437 Oct 30 2017 avatica-1.8.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 20123 Oct 30 2017 avatica-metrics-1.8.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 400680 Oct 22 2016 avro-1.7.5.jar
-rw-r--r-- 1 root root 110600 Oct 22 2016 bonecp-0.8.0.RELEASE.jar
-rw-r--r-- 1 root root 3547280 Oct 30 2017 calcite-core-1.2.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 445897 Oct 30 2017 calcite-linq4j-1.2.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 41123 Oct 22 2016 commons-cli-1.2.jar
-rw-r--r-- 1 root root 58160 Oct 22 2016 commons-codec-1.4.jar
-rw-r--r-- 1 root root 588337 Oct 22 2016 commons-collections-3.2.2.jar
-rw-r--r-- 1 root root 30595 Oct 22 2016 commons-compiler-2.7.6.jar
-rw-r--r-- 1 root root 241367 Oct 22 2016 commons-compress-1.4.1.jar
-rw-r--r-- 1 root root 160519 Oct 22 2016 commons-dbcp-1.4.jar
-rw-r--r-- 1 root root 279781 Oct 22 2016 commons-httpclient-3.0.1.jar
-rw-r--r-- 1 root root 185140 Oct 22 2016 commons-io-2.4.jar
-rw-r--r-- 1 root root 284220 Oct 22 2016 commons-lang-2.6.jar
-rw-r--r-- 1 root root 62050 Oct 22 2016 commons-logging-1.1.3.jar
-rw-r--r-- 1 root root 832410 Oct 22 2016 commons-math-2.1.jar
-rw-r--r-- 1 root root 96221 Oct 22 2016 commons-pool-1.5.4.jar
-rw-r--r-- 1 root root 415578 Oct 22 2016 commons-vfs2-2.0.jar
-rw-r--r-- 1 root root 68866 Oct 22 2016 curator-client-2.6.0.jar
-rw-r--r-- 1 root root 185245 Oct 22 2016 curator-framework-2.6.0.jar
-rw-r--r-- 1 root root 248171 Oct 22 2016 curator-recipes-2.6.0.jar
-rw-r--r-- 1 root root 366565 Oct 22 2016 datanucleus-api-jdo-4.2.1.jar
-rw-r--r-- 1 root root 2009163 Oct 22 2016 datanucleus-core-4.1.6.jar
-rw-r--r-- 1 root root 1888550 Oct 22 2016 datanucleus-rdbms-4.1.7.jar
-rw-r--r-- 1 root root 2838580 Oct 22 2016 derby-10.10.2.0.jar
-rw-r--r-- 1 root root 15935 Oct 22 2016 dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar
-rw-r--r-- 1 root root 18482 Oct 22 2016 eigenbase-properties-1.1.5.jar
-rw-r--r-- 1 root root 12452 Oct 22 2016 geronimo-annotation_1.0_spec-1.1.1.jar
-rw-r--r-- 1 root root 30548 Oct 22 2016 geronimo-jaspic_1.0_spec-1.0.jar
-rw-r--r-- 1 root root 16030 Oct 22 2016 geronimo-jta_1.1_spec-1.1.1.jar
-rw-r--r-- 1 root root 7031748 Oct 10 2017 groovy-all-2.4.11.jar
-rw-r--r-- 1 root root 2189117 Oct 22 2016 guava-14.0.1.jar
-rw-r--r-- 1 root root 136363 Oct 10 2017 HikariCP-2.5.1.jar
-rw-r--r-- 1 root root 120681 Oct 30 2017 hive-accumulo-handler-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 46 Jul 4 18:49 hive-accumulo-handler.jar -> hive-accumulo-handler-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 49751 Oct 30 2017 hive-ant-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 33 Jul 4 18:49 hive-ant.jar -> hive-ant-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 149069 Oct 30 2017 hive-beeline-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 37 Jul 4 18:49 hive-beeline.jar -> hive-beeline-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 40137 Oct 30 2017 hive-cli-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 33 Jul 4 18:49 hive-cli.jar -> hive-cli-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 360285 Oct 30 2017 hive-common-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 36 Jul 4 18:49 hive-common.jar -> hive-common-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 122355 Oct 30 2017 hive-contrib-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 37 Jul 4 18:49 hive-contrib.jar -> hive-contrib-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 22104625 Oct 30 2017 hive-exec-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 34 Jul 4 18:49 hive-exec.jar -> hive-exec-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 119699 Oct 30 2017 hive-hbase-handler-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 43 Jul 4 18:49 hive-hbase-handler.jar -> hive-hbase-handler-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 29118 Oct 30 2017 hive-hwi-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 33 Jul 4 18:49 hive-hwi.jar -> hive-hwi-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 113421 Oct 30 2017 hive-jdbc-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 34 Jul 4 18:49 hive-jdbc.jar -> hive-jdbc-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 6337550 Oct 30 2017 hive-metastore-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 39 Jul 4 18:49 hive-metastore.jar -> hive-metastore-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 926307 Oct 30 2017 hive-serde-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 35 Jul 4 18:49 hive-serde.jar -> hive-serde-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 2049135 Oct 30 2017 hive-service-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 37 Jul 4 18:49 hive-service.jar -> hive-service-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 34301 Oct 30 2017 hive-shims-0.20S-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 65700 Oct 30 2017 hive-shims-0.23-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 10462 Oct 30 2017 hive-shims-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 114543 Oct 30 2017 hive-shims-common-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 42 Jul 4 18:49 hive-shims-common.jar -> hive-shims-common-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 41 Jul 4 18:49 hive-shims.jar -> hive-shims-0.20S-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 13615 Oct 30 2017 hive-shims-scheduler-1.2.1000.2.6.3.0-235.jar
lrwxrwxrwx 1 root root 45 Jul 4 18:49 hive-shims-scheduler.jar -> hive-shims-scheduler-1.2.1000.2.6.3.0-235.jar
-rw-r--r-- 1 root root 1475955 Oct 22 2016 htrace-core-3.1.0-incubating.jar
-rw-r--r-- 1 root root 719304 Oct 22 2016 httpclient-4.4.jar
-rw-r--r-- 1 root root 321639 Oct 22 2016 httpcore-4.4.jar
-rw-r--r-- 1 root root 1282424 Oct 22 2016 ivy-2.4.0.jar
-rw-r--r-- 1 root root 38605 Oct 22 2016 jackson-annotations-2.4.0.jar
-rw-r--r-- 1 root root 225316 Oct 22 2016 jackson-core-2.4.2.jar
-rw-r--r-- 1 root root 1075759 Oct 22 2016 jackson-databind-2.4.2.jar
-rw-r--r-- 1 root root 611863 Oct 22 2016 janino-2.7.6.jar
-rw-r--r-- 1 root root 249790 Oct 22 2016 javax.jdo-3.2.0-m3.jar
-rw-r--r-- 1 root root 60527 Oct 22 2016 jcommander-1.32.jar
-rw-r--r-- 1 root root 201124 Oct 22 2016 jdo-api-3.0.1.jar
-rw-r--r-- 1 root root 1681148 Oct 22 2016 jetty-all-7.6.0.v20120127.jar
-rw-r--r-- 1 root root 1683027 Oct 22 2016 jetty-all-server-7.6.0.v20120127.jar
-rw-r--r-- 1 root root 213854 Oct 22 2016 jline-2.12.jar
-rw-r--r-- 1 root root 621931 Oct 22 2016 joda-time-2.8.1.jar
-rw-r--r-- 1 root root 12131 Oct 22 2016 jpam-1.1.jar
-rw-r--r-- 1 root root 45944 Oct 22 2016 json-20090211.jar
-rw-r--r-- 1 root root 33031 Oct 22 2016 jsr305-3.0.0.jar
-rw-r--r-- 1 root root 15071 Oct 22 2016 jta-1.1.jar
-rw-r--r-- 1 root root 313702 Oct 22 2016 libfb303-0.9.3.jar
-rw-r--r-- 1 root root 234201 Oct 22 2016 libthrift-0.9.3.jar
-rw-r--r-- 1 root root 481535 Oct 22 2016 log4j-1.2.16.jar
-rw-r--r-- 1 root root 447676 Oct 22 2016 mail-1.4.1.jar
-rw-r--r-- 1 root root 94421 Oct 22 2016 maven-scm-api-1.4.jar
-rw-r--r-- 1 root root 40066 Oct 22 2016 maven-scm-provider-svn-commons-1.4.jar
-rw-r--r-- 1 root root 69858 Oct 22 2016 maven-scm-provider-svnexe-1.4.jar
-rw-r--r-- 1 root root 111908 Oct 22 2016 metrics-core-3.1.0.jar
-rw-r--r-- 1 root root 15823 Oct 22 2016 metrics-json-3.1.0.jar
-rw-r--r-- 1 root root 35907 Oct 22 2016 metrics-jvm-3.1.0.jar
-rw-r--r-- 1 root root 1208356 Oct 22 2016 netty-3.7.0.Final.jar
lrwxrwxrwx 1 root root 26 Jul 4 18:48 ojdbc6.jar -> /usr/share/java/ojdbc6.jar
-rw-r--r-- 1 root root 19827 Oct 22 2016 opencsv-2.3.jar
-rw-r--r-- 1 root root 65261 Oct 22 2016 oro-2.0.8.jar
-rw-r--r-- 1 root root 29555 Oct 22 2016 paranamer-2.3.jar
-rw-r--r-- 1 root root 2902379 Oct 22 2016 parquet-hadoop-bundle-1.8.1.jar
-rw-r--r-- 1 root root 48557 Oct 22 2016 pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
drwxr-xr-x 5 root root 93 Jul 4 18:49 php
-rw-r--r-- 1 root root 250546 Oct 22 2016 plexus-utils-1.5.6.jar
-rw-r--r-- 1 root root 533455 Oct 22 2016 protobuf-java-2.5.0.jar
drwxr-xr-x 10 root root 150 Jul 4 18:49 py
drwxr-xr-x 2 root root 4096 Jul 4 18:48 ranger-hive-plugin-impl
-rw-r--r-- 1 root root 18491 Oct 30 2017 ranger-hive-plugin-shim-0.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 16851 Oct 30 2017 ranger-plugin-classloader-0.7.0.2.6.3.0-235.jar
-rw-r--r-- 1 root root 25429 Oct 22 2016 regexp-1.3.jar
-rw-r--r-- 1 root root 105112 Oct 22 2016 servlet-api-2.5.jar
-rw-r--r-- 1 root root 1251514 Oct 22 2016 snappy-java-1.0.5.jar
-rw-r--r-- 1 root root 236660 Oct 22 2016 ST4-4.0.4.jar
-rw-r--r-- 1 root root 26514 Oct 22 2016 stax-api-1.0.1.jar
-rw-r--r-- 1 root root 148627 Oct 22 2016 stringtemplate-3.2.1.jar
-rw-r--r-- 1 root root 93210 Oct 22 2016 super-csv-2.2.0.jar
-rw-r--r-- 1 root root 15071 Oct 22 2016 transaction-api-1.1.jar
-rw-r--r-- 1 root root 392124 Oct 22 2016 velocity-1.5.jar
-rw-r--r-- 1 root root 94672 Oct 22 2016 xz-1.0.jar
-rw-r--r-- 1 root root 800584 Oct 30 2017 zookeeper-3.4.6.2.6.3.0-235.jar
[root@master lib]# pwd
/usr/hdp/2.6.3.0-235/hive/lib
[root@master lib]# cd ..
[root@master hive]# ll
total 103996
drwxr-xr-x 3 root root 222 Jul 4 18:49 bin
lrwxrwxrwx 1 root root 23 Jul 4 18:49 conf -> /etc/hive/2.6.3.0-235/0
drwxr-xr-x 3 root root 94 Jul 4 18:48 doc
-rw-r--r-- 1 root root 106476102 Oct 30 2017 hive.tar.gz
drwxr-xr-x 2 root root 59 Jul 4 18:48 jdbc
drwxr-xr-x 5 root root 8192 Jul 4 18:49 lib
drwxr-xr-x 3 root root 27 Jul 4 18:49 log
drwxr-xr-x 2 root root 49 Jul 4 18:49 man
drwxrwxrwt 2 hive hive 6 Oct 30 2017 metastore
drwxr-xr-x 3 root root 23 Jul 4 18:49 scripts
[root@master hive]# cd jdbc/
[root@master jdbc]# ll
total 19708
-rw-r--r-- 1 root root 20178247 Oct 30 2017 hive-jdbc-1.2.1000.2.6.3.0-235-standalone.jar
[root@master jdbc]# 郁闷
-bash: 郁闷: command not found
[root@master jdbc]# sz hive-jdbc-1.2.1000.2.6.3.0-235-standalone.jar
[root@master jdbc]#
Xshell 7 (Build 0164)
Copyright (c) 2020 NetSarang Computer, Inc. All rights reserved.
Type `help' to learn how to use Xshell prompt.
[C:\~]$
Host 'master' resolved to 192.168.70.143.
Connecting to 192.168.70.143:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Your current local directory is
C:\Users\dell\Documents\NetSarang Computer\7\Xshell\Sessions
Type `help' to browse available commnands.
sftp:/usr/hdp/2.6.3.0-235/hive/jdbc>