prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.92k stars 5.33k forks source link

PrestoDB No nodes available to run query with Hive #9360

Closed annisun closed 4 years ago

annisun commented 6 years ago

coordinator=true node-scheduler.include-coordinator=false http-server.http.port=8080 query.max-memory=50GB query.max-memory-per-node=1GB discovery-server.enabled=true discovery.uri=http://172.16.9.100:8080

connector.name=hive-hadoop2 hive.metastore.uri=thrift://172.16.9.100:9083 hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml hive.force-local-scheduling=true

this is Configuration of my master node, I running the query "select * from incentive_pl.incentive_pl_detail limit 1000",

it's throw the error : lalpbbcc1sntqd_nahnnbca_1056_537

what‘s happened about presto?

zhaiyuyong commented 6 years ago

how much nodes?

annisun commented 6 years ago

10 nodes


DT Team --- 李焰 skype: dm_sj_itly Tel:15625255565 创颖峻网络科技(深圳)有限公司

------------------ Original ------------------ From: "翟玉勇"notifications@github.com; Date: Fri, Nov 17, 2017 03:26 PM To: "prestodb/presto"presto@noreply.github.com; Cc: "annisun"liyan@ux168.com; "Author"author@noreply.github.com; Subject: Re: [prestodb/presto] PrestoDB No nodes available to run query withHive (#9360)

how much nodes?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

zhaiyuyong commented 6 years ago

use presto-cli execute "select * FROM system.runtime.nodes"
show the nodes status

annisun commented 6 years ago

this picture is the result


DT Team --- 李焰 skype: dm_sj_itly Tel:15625255565 创颖峻网络科技(深圳)有限公司

------------------ Original ------------------ From: "翟玉勇"notifications@github.com; Date: Fri, Nov 17, 2017 04:37 PM To: "prestodb/presto"presto@noreply.github.com; Cc: "annisun"liyan@ux168.com; "Author"author@noreply.github.com; Subject: Re: [prestodb/presto] PrestoDB No nodes available to run query withHive (#9360)

use presto-cli execute "select * FROM system.runtime.nodes" show the nodes status

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.