presto安装部署教程

1.下载安装包

https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.273.3/presto-server-0.273.3.tar.gz

并解压到安装目录 ，进入安装目录，创建配置etc目录

2.配置config.properties

进入安装目录，增加配置文件config.properties

vi config.properties
 
coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
query.max-memory=1GB
query.max-memory-per-node=512MB
query.max-total-memory-per-node=512MB
discovery-server.enabled=true
discovery.uri=http://localhost:8080

3.配置 jvm.config 

vi jvm.config 
 
-server
-Xmx8G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError

4.配置node.properties

 vi node.properties 
 
 
node.environment=production
node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
node.data-dir=/var/presto/data

创建数据目录/var/presto/data并赋权 

5.连接hive 在etc下创建配置目录catalog，增加hive.properties 配置

mkdir etc/catalog

cat catalog/hive.properties 
 
 
connector.name=hive-hadoop2
hive.metastore.uri=thrift://hive-master:9083
hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml,/etc/hadoop/conf/mapred-site.xml
hive.allow-add-column=true
hive.allow-drop-column=true
hive.allow-drop-table=true
hive.allow-rename-table=true
hive.allow-rename-column=true
hive.parquet.use-column-names=true

 presto安装问题(java.net.UnknownHostException)

解决方案:在hive.properties 增加如下配置

hive.config.resources=/etc/hadoop/hdfs-site.xml,/etc/hadoop/core-site.xml

注意:路径是hadoop配置文件hdfs-site.xml和core-site.xml的路径

6.启动 

./bin/launcher run  可以控制台直接查看日志
 
./bin/launcher start  后台启动

7.连接查询

下载启动client包，https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.273.3/presto-cli-0.273.3-executable.jar 

重命名并赋权

mv presto-cli-0.273.3-executable.jar presto
chmod 755 presto

 presto连接hive查询

./presto --server localhost:8080 --catalog hive --schema default

参照文档：

Deploying Presto — Presto 0.273.3 Documentation