facebook presto安装与配置 CDH4.4
- - CSDN博客云计算推荐文章下载: http://search.maven.org/remotecontent?filepath=com/facebook/presto/presto-server/0.52/presto-server-0.52.tar.gz. 重命名:mv presto-cli-0.52-executable.jar presto.
http://www.dw4e.com/?p=141
http://blog.csdn.net/u012417026/article/details/14516631
hadoop@yard02:~/bigdata/presto-server-0.52/$ tar zxvf presto-server-0.52.tar.gz
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cd presto-server-0.52/
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat node.properties
node.environment=production
node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
node.data-dir=/home/hadoop/bigdata/presto-server-0.52/data
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat jvm.config
-server
-Xmx16G
-XX:+UseConcMarkSweepGC
-XX:+ExplicitGCInvokesConcurrent
-XX:+CMSClassUnloadingEnabled
-XX:+AggressiveOpts
-XX:+HeapDumpOnOutOfMemoryError
-XX:OnOutOfMemoryError=kill -9 %p
-XX:PermSize=150M
-XX:MaxPermSize=150M
-XX:ReservedCodeCacheSize=150M
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat config.properties
coordinator=true
datasources=jmx,hive
http-server.http.port=8080
presto-metastore.db.type=h2
presto-metastore.db.filename=/home/hadoop/bigdata/presto-server-0.52/data/db/MetaStore
task.max-memory=1GB
discovery-server.enabled=true
discovery.uri=http://yard02:8080
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat log.properties
com.facebook.presto=DEBUG
hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat catalog/jmx.properties
connector.name=jmx
hadoop@yard02:~/bigdata/presto-server-0.52/etc/catalog$ touch hive.properties
###hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat catalog/hive.properties
connector.name=hive-cdh4
hive.metastore.uri=thrift://yard02:9083
重命名:mv presto-cli-0.52-executable.jar presto
启动:
hadoop@yard02:~/bigdata/presto-server-0.52/bin$ ./launcher start
需要先启动hiveserver
./hive --service hiveserver -p 9083
客户端链接:
hadoop@yard02:~/bigdata/presto-server-0.52/bin$ ./presto --server localhost:8080 --catalog hive --schema default
presto:default> list
-> ;
Query 20131120_114948_00002_3frqf failed: line 1:1: no viable alternative at input 'list'
list
presto:default> show tables;
Table
--------
mytest
(1 row)
Query 20131120_114955_00003_3frqf, FINISHED, 1 node
Splits: 2 total, 2 done (100.00%)
0:00 [1 rows, 23B] [2 rows/s, 68B/s]
presto:default>
http://prestodb.io/docs/current/installation/deployment.html