Facebook Presto 0.100&0.118的安装

安装环境
centos 6.5X64
coordinator与work安装在同一台机器，该机器没有安装任何的数据库，刚开始准备测试连接mysql、iq等关系型数据库，然后再测试hive


环境准备：
jdk-8u51-linux-x64.rpm

安装：

（1）presto-server-0.118.tar.gz安装

刚开始安装的presto-server-0.118.tar.gz，具体安装方法可见https://prestodb.io/
安装完成后启动，信息如下：
[root@h182 presto-server-0.118]# bin/launcher run
2015-09-19T01:11:53.866+0800    INFO    main    io.airlift.log.Logging  Logging to stderr
2015-09-19T01:11:53.875+0800    INFO    main    Bootstrap       Loading configuration
2015-09-19T01:11:54.283+0800    INFO    main    Bootstrap       Initializing logging
。。。
2015-09-19T01:11:58.257+0800    INFO    main    Bootstrap       node.id                                                               null                              5b47019c-a05c-42a5-9f9c-f17dbe27b42a
2015-09-19T01:11:58.257+0800    INFO    main    Bootstrap       node.ip                                                               null                              null
2015-09-19T01:11:58.257+0800    INFO    main    Bootstrap       node.pool                                                             general                           general
2015-09-19T01:11:58.257+0800    INFO    main    Bootstrap
2015-09-19T01:11:58.257+0800    WARN    main    Bootstrap       UNUSED PROPERTIES
2015-09-19T01:11:58.258+0800    WARN    main    Bootstrap       task.max-memory=1GB
2015-09-19T01:11:58.258+0800    WARN    main    Bootstrap
2015-09-19T01:11:59.744+0800    ERROR   main    com.facebook.presto.server.PrestoServer Unable to create injector, see the following errors:


1) Error: Defunct property 'task.max-memory' (class [class com.facebook.presto.execution.TaskManagerConfig]) cannot be configured.
  at com.facebook.presto.server.ServerMainModule.setup(ServerMainModule.java:164)


2) Configuration property 'task.max-memory=1GB' was not used
  at io.airlift.bootstrap.Bootstrap.lambda$initialize$2(Bootstrap.java:235)


2 errors
com.google.inject.CreationException: Unable to create injector, see the following errors:


1) Error: Defunct property 'task.max-memory' (class [class com.facebook.presto.execution.TaskManagerConfig]) cannot be configured.
  at com.facebook.presto.server.ServerMainModule.setup(ServerMainModule.java:164)


2) Configuration property 'task.max-memory=1GB' was not used
  at io.airlift.bootstrap.Bootstrap.lambda$initialize$2(Bootstrap.java:235)


2 errors
        at com.google.inject.internal.Errors.throwCreationExceptionIfErrorsExist(Errors.java:448)
        at com.google.inject.internal.InternalInjectorCreator.initializeStatically(InternalInjectorCreator.java:155)
        at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:107)
        at com.google.inject.Guice.createInjector(Guice.java:96)
        at io.airlift.bootstrap.Bootstrap.initialize(Bootstrap.java:242)
        at com.facebook.presto.server.PrestoServer.run(PrestoServer.java:109)
        at com.facebook.presto.server.PrestoServer.main(PrestoServer.java:62)



出错处理：

    出错是由于过时的配置，安装包采用的是0.118，而安装步骤这对应了0.100来进行设置的，修改后正确启动

（2）presto-server-0.100.tar.gz安装

下载了presto-server-0.100.tar.gz，同样的配置文件，运行信息如下：

[root@h182 bin]# ./launcher run
2015-09-19T01:36:28.858+0800     INFO   main    io.airlift.log.Logging  Logging to stderr
2015-09-19T01:36:28.874+0800     INFO   main    Bootstrap       Loading configuration
2015-09-19T01:36:29.218+0800     INFO   main    Bootstrap       Initializing logging
。。。
2015-09-19T01:36:34.352+0800     INFO   main    org.eclipse.jetty.util.log      Logging initialized @6230ms
2015-09-19T01:36:35.237+0800     WARN   main    io.airlift.jmx.JmxAgent Cannot determine if JMX agent is already running (not an Oracle JVM?). Will try to start it manually.
2015-09-19T01:36:35.315+0800     INFO   main    io.airlift.jmx.JmxAgent JMX agent started and listening on h182:36049
2015-09-19T01:36:35.554+0800    ERROR   Discovery-0     io.airlift.discovery.client.CachingServiceSelector      Cannot connect to discovery server for refresh (collector/general): Lookup of collector failed for http://127.0.0.1:8080/v1/service/collector/general
2015-09-19T01:36:35.641+0800    ERROR   Discovery-3     io.airlift.discovery.client.CachingServiceSelector      Cannot connect to discovery server for refresh (presto/general): Lookup of presto failed for http://127.0.0.1:8080/v1/service/presto/general
2015-09-19T01:36:40.096+0800     INFO   main    org.eclipse.jetty.server.Server jetty-9.2.11.M0
。。。

2015-09-19T01:36:44.638+0800     INFO   main    com.facebook.presto.metadata.CatalogManager     -- Added catalog mysql using connector mysql --
2015-09-19T01:36:44.793+0800     INFO   main    com.facebook.presto.server.PrestoServer ======== SERVER STARTED ========


成功启动，但是有两行报错：
2015-09-19T01:36:35.554+0800    ERROR   Discovery-0     io.airlift.discovery.client.CachingServiceSelector      Cannot connect to discovery server for refresh (collector/general): Lookup of collector failed for http://127.0.0.1:8080/v1/service/collector/general
2015-09-19T01:36:35.641+0800    ERROR   Discovery-3     io.airlift.discovery.client.CachingServiceSelector      Cannot connect to discovery server for refresh (presto/general): Lookup of presto failed for http://127.0.0.1:8080/v1/service/presto/general


显示无法连接到discovery server for refresh ，通过浏览器，可以连接到http://127.0.0.1:8080/v1/service/collector/general

测试

运行cli，成功连接到mysql数据库
[root@h182 presto-server-0.100]# ./presto --server localhost:8080 --catalog mysql --schema default
presto:default>