下载presto安装包

presto官网：https://prestodb.io
presto-server下载链接：
https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.255/presto-server-0.255.tar.gz
presto-cli下载链接：
https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.255/presto-cli-0.255-executable.jar
presto-jdbc下载链接:
https://repo1.maven.org/maven2/com/facebook/presto/presto-jdbc/0.255/presto-jdbc-0.255.jar

配置presto

tar -zxf presto-server-0.255.tar.gz -C /opt
cd /opt/presto-server-0.255/etc

将presto-cli-0.255-executable.jar放到/opt/presto-server-0.255/bin下面

cd /opt/presto-server-0.255/bin
ln -s presto-cli-0.255-executable.jar presto
ln -s /opt/presto-server-0.255/bin/presto /usr/bin/presto

需要创建的配置文件

[root@jwldata01 etc]# pwd
/opt/presto-server-0.255/etc
[root@jwldata01 etc]# 
[root@jwldata01 etc]# tree
.
├── access-control.properties
├── catalog
│   └── hive.properties
├── config.properties
├── jvm.config
├── log.properties
└── node.properties

1 directory, 6 files

coordinator和worker共有的配置

jvm.config

-server
-Xmx8G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError
-Djava.security.krb5.conf=/etc/krb5.conf

log.properties

com.facebook.presto=INFO

node.properties

node.environment=presto_dev
node.id=presto-jwldata01
node.data-dir=/data01/presto

node.id每个节点需要修改，node.data-dir根据实际修改。

coordinator的配置

config.properties

coordinator=true
node-scheduler.include-coordinator=false
http-server.http.port=9900
query.max-memory=4GB
query.max-memory-per-node=1GB
discovery-server.enabled=true
discovery.uri=http://jwldata01:9900

（可选）如果是搭一个测试集群，单节点或者节点数比较少，可以让coordinator也充当worker，但生产环境还是建议角色分开。

node-scheduler.include-coordinator=true

（可选）如果需要presto只读
access-control.properties

access-control.name=read-only

worker的配置

config.properties

coordinator=false
http-server.http.port=9900
query.max-memory=4GB
query.max-memory-per-node=1GB
discovery.uri=http://jwldata01:9900

Hive Connector

此处内容已被隐藏，扫码关注微信公众号，发送【九万里】获取验证码解锁