Presto-0.228

介绍

Presto是一个运行在机器集群上的分布式系统。完整的安装包括一个协调程序和多个工作程序。查询从客户端(如Presto CLI)提交到协调器。协调器解析、分析和计划查询执行，然后将处理分配给工作者。

 

安装包下载

https://repo1.maven.org/maven2/com/facebook/presto

 

新建etc目录

mkdir -p /opt/presto-server/etc

 

新建文件：etc/node.properties

node.environment=production
node.id=hadoop
node.data-dir=/opt/presto-server/data

 

新建文件：etc/jvm.config

-server
-Xmx1G
-XX:+UseG1GC
-XX:G1HeapRegionSize=8M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError

 

新建文件：etc/config.properties

coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=9090
query.max-memory=1GB
query.max-memory-per-node=1GB
query.max-total-memory-per-node=1GB
discovery-server.enabled=true
discovery.uri=http://hadoop:9090

 

新建文件：etc/log.properties

com.facebook.presto=INFO

 

connectors配置

新建目录：etc/catalog，配置hive.properties

connector.name=hive
hive.metastore.uri=thrift://hadoop:9083
hive.parquet.fail-on-corrupted-statistics=false

 

启动Presto

bin/launcher start

 

查看http://hadoop:9090/ui/

 

Presto-cli的使用【将presto-cli-0.228-executable.jar重命名presto-cli即可】

[root@hadoop presto]# ./presto-cli --server hadoop:9090 --catalog hive
presto> help

Supported commands:
QUIT
EXPLAIN [ ( option [, ...] ) ] <query>
    options: FORMAT { TEXT | GRAPHVIZ }
             TYPE { LOGICAL | DISTRIBUTED }
DESCRIBE <table>
SHOW COLUMNS FROM <table>
SHOW FUNCTIONS
SHOW CATALOGS [LIKE <pattern>]
SHOW SCHEMAS [FROM <catalog>] [LIKE <pattern>]
SHOW TABLES [FROM <schema>] [LIKE <pattern>]
USE [<catalog>.]<schema>

presto> show schemas;
       Schema       
--------------------
 default            
 edw                
 information_schema 
(3 rows)

Query 20200218_101852_00000_wmc57, FINISHED, 1 node
Splits: 19 total, 19 done (100.00%)
0:02 [3 rows, 43B] [1 rows/s, 23B/s]

presto> use edw;
USE
presto:edw> show tables;
      Table       
------------------
 t_mkt_custr_info 
 t_mkt_event_info 
(2 rows)

Query 20200218_101910_00002_wmc57, FINISHED, 1 node
Splits: 19 total, 19 done (100.00%)
0:01 [2 rows, 58B] [1 rows/s, 43B/s]

presto:edw> quit