Windows 2008 R2
Firewall is off
Python 2.7 installed
Java 1.7_51 installed, path set and JAVA_HOME set
MS SQL 2012 installed
ODBC connection created and tested
hive_user created, password set, sysadmin rights assigned
hive_db created
Hadoop Hive
sqljdbc4 present in D:\HDP\hive-1.2.1000.2.4.2.0-258\lib
hive schematool -initSchema -dbtype mssql (fails)
hive-site.xml set to create on start up
javax.jdo.option.ConnectionURL
jdbc:sqlserver://hdp-hive:1433;database=hive_db;encrypt=true;trustServerCertificate=true;create=true
JDBC connect string for a JDBC metastore
2016-10-12 14:29:26,439 INFO server.HiveServer2 (HiveStringUtils.java:startupShutdownMessage(691)) - STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting HiveServer2
STARTUP_MSG: host = hdp-hive/192.168.51.103
STARTUP_MSG: args = [-hiveconf, hive.hadoop.classpath=D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\*;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\*, -hiveconf, hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory, -hiveconf, hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator, -hiveconf, hive.metastore.uris= , -hiveconf, hive.aux.jars.path=file:///D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-core-1.2.1000.2.4.2.0-258.jar,file:///D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-pig-adapter-1.2.1000.2.4.2.0-258.jar,file:///D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-server-extensions-1.2.1000.2.4.2.0-258.jar,file:///D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-streaming-1.2.1000.2.4.2.0-258.jar, -hiveconf, hive.querylog.location=D:\HADOOP\LOGS\hive\history, -hiveconf, hive.log.dir=D:\HADOOP\LOGS\hive]
STARTUP_MSG: version = 1.2.1000.2.4.2.0-258
STARTUP_MSG: classpath = D:\HDP\hadoop-2.7.1.2.4.2.0-258\etc\hadoop;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\activation-1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\apacheds-i18n-2.0.0-M15.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\apacheds-kerberos-codec-2.0.0-M15.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\api-asn1-api-1.0.0-M20.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\api-util-1.0.0-M20.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\asm-3.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\avro-1.7.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\aws-java-sdk-1.7.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\azure-storage-2.2.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-beanutils-1.7.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-beanutils-core-1.8.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-cli-1.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-codec-1.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-collections-3.2.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-compress-1.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-configuration-1.6.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-digester-1.8.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-httpclient-3.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-io-2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-lang-2.6.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-logging-1.1.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-math3-3.1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\commons-net-3.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\curator-client-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\curator-framework-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\curator-recipes-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\gson-2.2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\guava-11.0.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\hadoop-annotations-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\hadoop-auth-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\hadoop-distcp-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\hamcrest-core-1.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\htrace-core-3.1.0-incubating.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\httpclient-4.2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\httpcore-4.2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-annotations-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-core-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-core-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-databind-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-jaxrs-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-mapper-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jackson-xc-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\java-xmlbuilder-0.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jaxb-api-2.2.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jaxb-impl-2.2.3-1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jersey-core-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jersey-json-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jersey-server-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jets3t-0.9.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jettison-1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jetty-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jetty-util-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jsch-0.1.42.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jsp-api-2.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\jsr305-3.0.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\junit-4.11.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\log4j-1.2.17.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\microsoft-windowsazure-storage-sdk-0.6.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\mockito-all-1.8.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\netty-3.6.2.Final.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\paranamer-2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\protobuf-java-2.5.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\servlet-api-2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\slf4j-api-1.7.10.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\slf4j-log4j12-1.7.10.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\snappy-java-1.0.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\stax-api-1.0-2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\xmlenc-0.52.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\xz-1.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\lib\zookeeper-3.4.6.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\hadoop-aws-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\hadoop-azure-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\hadoop-common-2.7.1.2.4.2.0-258-tests.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\hadoop-common-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\common\hadoop-nfs-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\asm-3.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-cli-1.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-codec-1.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-daemon-1.0.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-io-2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-lang-2.6.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\commons-logging-1.1.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\guava-11.0.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\htrace-core-3.1.0-incubating.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jackson-core-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jackson-mapper-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jersey-core-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jersey-server-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jetty-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jetty-util-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\jsr305-3.0.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\leveldbjni-all-1.8.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\log4j-1.2.17.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\netty-3.6.2.Final.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\netty-all-4.0.23.Final.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\okhttp-2.4.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\okio-1.4.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\protobuf-java-2.5.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\servlet-api-2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\xercesImpl-2.9.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\xml-apis-1.3.04.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\lib\xmlenc-0.52.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\hadoop-hdfs-2.7.1.2.4.2.0-258-tests.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\hadoop-hdfs-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\hdfs\hadoop-hdfs-nfs-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\activation-1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\aopalliance-1.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\apacheds-i18n-2.0.0-M15.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\apacheds-kerberos-codec-2.0.0-M15.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\api-asn1-api-1.0.0-M20.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\api-util-1.0.0-M20.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\asm-3.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\avro-1.7.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-beanutils-1.7.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-beanutils-core-1.8.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-cli-1.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-codec-1.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-collections-3.2.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-compress-1.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-configuration-1.6.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-digester-1.8.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-httpclient-3.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-io-2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-lang-2.6.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-logging-1.1.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-math3-3.1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\commons-net-3.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\curator-client-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\curator-framework-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\curator-recipes-2.7.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\fst-2.24.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\gson-2.2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\guava-11.0.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\guice-3.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\guice-servlet-3.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\htrace-core-3.1.0-incubating.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\httpclient-4.2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\httpcore-4.2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-annotations-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-core-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-core-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-databind-2.2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-jaxrs-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-mapper-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jackson-xc-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\java-xmlbuilder-0.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\javassist-3.18.1-GA.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\javax.inject-1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jaxb-api-2.2.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jaxb-impl-2.2.3-1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jersey-client-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jersey-core-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jersey-guice-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jersey-json-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jersey-server-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jets3t-0.9.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jettison-1.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jetty-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jetty-util-6.1.26.hwx.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jsch-0.1.42.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jsp-api-2.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\jsr305-3.0.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\leveldbjni-all-1.8.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\log4j-1.2.17.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\microsoft-windowsazure-storage-sdk-0.6.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\netty-3.6.2.Final.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\objenesis-2.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\paranamer-2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\protobuf-java-2.5.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\servlet-api-2.5.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\snappy-java-1.0.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\stax-api-1.0-2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\xmlenc-0.52.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\xz-1.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\zookeeper-3.4.6.2.4.2.0-258-tests.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\lib\zookeeper-3.4.6.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-api-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-applications-distributedshell-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-applications-unmanaged-am-launcher-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-client-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-common-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-registry-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-applicationhistoryservice-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-common-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-nodemanager-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-resourcemanager-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-sharedcachemanager-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-tests-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-timeline-plugins-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\yarn\hadoop-yarn-server-web-proxy-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\aopalliance-1.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\asm-3.2.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\avro-1.7.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\commons-compress-1.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\commons-io-2.4.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\guice-3.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\guice-servlet-3.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\hadoop-annotations-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\hamcrest-core-1.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\jackson-core-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\jackson-mapper-asl-1.9.13.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\javax.inject-1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\jersey-core-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\jersey-guice-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\jersey-server-1.9.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\junit-4.11.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\leveldbjni-all-1.8.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\log4j-1.2.17.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\netty-3.6.2.Final.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\paranamer-2.3.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\protobuf-java-2.5.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\snappy-java-1.0.4.1.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\lib\xz-1.0.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-app-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-common-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-core-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-hs-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-hs-plugins-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.1.2.4.2.0-258-tests.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-client-shuffle-2.7.1.2.4.2.0-258.jar;D:\HDP\hadoop-2.7.1.2.4.2.0-258\share\hadoop\mapreduce\hadoop-mapreduce-examples-2.7.1.2.4.2.0-258.jar;;D:\HDP\hive-1.2.1000.2.4.2.0-258\conf;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\accumulo-core-1.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\accumulo-fate-1.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\accumulo-start-1.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\accumulo-trace-1.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\activation-1.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\ant-1.9.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\ant-launcher-1.9.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\antlr-2.7.7.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\antlr-runtime-3.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\apache-log4j-extras-1.2.17.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\asm-commons-3.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\asm-tree-3.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\avro-1.7.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\bonecp-0.8.0.RELEASE.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\calcite-avatica-1.2.0.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\calcite-core-1.2.0.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\calcite-linq4j-1.2.0.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-cli-1.2.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-codec-1.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-collections-3.2.2.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-compiler-2.7.6.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-compress-1.4.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-dbcp-1.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-httpclient-3.0.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-io-2.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-lang-2.6.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-logging-1.1.3.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-math-2.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-pool-1.5.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\commons-vfs2-2.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\curator-client-2.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\curator-framework-2.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\curator-recipes-2.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\datanucleus-api-jdo-3.2.6.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\datanucleus-core-3.2.10.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\datanucleus-rdbms-3.2.9.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\derby-10.10.2.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\eigenbase-properties-1.1.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\geronimo-annotation_1.0_spec-1.1.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\geronimo-jaspic_1.0_spec-1.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\geronimo-jta_1.1_spec-1.1.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\groovy-all-2.4.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\guava-14.0.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-accumulo-handler-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-ant-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-beeline-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-cli-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-common-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-contrib-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-exec-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-hbase-handler-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-hwi-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-jdbc-1.2.1000.2.4.2.0-258-standalone.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-jdbc-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-metastore-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-serde-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-service-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-shims-0.20S-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-shims-0.23-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-shims-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-shims-common-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\hive-shims-scheduler-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\httpclient-4.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\httpcore-4.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\ivy-2.4.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\janino-2.7.6.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jcommander-1.32.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jdo-api-3.0.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jetty-all-7.6.0.v20120127.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jetty-all-server-7.6.0.v20120127.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jline-2.12.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\joda-time-2.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jpam-1.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\json-20090211.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jsr305-3.0.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\jta-1.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\libfb303-0.9.2.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\libthrift-0.9.2.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\log4j-1.2.16.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\mail-1.4.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\maven-scm-api-1.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\maven-scm-provider-svn-commons-1.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\maven-scm-provider-svnexe-1.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\netty-3.7.0.Final.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\opencsv-2.3.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\oro-2.0.8.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\paranamer-2.3.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\parquet-hadoop-bundle-1.6.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\plexus-utils-1.5.6.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\protobuf-java-2.5.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\regexp-1.3.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\servlet-api-2.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\snappy-java-1.0.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\sqljdbc4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\ST4-4.0.4.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\stax-api-1.0.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\stringtemplate-3.2.1.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\super-csv-2.2.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\tools.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\velocity-1.5.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\xz-1.0.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\lib\zookeeper-3.4.6.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-core-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-pig-adapter-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-server-extensions-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-streaming-1.2.1000.2.4.2.0-258.jar;;;;;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-core-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-pig-adapter-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-server-extensions-1.2.1000.2.4.2.0-258.jar;D:\HDP\hive-1.2.1000.2.4.2.0-258\hcatalog\share\hcatalog\hive-hcatalog-streaming-1.2.1000.2.4.2.0-258.jar
STARTUP_MSG: build = git://sijenkins-msi3/cygdrive/d/w/dal/project/hive-monarch -r 240760457150036e13035cbb82bcda0c65362f3a; compiled by 'jenkins' on Sun Apr 24 16:22:39 CUT 2016
************************************************************/
2016-10-12 14:29:26,444 INFO server.HiveServer2 (HiveServer2.java:startHiveServer2(421)) - Starting HiveServer2
2016-10-12 14:29:26,549 WARN conf.HiveConf (HiveConf.java:initialize(2855)) - HiveConf of name hive.log.dir does not exist
2016-10-12 14:29:26,808 INFO metastore.HiveMetaStore (HiveMetaStore.java:main(5917)) - Starting hive metastore on port 9083
2016-10-12 14:29:27,240 WARN conf.HiveConf (HiveConf.java:initialize(2855)) - HiveConf of name hive.log.dir does not exist
2016-10-12 14:29:27,274 INFO util.JvmPauseMonitor (JvmPauseMonitor.java:run(179)) - Starting JVM pause monitor
2016-10-12 14:29:27,287 INFO metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(599)) - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
2016-10-12 14:29:27,333 INFO metastore.ObjectStore (ObjectStore.java:initialize(294)) - ObjectStore, initialize called
2016-10-12 14:29:27,747 INFO DataNucleus.Persistence (Log4JLogger.java:info(77)) - Property datanucleus.cache.level2 unknown - will be ignored
2016-10-12 14:29:27,748 INFO DataNucleus.Persistence (Log4JLogger.java:info(77)) - Property hive.metastore.integral.jdo.pushdown unknown - will be ignored
2016-10-12 14:29:27,772 INFO metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(599)) - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
2016-10-12 14:29:27,833 INFO metastore.ObjectStore (ObjectStore.java:initialize(294)) - ObjectStore, initialize called
2016-10-12 14:29:28,144 INFO DataNucleus.Persistence (Log4JLogger.java:info(77)) - Property datanucleus.cache.level2 unknown - will be ignored
2016-10-12 14:29:28,144 INFO DataNucleus.Persistence (Log4JLogger.java:info(77)) - Property hive.metastore.integral.jdo.pushdown unknown - will be ignored
2016-10-12 14:29:29,518 WARN conf.HiveConf (HiveConf.java:initialize(2855)) - HiveConf of name hive.log.dir does not exist
2016-10-12 14:29:29,519 INFO metastore.ObjectStore (ObjectStore.java:getPMF(379)) - Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order"
2016-10-12 14:29:29,786 WARN conf.HiveConf (HiveConf.java:initialize(2855)) - HiveConf of name hive.log.dir does not exist
2016-10-12 14:29:29,787 INFO metastore.ObjectStore (ObjectStore.java:getPMF(379)) - Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order"
2016-10-12 14:29:31,098 WARN DataNucleus.Query (Log4JLogger.java:warn(106)) - Query for candidates of org.apache.hadoop.hive.metastore.model.MDatabase and subclasses resulted in no possible candidates
Required table missing : "DBS" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "DBS" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:485)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605)
at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954)
at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679)