presto

presto中文站：http://prestodb-china.com/

进入hadoop机器，进入presto所在bin目录:presto --server localhost:9090 --catalog hive --schema voice_logs

presto-server-0.147/etc/worker-config.properties :

coordinator=false
http-server.http.port=9090
query.max-memory=5GB
query.max-memory-per-node=1GB
discovery.uri=http://10.45.137.137:9090

schema voice_logs 是指定的hive中的schema

 

presto:bot_logs> select count(*) from querys;

Query 20171227_072902_00029_52eas, RUNNING, 5 nodes, 1,171 splits
1:18 [63.7M rows, 35.8GB] [ 821K rows/s, 472MB/s] [<=> ]

STAGES ROWS ROWS/s BYTES BYTES/s QUEUED RUN DONE
0.........R 671 8 5.9K 77B 0 1 0
1.......S 63.7M 821K 35.8G 472M 339 159 672

表示正在执行sql

转载于:https://www.cnblogs.com/dayibagou/p/8126014.html