facebook presto安装与配置 CDH4.4

浅浅的花香味﹌ 2022-09-18 11:47 179阅读 0赞

# presto #

http://www.dw4e.com/?p=141
    http://blog.csdn.net/u012417026/article/details/14516631

### conf ###

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$ touch node.properties ###

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$ touch jvm.config ###

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$ touch config.properties ###

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$ touch log.properties ###

hadoop@yard02:~/bigdata/presto-server-0.52/etc$ cat log.properties 
    com.facebook.presto=DEBUG

### hadoop@yard02:~/bigdata/presto-server-0.52/etc/catalog$ touch jmx.properties ###

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

### presto 客户端 ###

下载： [http://search.maven.org/remotecontent?filepath=com/facebook/presto/presto-server/0.52/presto-server-0.52.tar.gz][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

### TEST 试试手感 ###

启动：

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][http_prestodb.io_docs_current_installation_deployment.html]

[http_search.maven.org_remotecontent_filepath_com_facebook_presto_presto-server_0.52_presto-server-0.52.tar.gz]: http://search.maven.org/remotecontent?filepath=com/facebook/presto/presto-server/0.52/presto-server-0.52.tar.gz
[http_prestodb.io_docs_current_installation_deployment.html]: http://prestodb.io/docs/current/installation/deployment.html