Presto安装

Presto安装

 

1. Presto Server配置

解压缩presto-server-0.166.tar.gz

tar zxvf presto-server-0.166.tar.gz

 

在presto-server-0.166目录下创建etc目录

cd presto-server-0.166 mkdir etc

 

在etc目录下创建catalog目录

cd etc mkdir catalog

 

在catalog目录下创建文件hive.properties，文件内容如下:

connector.name=hive-hadoop2 hive.metastore.uri=thrift://master:9083 hive.config.resources=/home/bigdata/hadoop-2.7.3/etc/hadoop/core-site.xml,/home/bigdata/hadoop-2.7.3/etc/hadoop/hdfs-site.xml

 

在etc目录下创建config.properties文件，文件内容如下:

coordinator=true node-scheduler.include-coordinator=true http-server.http.port=8080 query.max-memory=512MB query.max-memory-per-node=512MB discovery-server.enabled=true discovery.uri=http://master:8080

 

在etc目录下创建jvm.config文件，文件内容如下:

-server -Xmx1G -XX:+UseG1GC -XX:G1HeapRegionSize=32M -XX:+UseGCOverheadLimit -XX:+ExplicitGCInvokesConcurrent -XX:+HeapDumpOnOutOfMemoryError -XX:OnOutOfMemoryError=kill -9 %p

 

在etc目录下创建node.properties文件，文件内容如下:

node.environment=production node.id=bigdata node.data-dir=/home/master/presto-server-0.166/presto_data

 

1. Presto Cient配置

把客户端jar包放置在presto-server-0.166/bin目录下

mv presto-cli-0.166-executable.jar presto-server-0.166/bin/

 

修改客户端jar包名为presto

mv presto-cli-0.166-executable.jar presto

 

修改presto客户端jar包权限

chmod +x presto

 

把presto添加到环境变量中（~/.bash_profile）

[zkpk@master ~]$ gedit ./.bashrc

export PRESTO_HOME=/home/master/presto-server-0.166 export PATH=$PRESTO_HOME/bin:$PATH

 

使得环境变量立即生效

source ~/.bash_profile

[zkpk@master ~]$ source .bashrc

1. 启动Presto

Presto依赖HDFS和Hive metastore

 

启动HDFS

/home/bigdata/software/hadoop-2.7.3/sbin/start-dfs.sh

 

启动Hive metastore

sudo service mysqld start nohup hive --service metastore >> /home/bigdata/software/apache-hive-2.1.1-bin/metastore.log 2>&1 &

 

启动Presto

/home/bigdata/software/presto-server-0.166/bin/launcher start

 

查看Presto Web UI

http://bigdata:8080

 

启动Presto客户端

presto --server bigdata:8080 --catalog hive --schema default