Skip to content

Instantly share code, notes, and snippets.

@wyukawa
Created August 24, 2015 04:28
Show Gist options
  • Select an option

  • Save wyukawa/f1fb65e52777999a1e7b to your computer and use it in GitHub Desktop.

Select an option

Save wyukawa/f1fb65e52777999a1e7b to your computer and use it in GitHub Desktop.
presto hive metastore error
java.lang.RuntimeException: Failed connecting to Hive metastore: localhost:9083
at com.facebook.presto.hive.StaticHiveCluster.createMetastoreClient(StaticHiveCluster.java:48)
at com.facebook.presto.hive.metastore.CachingHiveMetastore.lambda$loadPartitionNamesByParts$21(CachingHiveMetastore.java:585)
at com.facebook.presto.hive.metastore.CachingHiveMetastore$$Lambda$625/817173694.call(Unknown Source)
at com.facebook.presto.hive.metastore.HiveMetastoreApiStats$1.call(HiveMetastoreApiStats.java:44)
at com.facebook.presto.hive.RetryDriver.run(RetryDriver.java:136)
at com.facebook.presto.hive.metastore.CachingHiveMetastore.loadPartitionNamesByParts(CachingHiveMetastore.java:584)
at com.facebook.presto.hive.metastore.CachingHiveMetastore.access$600(CachingHiveMetastore.java:85)
at com.facebook.presto.hive.metastore.CachingHiveMetastore$7.load(CachingHiveMetastore.java:202)
at com.facebook.presto.hive.metastore.CachingHiveMetastore$7.load(CachingHiveMetastore.java:197)
at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:189)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
at com.facebook.presto.hive.metastore.CachingHiveMetastore.get(CachingHiveMetastore.java:251)
at com.facebook.presto.hive.metastore.CachingHiveMetastore.getPartitionNamesByParts(CachingHiveMetastore.java:574)
at com.facebook.presto.hive.HiveSplitManager.getFilteredPartitionNames(HiveSplitManager.java:306)
at com.facebook.presto.hive.HiveSplitManager.getPartitions(HiveSplitManager.java:200)
at com.facebook.presto.spi.classloader.ClassLoaderSafeConnectorSplitManager.getPartitions(ClassLoaderSafeConnectorSplitManager.java:46)
at com.facebook.presto.metadata.MetadataManager.getLayouts(MetadataManager.java:269)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.planTableScan(AddExchanges.java:613)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitFilter(AddExchanges.java:564)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitFilter(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.FilterNode.accept(FilterNode.java:71)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:735)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.JoinNode.accept(JoinNode.java:161)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:735)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.JoinNode.accept(JoinNode.java:161)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.planChild(AddExchanges.java:977)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitProject(AddExchanges.java:215)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitProject(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:735)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitJoin(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.JoinNode.accept(JoinNode.java:161)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.planChild(AddExchanges.java:977)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitProject(AddExchanges.java:215)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitProject(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.planChild(AddExchanges.java:977)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitLimit(AddExchanges.java:525)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitLimit(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.LimitNode.accept(LimitNode.java:72)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.planChild(AddExchanges.java:977)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitOutput(AddExchanges.java:221)
at com.facebook.presto.sql.planner.optimizations.AddExchanges$Rewriter.visitOutput(AddExchanges.java:172)
at com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:79)
at com.facebook.presto.sql.planner.optimizations.AddExchanges.optimize(AddExchanges.java:134)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:96)
at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:258)
at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:237)
at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:201)
at com.facebook.presto.execution.QueuedExecution.lambda$start$104(QueuedExecution.java:68)
at com.facebook.presto.execution.QueuedExecution$$Lambda$234/1348585990.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: localhost: java.net.ConnectException: Cannot assign requested address
at com.facebook.presto.hive.HiveMetastoreClientFactory.rewriteException(HiveMetastoreClientFactory.java:58)
at com.facebook.presto.hive.HiveMetastoreClientFactory.access$000(HiveMetastoreClientFactory.java:33)
at com.facebook.presto.hive.HiveMetastoreClientFactory$TTransportWrapper.open(HiveMetastoreClientFactory.java:174)
at com.facebook.presto.hive.HiveMetastoreClientFactory.createTransport(HiveMetastoreClientFactory.java:73)
at com.facebook.presto.hive.HiveMetastoreClientFactory.create(HiveMetastoreClientFactory.java:64)
at com.facebook.presto.hive.StaticHiveCluster.createMetastoreClient(StaticHiveCluster.java:45)
... 61 more
Caused by: java.net.ConnectException: Cannot assign requested address
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
at com.facebook.presto.hive.HiveMetastoreClientFactory$TTransportWrapper.open(HiveMetastoreClientFactory.java:171)
... 64 more
@dabaitu

dabaitu commented Oct 26, 2016

Copy link
Copy Markdown

Hi, were you able to resolve this issue? I also see this occasionally.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment