下载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
此处内容已被隐藏,扫码关注微信公众号,发送【九万里】获取验证码解锁