Presto安装配置

一、Presto安装配置

• 集群规划（一主两从集群）hadoop01hadoop02主coordinatoryesno从workeryesyes
• java8版本安装#可以手动安装oracle JDK#也可以使用yum在线安装 openjDKyum install java-1.8.0-openjdk* -y#安装完成后，查看jdk版本：java-version
• 上传解压Presto安装包#创建安装目录mkdir-p /export/server#yum安装上传文件插件lrzszyum install-y lrzsz#上传安装包到hadoop01的/export/server目录presto-server-0.245.1.tar.gz#解压、重命名tar-xzvf presto-server-0.245.1.tar.gzmv presto-server-0.245.1 presto#创建配置文件存储目录mkdir-p /export/server/presto/etc
• 添加配置文件- hadoop01配置- etc/config.propertiescd /export/server/prestovim etc/config.properties#---------添加如下内容coordinator=truenode-scheduler.include-coordinator=truehttp-server.http.port=8090query.max-memory=6GBquery.max-memory-per-node=2GBquery.max-total-memory-per-node=2GBdiscovery-server.enabled=truediscovery.uri=http://192.168.88.80:8090#---------end#参数说明coordinator:是否为coordinator节点，注意worker节点需要写falsenode-scheduler.include-coordinator:coordinator在调度时是否也作为workerdiscovery-server.enabled:Discovery服务开启功能。presto通过该服务来找到集群中所有的节点。每一个Presto实例都会在启动的时候将自己注册到discovery服务； 注意：worker节点不需要配 discovery.uri:Discovery server的URI。由于启用了Presto coordinator内嵌的Discovery服务，因此这个uri就是Presto coordinator的uri。- etc/jvm.configvim etc/jvm.config-server-Xmx3G-XX:+UseG1GC-XX:G1HeapRegionSize=32M-XX:+UseGCOverheadLimit-XX:+ExplicitGCInvokesConcurrent-XX:+HeapDumpOnOutOfMemoryError-XX:+ExitOnOutOfMemoryError- etc/node.propertiesmkdir -p /export/data/prestovim etc/node.propertiesnode.environment=cdhprestonode.id=presto-cdh01node.data-dir=/export/data/presto- etc/catalog/hive.propertiesmkdir -p etc/catalogvim etc/catalog/hive.propertiesconnector.name=hive-hadoop2hive.metastore.uri=thrift://192.168.88.80:9083
• scp安装包到其他节点#在hadoop02创建文件夹mkdir-p /export/server#在hadoop01远程cp安装包cd /export/serverscp-r presto hadoop02:$PWD#ssh的时候如果没有配置免密登录 需要输入密码scp 密码：123456
• hadoop02配置修改- etc/config.propertiescd /export/server/prestovim etc/config.properties#----删除之前的内容 替换为以下的内容coordinator=falsehttp-server.http.port=8090query.max-memory=6GBquery.max-memory-per-node=2GBquery.max-total-memory-per-node=2GBdiscovery.uri=http://192.168.88.80:8090- etc/jvm.config> 和coordinator保持一样，不需要修改vim etc/jvm.config-server-Xmx3G-XX:+UseG1GC-XX:G1HeapRegionSize=32M-XX:+UseGCOverheadLimit-XX:+ExplicitGCInvokesConcurrent-XX:+HeapDumpOnOutOfMemoryError-XX:+ExitOnOutOfMemoryError- etc/node.propertiesmkdir -p /export/data/prestovim etc/node.propertiesnode.environment=cdhprestonode.id=presto-cdh02node.data-dir=/export/data/presto- etc/catalog/hive.propertiesvim etc/catalog/hive.propertiesconnector.name=hive-hadoop2hive.metastore.uri=thrift://192.168.88.80:9083

二、Presto服务启停

注意，每台机器都需要启动

• 前台启动[root@hadoop01 ~]# cd ~[root@hadoop01 ~]# /export/server/presto/bin/launcher run[root@hadoop02 ~]# cd ~[root@hadoop02 ~]# /export/server/presto/bin/launcher run#如果出现下面的提示 表示启动成功2021-09-15T18:24:21.780+0800 INFO main com.facebook.presto.server.PrestoServer ======== SERVER STARTED ========#前台启动使用ctrl+c进行服务关闭
• 后台启动[root@hadoop01 ~]# cd ~[root@hadoop01 ~]# /export/server/presto/bin/launcher startStarted as 89560[root@hadoop02 ~]# cd ~[root@hadoop02 ~]# /export/server/presto/bin/launcher startStarted as 92288#查看进程是否启动成功PrestoServer#后台启动使用jps 配合kill -9命令 关闭进程
• web UI页面http://192.168.88.80:8090/ui/
• 启动日志#日志路径：/export/data/presto/var/log/http-request.loglauncher.logserver.log

三、Presto CLI命令行客户端

• 下载CLI客户端presto-cli-0.241-executable.jar
• 上传客户端到Presto安装包#上传presto-cli-0.245.1-executable.jar到/export/server/presto/binmv presto-cli-0.245.1-executable.jar prestochmod +x presto
• CLI客户端启动/export/server/presto/bin/presto --server localhost:8090 --catalog hive --schema default

四、Presto Datagrip JDBC访问

• JDBC 驱动：presto-jdbc-0.245.1.jar
• JDBC 地址：jdbc:presto://192.168.88.80:8090/hive