install-2

一、 jdk替换
1、presto有jdk版本要求，将原来JAVA_HOME下的包进行备份，
将jdk-8u201-linux-x64.tar进行解压，直接替换原来的内容即可，路径不用修改，还用原来的path
二、presto部署

  1.       1.本次部署presto部署5个点，分别传到5台机器上
  2.       2.1
  3.       ——————————————coordinator节点配置-----------------------------------------------------------------
  4.         修改config.properties
  6.            coordinator=true                                           #是coordinator节点
  7.            node-scheduler.include-coordinator=true                    #是coordinator节点，同时是woker节点
  8.            http-server.http.port=9002                                 # HTTP端口
  9.            query.max-memory=6GB
  10.            query.max-memory-per-node=2GB
  11.            query.max-total-memory-per-node=4GB
  12.            discovery-server.enabled=true                              #Presto使用Discovery服务查找群集中的所有节点
  13.            discovery.uri=http://cdh1:9002                             #http地址
  15. http-server.http.port: Specifies the port for the HTTP server. Presto uses HTTP for all communication, internal and external.
  16. discovery.uri: The URI to the Discovery server. 
  17.                 Because we have enabled the embedded version of Discovery in the Presto coordinator, 
  18.                 this should be the URI of the Presto coordinator.
  19.                 Replace example.net:8080 to match the host and port of the Presto coordinator. 
  20.                 This URI must not end in a slash.
  22.           ——————————————woker节点配置-----------------------------------------------------------------
  23.               修改config.properties
  25.            coordinator=false                                                        #是coordinator节点
  26.            node-scheduler.include-coordinator=false                   #是woker节点
  27.            http-server.http.port=9002                                          # HTTP端口
  28.            query.max-memory=6GB
  29.            query.max-memory-per-node=2GB
  30.            query.max-total-memory-per-node=4GB
  31.            #discovery-server.enabled=true                             #注释掉
  32.            discovery.uri=http://cdh1:9002                             #coordinator节点地址
  35.        2.2 catalog/hive.properties  修改hive 的连接
  36.            connector.name=hive-hadoop2                                  #写死格式
  37.            hive.metastore.uri=thrift://cdh1:9083                        #hive.metastore.uri与端口
  38.            hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml       #core-site.xml与hdfs-site.xml 位置
  39.            在hive的catalog配置文件中，加入如下配置 hive.parquet.fail-on-corrupted-statistics=false
  42.        2.3    node.properties 配置
  43.             node.environment=dev                                    #集群名称 （统一值）
  44.             node.id=presto-node2                                    #本节点名称（唯一值）
  45.             node.data-dir=/data1/presto/data                        #自定义数据路径 
  49.          3.1  catalog/kudu.properties
  50.          cat kudu.properties
  51.          connector.name=kudu
  52.          kudu.client.master-addresses=192.168.135.42:7051,192.168.135.43:7051,192.168.135.44:7051

4 运行 bin 下面
./launcher start #启动服务，日志在自定义数据路径下

5 登录
./presto —server 10.30.50.87:9001 —catalog hive —schema default
./presto —server 10.60.249.56:9001 —catalog kudu —schema default

presto:default> show schemas; #查询数据库

Schema

dataplatform_hongyan
default
information_schema
(3 rows)

Query 20201022_024751_00010_st4m9, FINISHED, 2 nodes
Splits: 36 total, 36 done (100.00%)
0:00 [3 rows, 60B] [10 rows/s, 201B/s]

api 查看状态

节点个数
curl http://127.0.0.1:9002/v1/cluster