运行hive --service metastore命令报错，如何解决

Question

运行hive --service metastore命令报错，如何解决

Answer 1

"Starting Hive Metastore Server"
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/D:/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/D:/apache-hive-2.1.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
18/09/13 13:46:29 INFO conf.HiveConf: Found configuration file file:/D:/apache-hive-2.1.1-bin/conf/hive-site.xml
2018-09-13 13:46:37,889 main WARN Unable to instantiate org.fusesource.jansi.WindowsAnsiOutputStream
2018-09-13 13:46:37,897 main WARN Unable to instantiate org.fusesource.jansi.WindowsAnsiOutputStream
18/09/13 13:46:38 INFO metastore.HiveMetaStore: STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting HiveMetaStore
STARTUP_MSG: host = boc-PC/10.223.2.30
STARTUP_MSG: args = []
STARTUP_MSG: version = 2.1.1
STARTUP_MSG: classpath = D:\hadoop-2.7.2\etc\hadoop;D:\hadoop-2.7.2\share\hadoop\common\lib\activation-1.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\apacheds-i18n-2.0.0-M15.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\apacheds-kerberos-codec-2.0.0-M15.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\api-asn1-api-1.0.0-M20.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\api-util-1.0.0-M20.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\asm-3.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\avro-1.7.4.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-beanutils-1.7.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-beanutils-core-1.8.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-cli-1.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-codec-1.4.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-collections-3.2.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-compress-1.4.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-configuration-1.6.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-digester-1.8.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-httpclient-3.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-io-2.4.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-lang-2.6.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-logging-1.1.3.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-math3-3.1.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\commons-net-3.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\curator-client-2.7.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\curator-framework-2.7.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\curator-recipes-2.7.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\gson-2.2.4.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\guava-11.0.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\hadoop-annotations-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\hadoop-auth-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\hamcrest-core-1.3.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\htrace-core-3.1.0-incubating.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\httpclient-4.2.5.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\httpcore-4.2.5.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jackson-core-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jackson-jaxrs-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jackson-mapper-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jackson-xc-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\java-xmlbuilder-0.4.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jaxb-api-2.2.2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jaxb-impl-2.2.3-1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jersey-core-1.9.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jersey-json-1.9.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jersey-server-1.9.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jets3t-0.9.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jettison-1.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jetty-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jetty-util-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jsch-0.1.42.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jsp-api-2.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\jsr305-3.0.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\junit-4.11.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\log4j-1.2.17.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\mockito-all-1.8.5.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\netty-3.6.2.Final.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\paranamer-2.3.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\protobuf-java-2.5.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\servlet-api-2.5.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\slf4j-api-1.7.10.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\slf4j-log4j12-1.7.10.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\snappy-java-1.0.4.1.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\stax-api-1.0-2.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\xmlenc-0.52.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\xz-1.0.jar;D:\hadoop-2.7.2\share\hadoop\common\lib\zookeeper-3.4.6.jar;D:\hadoop-2.7.2\share\hadoop\common\hadoop-common-2.7.2-tests.jar;D:\hadoop-2.7.2\share\hadoop\common\hadoop-common-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\common\hadoop-nfs-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\hdfs;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\asm-3.2.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-cli-1.2.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-codec-1.4.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-daemon-1.0.13.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-io-2.4.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-lang-2.6.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\commons-logging-1.1.3.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\guava-11.0.2.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\htrace-core-3.1.0-incubating.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jackson-core-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jackson-mapper-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jersey-core-1.9.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jersey-server-1.9.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jetty-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jetty-util-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\jsr305-3.0.0.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\leveldbjni-all-1.8.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\log4j-1.2.17.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\netty-3.6.2.Final.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\netty-all-4.0.23.Final.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\protobuf-java-2.5.0.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\servlet-api-2.5.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\xercesImpl-2.9.1.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\xml-apis-1.3.04.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\lib\xmlenc-0.52.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\hadoop-hdfs-2.7.2-tests.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\hadoop-hdfs-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\hdfs\hadoop-hdfs-nfs-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\activation-1.1.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\aopalliance-1.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\asm-3.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-cli-1.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-codec-1.4.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-collections-3.2.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-compress-1.4.1.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-io-2.4.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-lang-2.6.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\commons-logging-1.1.3.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\guava-11.0.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\guice-3.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\guice-servlet-3.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jackson-core-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jackson-jaxrs-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jackson-mapper-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jackson-xc-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\javax.inject-1.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jaxb-api-2.2.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jaxb-impl-2.2.3-1.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jersey-client-1.9.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jersey-core-1.9.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jersey-guice-1.9.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jersey-json-1.9.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jersey-server-1.9.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jettison-1.1.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jetty-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jetty-util-6.1.26.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\jsr305-3.0.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\leveldbjni-all-1.8.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\log4j-1.2.17.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\netty-3.6.2.Final.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\protobuf-java-2.5.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\servlet-api-2.5.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\stax-api-1.0-2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\xz-1.0.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\zookeeper-3.4.6-tests.jar;D:\hadoop-2.7.2\share\hadoop\yarn\lib\zookeeper-3.4.6.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-api-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-applications-distributedshell-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-applications-unmanaged-am-launcher-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-client-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-common-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-registry-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-applicationhistoryservice-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-common-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-nodemanager-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-resourcemanager-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-sharedcachemanager-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-tests-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\yarn\hadoop-yarn-server-web-proxy-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\aopalliance-1.0.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\asm-3.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\avro-1.7.4.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\commons-compress-1.4.1.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\commons-io-2.4.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\guice-3.0.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\guice-servlet-3.0.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\hadoop-annotations-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\hamcrest-core-1.3.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\jackson-core-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\jackson-mapper-asl-1.9.13.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\javax.inject-1.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\jersey-core-1.9.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\jersey-guice-1.9.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\jersey-server-1.9.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\junit-4.11.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\leveldbjni-all-1.8.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\log4j-1.2.17.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\netty-3.6.2.Final.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\paranamer-2.3.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\protobuf-java-2.5.0.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\snappy-java-1.0.4.1.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\lib\xz-1.0.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-app-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-common-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-core-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-hs-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-hs-plugins-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.2-tests.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-client-shuffle-2.7.2.jar;D:\hadoop-2.7.2\share\hadoop\mapreduce\hadoop-mapreduce-examples-2.7.2.jar;;D:\apache-hive-2.1.1-bin\conf;D:\apache-hive-2.1.1-bin\lib\accumulo-core-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\accumulo-fate-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\accumulo-start-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\accumulo-trace-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\activation-1.1.jar;D:\apache-hive-2.1.1-bin\lib\ant-1.6.5.jar;D:\apache-hive-2.1.1-bin\lib\ant-1.9.1.jar;D:\apache-hive-2.1.1-bin\lib\ant-launcher-1.9.1.jar;D:\apache-hive-2.1.1-bin\lib\antlr-2.7.7.jar;D:\apache-hive-2.1.1-bin\lib\antlr-runtime-3.4.jar;D:\apache-hive-2.1.1-bin\lib\antlr4-runtime-4.5.jar;D:\apache-hive-2.1.1-bin\lib\aopalliance-1.0.jar;D:\apache-hive-2.1.1-bin\lib\asm-3.1.jar;D:\apache-hive-2.1.1-bin\lib\asm-commons-3.1.jar;D:\apache-hive-2.1.1-bin\lib\asm-tree-3.1.jar;D:\apache-hive-2.1.1-bin\lib\avro-1.7.7.jar;D:\apache-hive-2.1.1-bin\lib\bonecp-0.8.0.RELEASE.jar;D:\apache-hive-2.1.1-bin\lib\calcite-avatica-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\calcite-core-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\calcite-linq4j-1.6.0.jar;D:\apache-hive-2.1.1-bin\lib\commons-cli-1.2.jar;D:\apache-hive-2.1.1-bin\lib\commons-codec-1.4.jar;D:\apache-hive-2.1.1-bin\lib\commons-collections-3.2.2.jar;D:\apache-hive-2.1.1-bin\lib\commons-compiler-2.7.6.jar;D:\apache-hive-2.1.1-bin\lib\commons-compress-1.9.jar;D:\apache-hive-2.1.1-bin\lib\commons-dbcp-1.4.jar;D:\apache-hive-2.1.1-bin\lib\commons-el-1.0.jar;D:\apache-hive-2.1.1-bin\lib\commons-httpclient-3.0.1.jar;D:\apache-hive-2.1.1-bin\lib\commons-io-2.4.jar;D:\apache-hive-2.1.1-bin\lib\commons-lang-2.6.jar;D:\apache-hive-2.1.1-bin\lib\commons-lang3-3.1.jar;D:\apache-hive-2.1.1-bin\lib\commons-logging-1.2.jar;D:\apache-hive-2.1.1-bin\lib\commons-math-2.2.jar;D:\apache-hive-2.1.1-bin\lib\commons-pool-1.5.4.jar;D:\apache-hive-2.1.1-bin\lib\commons-vfs2-2.0.jar;D:\apache-hive-2.1.1-bin\lib\curator-client-2.6.0.jar;D:\apache-hive-2.1.1-bin\lib\curator-framework-2.6.0.jar;D:\apache-hive-2.1.1-bin\lib\curator-recipes-2.6.0.jar;D:\apache-hive-2.1.1-bin\lib\datanucleus-api-jdo-4.2.1.jar;D:\apache-hive-2.1.1-bin\lib\datanucleus-core-4.1.6.jar;D:\apache-hive-2.1.1-bin\lib\datanucleus-rdbms-4.1.7.jar;D:\apache-hive-2.1.1-bin\lib\derby-10.10.2.0.jar;D:\apache-hive-2.1.1-bin\lib\disruptor-3.3.0.jar;D:\apache-hive-2.1.1-bin\lib\dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar;D:\apache-hive-2.1.1-bin\lib\eigenbase-properties-1.1.5.jar;D:\apache-hive-2.1.1-bin\lib\fastutil-6.5.6.jar;D:\apache-hive-2.1.1-bin\lib\findbugs-annotations-1.3.9-1.jar;D:\apache-hive-2.1.1-bin\lib\geronimo-annotation_1.0_spec-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\geronimo-jaspic_1.0_spec-1.0.jar;D:\apache-hive-2.1.1-bin\lib\geronimo-jta_1.1_spec-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\groovy-all-2.4.4.jar;D:\apache-hive-2.1.1-bin\lib\gson-2.2.4.jar;D:\apache-hive-2.1.1-bin\lib\guava-14.0.1.jar;D:\apache-hive-2.1.1-bin\lib\guice-3.0.jar;D:\apache-hive-2.1.1-bin\lib\guice-assistedinject-3.0.jar;D:\apache-hive-2.1.1-bin\lib\guice-servlet-3.0.jar;D:\apache-hive-2.1.1-bin\lib\hamcrest-core-1.3.jar;D:\apache-hive-2.1.1-bin\lib\hbase-annotations-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-client-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-common-1.1.1-tests.jar;D:\apache-hive-2.1.1-bin\lib\hbase-common-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-hadoop-compat-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-hadoop2-compat-1.1.1-tests.jar;D:\apache-hive-2.1.1-bin\lib\hbase-hadoop2-compat-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-prefix-tree-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-procedure-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-protocol-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hbase-server-1.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-accumulo-handler-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-ant-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-beeline-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-cli-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-common-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-contrib-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-exec-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-hbase-handler-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-hplsql-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-hwi-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-jdbc-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-llap-client-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-llap-common-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-llap-ext-client-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-llap-server-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-llap-tez-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-metastore-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-orc-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-serde-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-service-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-service-rpc-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-shims-0.23-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-shims-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-shims-common-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-shims-scheduler-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-storage-api-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\hive-testutils-2.1.1.jar;D:\apache-hive-2.1.1-bin\lib\htrace-core-3.1.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\httpclient-4.4.jar;D:\apache-hive-2.1.1-bin\lib\httpcore-4.4.jar;D:\apache-hive-2.1.1-bin\lib\ivy-2.4.0.jar;D:\apache-hive-2.1.1-bin\lib\jackson-annotations-2.4.0.jar;D:\apache-hive-2.1.1-bin\lib\jackson-core-2.4.2.jar;D:\apache-hive-2.1.1-bin\lib\jackson-databind-2.4.2.jar;D:\apache-hive-2.1.1-bin\lib\jackson-jaxrs-1.9.2.jar;D:\apache-hive-2.1.1-bin\lib\jackson-xc-1.9.2.jar;D:\apache-hive-2.1.1-bin\lib\jamon-runtime-2.3.1.jar;D:\apache-hive-2.1.1-bin\lib\janino-2.7.6.jar;D:\apache-hive-2.1.1-bin\lib\jasper-compiler-5.5.23.jar;D:\apache-hive-2.1.1-bin\lib\jasper-runtime-5.5.23.jar;D:\apache-hive-2.1.1-bin\lib\javax.inject-1.jar;D:\apache-hive-2.1.1-bin\lib\javax.jdo-3.2.0-m3.jar;D:\apache-hive-2.1.1-bin\lib\javax.servlet-3.0.0.v201112011016.jar;D:\apache-hive-2.1.1-bin\lib\javolution-5.5.1.jar;D:\apache-hive-2.1.1-bin\lib\jcodings-1.0.8.jar;D:\apache-hive-2.1.1-bin\lib\jcommander-1.32.jar;D:\apache-hive-2.1.1-bin\lib\jdo-api-3.0.1.jar;D:\apache-hive-2.1.1-bin\lib\jersey-client-1.9.jar;D:\apache-hive-2.1.1-bin\lib\jersey-server-1.14.jar;D:\apache-hive-2.1.1-bin\lib\jetty-6.1.26.jar;D:\apache-hive-2.1.1-bin\lib\jetty-all-7.6.0.v20120127.jar;D:\apache-hive-2.1.1-bin\lib\jetty-all-server-7.6.0.v20120127.jar;D:\apache-hive-2.1.1-bin\lib\jetty-sslengine-6.1.26.jar;D:\apache-hive-2.1.1-bin\lib\jetty-util-6.1.26.jar;D:\apache-hive-2.1.1-bin\lib\jline-2.12.jar;D:\apache-hive-2.1.1-bin\lib\joda-time-2.5.jar;D:\apache-hive-2.1.1-bin\lib\joni-2.1.2.jar;D:\apache-hive-2.1.1-bin\lib\jpam-1.1.jar;D:\apache-hive-2.1.1-bin\lib\json-20090211.jar;D:\apache-hive-2.1.1-bin\lib\jsp-2.1-6.1.14.jar;D:\apache-hive-2.1.1-bin\lib\jsp-api-2.0.jar;D:\apache-hive-2.1.1-bin\lib\jsp-api-2.1-6.1.14.jar;D:\apache-hive-2.1.1-bin\lib\jsp-api-2.1.jar;D:\apache-hive-2.1.1-bin\lib\jsr305-3.0.0.jar;D:\apache-hive-2.1.1-bin\lib\jta-1.1.jar;D:\apache-hive-2.1.1-bin\lib\junit-4.11.jar;D:\apache-hive-2.1.1-bin\lib\libfb303-0.9.3.jar;D:\apache-hive-2.1.1-bin\lib\libthrift-0.9.3.jar;D:\apache-hive-2.1.1-bin\lib\log4j-1.2-api-2.4.1.jar;D:\apache-hive-2.1.1-bin\lib\log4j-api-2.4.1.jar;D:\apache-hive-2.1.1-bin\lib\log4j-core-2.4.1.jar;D:\apache-hive-2.1.1-bin\lib\log4j-slf4j-impl-2.4.1.jar;D:\apache-hive-2.1.1-bin\lib\log4j-web-2.4.1.jar;D:\apache-hive-2.1.1-bin\lib\mail-1.4.1.jar;D:\apache-hive-2.1.1-bin\lib\maven-scm-api-1.4.jar;D:\apache-hive-2.1.1-bin\lib\maven-scm-provider-svn-commons-1.4.jar;D:\apache-hive-2.1.1-bin\lib\maven-scm-provider-svnexe-1.4.jar;D:\apache-hive-2.1.1-bin\lib\metrics-core-2.2.0.jar;D:\apache-hive-2.1.1-bin\lib\metrics-core-3.1.0.jar;D:\apache-hive-2.1.1-bin\lib\metrics-json-3.1.0.jar;D:\apache-hive-2.1.1-bin\lib\metrics-jvm-3.1.0.jar;D:\apache-hive-2.1.1-bin\lib\mysql-connector-java-5.1.25-bin.jar;D:\apache-hive-2.1.1-bin\lib\netty-3.7.0.Final.jar;D:\apache-hive-2.1.1-bin\lib\netty-all-4.0.23.Final.jar;D:\apache-hive-2.1.1-bin\lib\opencsv-2.3.jar;D:\apache-hive-2.1.1-bin\lib\org.abego.treelayout.core-1.0.1.jar;D:\apache-hive-2.1.1-bin\lib\paranamer-2.3.jar;D:\apache-hive-2.1.1-bin\lib\parquet-hadoop-bundle-1.8.1.jar;D:\apache-hive-2.1.1-bin\lib\pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar;D:\apache-hive-2.1.1-bin\lib\plexus-utils-1.5.6.jar;D:\apache-hive-2.1.1-bin\lib\protobuf-java-2.5.0.jar;D:\apache-hive-2.1.1-bin\lib\regexp-1.3.jar;D:\apache-hive-2.1.1-bin\lib\servlet-api-2.4.jar;D:\apache-hive-2.1.1-bin\lib\servlet-api-2.5-6.1.14.jar;D:\apache-hive-2.1.1-bin\lib\slider-core-0.90.2-incubating.jar;D:\apache-hive-2.1.1-bin\lib\snappy-0.2.jar;D:\apache-hive-2.1.1-bin\lib\snappy-java-1.0.5.jar;D:\apache-hive-2.1.1-bin\lib\ST4-4.0.4.jar;D:\apache-hive-2.1.1-bin\lib\stax-api-1.0.1.jar;D:\apache-hive-2.1.1-bin\lib\stringtemplate-3.2.1.jar;D:\apache-hive-2.1.1-bin\lib\super-csv-2.2.0.jar;D:\apache-hive-2.1.1-bin\lib\tempus-fugit-1.1.jar;D:\apache-hive-2.1.1-bin\lib\tephra-api-0.6.0.jar;D:\apache-hive-2.1.1-bin\lib\tephra-core-0.6.0.jar;D:\apache-hive-2.1.1-bin\lib\tephra-hbase-compat-1.0-0.6.0.jar;D:\apache-hive-2.1.1-bin\lib\transaction-api-1.1.jar;D:\apache-hive-2.1.1-bin\lib\twill-api-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\twill-common-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\twill-core-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\twill-discovery-api-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\twill-discovery-core-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\twill-zookeeper-0.6.0-incubating.jar;D:\apache-hive-2.1.1-bin\lib\velocity-1.5.jar;D:\apache-hive-2.1.1-bin\lib\zookeeper-3.4.6.jar;D:\apache-hive-2.1.1-bin\hcatalog\share\hcatalog\hive-hcatalog-core-2.1.1.jar;D:\apache-hive-2.1.1-bin\hcatalog\share\hcatalog\hive-hcatalog-pig-adapter-2.1.1.jar;D:\apache-hive-2.1.1-bin\hcatalog\share\hcatalog\hive-hcatalog-server-extensions-2.1.1.jar;D:\apache-hive-2.1.1-bin\hcatalog\share\hcatalog\hive-hcatalog-streaming-2.1.1.jar;;;
STARTUP_MSG: build = git://jcamachorodriguez-rMBP.local/Users/jcamachorodriguez/src/workspaces/hive/HIVE-release2/hive -r 1af77bbf8356e86cabbed92cfa8cc2e1470a1d5c; compiled by 'jcamachorodriguez' on Tue Nov 29 19:46:12 GMT 2016
************************************************************/
18/09/13 13:46:39 INFO metastore.HiveMetaStore: Starting hive metastore on port 9083
18/09/13 13:46:39 INFO metastore.HiveMetaStore: 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore
18/09/13 13:46:40 INFO metastore.ObjectStore: ObjectStore, initialize called
18/09/13 13:46:40 INFO DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored
18/09/13 13:46:40 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
18/09/13 13:46:43 ERROR Datastore.Schema: Failed initialising database.
Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true, username = hadoop. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2565)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
at com.jolbox.bonecp.BoneCP.(BoneCP.java:416)
at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:483)
at org.datanucleus.store.rdbms.RDBMSStoreManager.(RDBMSStoreManager.java:296)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.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.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 javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
at java.security.AccessController.doPrivileged(Native Method)
at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:515)
at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:544)
at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:399)
at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:336)
at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:297)
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.(RawStoreProxy.java:58)
at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:599)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:564)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:626)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6484)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6479)
at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6737)
at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6664)
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:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3276)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1940)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1866)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)
... 63 more