[Solved] hive Caused by: MetaException(message:Version information not found in metastore. )

Leave a reply 
Logging initialized using configuration in jar:file:/D:/hive/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/D:/hadoop/hadoop-2.6.5/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/D:/hbase/hbase-1.3.5/lib/slf4j-log4j12-1.7.5.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]
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
        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.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.(RetryingMetaStoreClient.java:86)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
        at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
        at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
        ... 8 more
Caused by: java.lang.reflect.InvocationTargetException
        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.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
        ... 14 more
Caused by: MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6664)
        at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6645)
        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.RawStoreProxy.invoke(RawStoreProxy.java:114)
        at com.sun.proxy.$Proxy6.verifySchema(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:620)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5768)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:199)
        at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.(SessionHiveMetaStoreClient.java:74)
        ... 19 more
 
C:\Windows\System32>hive --service metastore
"Starting Hive Metastore Server"
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.client.capability.check does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggregate.stats.false.positive.probability does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.broker.address.default does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.orc.time.counters does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.task.scale.memory.reserve-fraction.min does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.splits.ms.footer.cache.ppd.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.event.message.factory does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.metrics.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.hs2.user.access does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.storage.storageDirectory does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.am.liveness.connection.timeout.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.dynamic.semijoin.reduction.threshold does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.client.connect.retry.limit does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.xmx.headroom does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.dynamic.semijoin.reduction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.direct does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.enforce.stats does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.client.consistent.splits does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.tez.session.lifetime does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.timedout.txn.reaper.start does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.cache.ttl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.management.acl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.delegation.token.lifetime does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.authentication.ldap.guidKey does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.ats.hook.queue.capacity does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.strict.checks.large.query does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.bigtable.minsize.semijoin.reduction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.alloc.min does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.client.user does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.alloc.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.wait.queue.comparator.class.name does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.output.service.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.cache.use.soft.references does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.task.scale.memory.reserve.fraction.max does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.communicator.listener.thread-count does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.container.max.java.heap.fraction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.stats.column.autogather does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.am.liveness.heartbeat.interval.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.decoding.metrics.percentiles.intervals does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.groupby.position.alias does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.txn.store.impl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.use.groupby.shuffle does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.object.cache.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.parallel.ops.in.session does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.groupby.limit.extrastep does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.use.ssl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.file.location does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.client.retry.delay.seconds does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.materializedview.fileformat does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.num.file.cleaner.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.test.fail.compaction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.blobstore.use.blobstore.as.scratchdir does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.class does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.mmap.path does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.download.permanent.fns does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.max.historic.queries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.vectorized.execution.reducesink.new.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.max.num.delta does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.history.retention.attempted does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.initiator.failed.compacts.threshold does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.reporter does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.output.service.max.pending.writes does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.execution.mode does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.enable.grace.join.in.llap does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.limittranspose does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.memory.mode does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.threadpool.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.select.threshold does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.scratchdir.lock does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.use.spnego does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.file.frequency does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.hs2.coordinator.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.timeout.seconds does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.filter.stats.reduction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.exec.orc.base.delta.ratio does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.fastpath does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.clear.dangling.scratchdir does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.test.fail.heartbeater does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.file.cleanup.delay.seconds does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.management.rpc.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.mapjoin.hybridgrace.bloomfilter does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.enforce.tree does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.stats.ndv.tuner does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.direct.sql.max.query.length does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.history.retention.failed does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.close.session.on.disconnect does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.ppd.windowing does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.initial.metadata.count.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.host does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.splits.ms.footer.cache.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.point.lookup.min does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.file.metadata.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.service.refresh.interval.sec does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.max.output.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.driver.parallel.compilation does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.remote.token.requires.signing does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.bucket.pruning does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.cache.allow.synthetic.fileid does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.hash.table.inflation.factor does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggr.stats.hbase.ttl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.enforce.vectorized does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.writeset.reaper.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.vector.serde.deserialize does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.order.columnalignment does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.output.service.send.buffer.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.exec.schema.evolution does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.direct.sql.max.elements.values.clause does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.llap.concurrent.queries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.allow.uber does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.indexer.partition.size.max does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.auth does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.splits.include.fileid does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.communicator.num.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orderby.position.alias does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.communicator.connection.sleep.between.retries.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggregate.stats.max.partitions does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.hadoop2.component does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.yarn.shuffle.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.direct.sql.max.elements.in.clause does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.passiveWaitTimeMs does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.load.dynamic.partitions.thread does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.indexer.segments.granularity does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.http.response.header.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.conf.internal.variable.list does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.limittranspose.reductionpercentage does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.repl.cm.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.client.retry.limit does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.resultset.serialize.in.tasks does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.query.timeout.seconds does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.service.metrics.hadoop2.frequency does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.splits.directory.batch.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.cache.max.reader.wait does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.node.reenable.max.timeout.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.max.open.txns does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.auto.convert.sortmerge.join.reduce.side does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.zookeeper.publish.configs does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.auto.convert.join.hashtable.max.entries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.tez.sessions.init.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.authorization.storage.check.externaltable.drop does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.execution.mode does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.cbo.cnf.maxnodes does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.vectorized.adaptor.usage.mode does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.materializedview.rewriting does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.authentication.ldap.groupMembershipKey does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.catalog.cache.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.cbo.show.warnings does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.fshandler.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.max.bloom.filter.entries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.metadata.fraction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.materializedview.serde does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.task.scheduler.wait.queue.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggr.stats.cache.entries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.txn.operational.properties does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggr.stats.memory.ttl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.rpc.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.nonvector.wrapper.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggregate.stats.cache.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.vectorized.input.format does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.cte.materialize.threshold does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.cache.clean.until does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.semijoin.conversion does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.dynamic.partition.pruning does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.metrics.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.repl.rootdir does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.limit.partition.request does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.async.log.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.logger does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.allow.udf.load.on.demand does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.cli.tez.session.async does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.bloom.filter.factor does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.am-reporter.max.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.use.file.size.for.mapjoin does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.strict.checks.bucketing does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.bucket.pruning.compat does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.spnego.principal does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.task.preemption.metrics.intervals does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.shuffle.dir.watcher.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.arena.count does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.use.SSL does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.communicator.connection.timeout.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.transpose.aggr.join does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.maxTries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.dynamic.partition.pruning.max.data.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.metadata.base does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggr.stats.invalidator.frequency does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.use.lrfu does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.mmap does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.coordinator.address.default does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.resultset.max.fetch.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.io.sarg.cache.max.weight.mb does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.clear.dangling.scratchdir.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.sleep.time does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.row.serde.deserialize does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.compile.lock.timeout does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.timedout.txn.reaper.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.aggregate.stats.max.variance does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.lrfu.lambda does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.metadata.db.type does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.output.stream.timeout does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.transactional.events.mem does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.resultset.default.fetch.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.repl.cm.retain does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.merge.cardinality.check does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.authentication.ldap.groupClassKey does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.point.lookup does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.allow.permanent.fns does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.web.ssl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.txn.manager.dump.lock.state.on.acquire.timeout does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.history.retention.succeeded does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.use.fileid.path does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.slice.row.count does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.mapjoin.optimized.hashtable.probe.percent does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.select.distribute does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.am.use.fqdn does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.node.reenable.min.timeout.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.validate.acls does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.support.special.characters.tablename does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.mv.files.thread does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.skip.compile.udf.check does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.vector.serde.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.repl.cm.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.sleep.interval.between.start.attempts does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.yarn.container.mb does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.http.read.timeout does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.blobstore.optimizations.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.orc.gap.cache does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.dynamic.partition.hashjoin does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.exec.copyfile.maxnumfiles does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.formats does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.http.numConnection does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.task.scheduler.enable.preemption does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.num.executors does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.cache.max.full does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.connection.class does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.tez.sessions.custom.queue.allowed does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.slice.lrr does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.client.password does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.metastore.hbase.cache.max.writer.wait does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.thrift.http.request.header.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.webui.max.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.limittranspose.reductiontuples does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.test.rollbacktxn does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.num.schedulable.tasks.per.node does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.acl does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.memory.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.strict.checks.type.safety does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.async.exec.async.compile does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.auto.max.input.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.enable.memory.manager does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.msck.repair.batch.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.blobstore.supported.schemes does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.splits.allow.synthetic.fileid does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.stats.filter.in.factor does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.use.op.stats does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.exec.input.listing.max.threads does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.tez.session.lifetime.jitter does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.web.port does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.strict.checks.cartesian.product does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.rpc.num.handlers does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.vcpus.per.instance does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.count.open.txns.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.min.bloom.filter.entries does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.optimize.partition.columns.separate does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.orc.cache.stripe.details.mem.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.txn.heartbeat.threadpool.size does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.locality.delay does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.repl.cmrootdir does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.task.scheduler.node.disable.backoff.factor does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.am.liveness.connection.sleep.between.retries.ms does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.spark.exec.inplace.progress does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.working.directory does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.daemon.memory.per.instance.mb does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.msck.path.validation does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.task.scale.memory.reserve.fraction does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.merge.nway.joins does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.compactor.history.reaper.interval does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.txn.strict.locking.mode does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.encode.vector.serde.async.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.tez.input.generate.consistent.splits does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.in.place.progress does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.druid.indexer.memory.rownum.max does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.server2.xsrf.filter.enabled does not exist
20/03/16 15:31:19 WARN conf.HiveConf: HiveConf of name hive.llap.io.allocator.alloc.max does not exist
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/D:/hadoop/hadoop-2.6.5/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/D:/hbase/hbase-1.3.5/lib/slf4j-log4j12-1.7.5.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]
MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6664)
        at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6645)
        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.RawStoreProxy.invoke(RawStoreProxy.java:114)
        at com.sun.proxy.$Proxy2.verifySchema(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:620)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5757)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5990)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5915)
        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)
Exception in thread "main" MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6664)
        at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6645)
        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.RawStoreProxy.invoke(RawStoreProxy.java:114)
        at com.sun.proxy.$Proxy2.verifySchema(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:620)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5757)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5990)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5915)
        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)

Solution:

Modify it in hive-site.xml: hive.metastore.schema.verification is set to false.

Read More:

Leave a Reply

Your email address will not be published. Required fields are marked *