Install and setup

[yaom...@gmail.com]

Do I need to build from the source or the zip file is enough?

To configure a coordinator and a worker on the same local host, do I put presto under two directories with different config.properties?
The doc is not clear to me, and lack of examples for setting up connector also.

Can someone shed some light?

Thanks

[Dain Sundstrom]

We have fairly extensive installation instructions at http://prestodb.io/docs/current/installation/deployment.html

On Tuesday, November 12, 2013 2:48:16 AM UTC-8, yaom...@gmail.com wrote:

Do I need to build from the source or the zip file is enough?

You do not need to build from source.  The tarball is enough.

 

To configure a coordinator and a worker on the same local host, do I put presto under two directories with different config.properties?

In a single node setup, you only need one server.  It will perform both the coordiantor 

 

The doc is not clear to me, and lack of examples for setting up connector also.

If you let us know which sections you are having trouble with, we can work on clarifying these.

Thanks,

-dain

[Dain Sundstrom]

On Tuesday, November 12, 2013 10:21:23 AM UTC-8, Dain Sundstrom wrote:

To configure a coordinator and a worker on the same local host, do I put presto under two directories with different config.properties?

In a single node setup, you only need one server.  It will perform both the coordinator 

 Looks like my response got truncated.

With a single node, the single server will perform both the coordinator and worker roles.

[yaom...@gmail.com]

Thank you very much for your quick response. Here is the config.properties and error. Also I haven't yet setup hive and hadoop for it to point to, just want to see if server runs. Thanks.

config.properties
===========================================================
coordinator=true
datasources=jmx
http-server.http.port=8080
presto-metastore.db.type=h2
presto-metastore.db.filename=var/db/MetaStore
task.max-memory=1GB
discovery-server.enabled=true
discovery.uri=http://localhost:8080

============================================================
exception is

2013-11-11T11:11:39.582-0800 ERROR main com.facebook.presto.server.PrestoServer Guice creation errors:

1) Error: Constraint violation with property prefix '': environment is malformed (for class io.airlift.node.NodeConfig) at io.airlift.node.NodeModule.configure(NodeModule.java:34)

1 error com.google.inject.CreationException: Guice creation errors:

1) Error: Constraint violation with property prefix '': environment is malformed (for class io.airlift.node.NodeConfig) at io.airlift.node.NodeModule.configure(NodeModule.java:34)

1 error at com.google.inject.internal.Errors.throwCreationExceptionIfErrorsExist(Errors.java:435) ~[guice-3.0.jar:na] at com.google.inject.internal.InternalInjectorCreator.initializeStatically(InternalInjectorCreator.java:154) ~[guice-3.0.jar:na] at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:106) ~[guice-3.0.jar:na] at com.google.inject.Guice.createInjector(Guice.java:95) ~[guice-3.0.jar:na] at io.airlift.bootstrap.Bootstrap.initialize(Bootstrap.java:277) ~[bootstrap-0.84.jar:0.84] at com.facebook.presto.server.PrestoServer.run(PrestoServer.java:137) ~[presto-server-0.52.jar:0.52] at com.facebook.presto.server.PrestoServer.main(PrestoServer.java:50) ~[presto-server-0.52.jar:0.52]

[David Phillips]

On Tue, Nov 12, 2013 at 10:56 AM, <yaom...@gmail.com> wrote:

1) Error: Constraint violation with property prefix '': environment is malformed (for class io.airlift.node.NodeConfig) at io.airlift.node.NodeModule.configure(NodeModule.java:34)

Someone (maybe you?) asked this same question on StackOverflow yesterday. I answered it there:

  http://stackoverflow.com/a/19921351/17944

Please post the contents of your node.properties file if that doesn't solve your problem.

[David Phillips]

On Tue, Nov 12, 2013 at 10:33 AM, Dain Sundstrom <da...@iq80.com> wrote:

With a single node, the single server will perform both the coordinator and worker roles.

One thing to note when configuring a single instance to be both a coordinator and a worker (or for a small cluster with a non-dedicated coordinator) is that the "datasources" property needs to include Hive. In other words, you should combine the coordinator and worker configs and choose the "datasources" property from the worker config:

  datasources=jmx,hive

You will get a "No nodes available to run query" error when trying to query Hive data if you forget to do this.

[yaom...@gmail.com]

You nailed it. I had "-" in the name. Thanks!

[Robin Verlangen]

Thanks, this was very helpful. 

Do you think it would be helpful to add the "datasources=jmx,hive" in the configuration manual? Would have saved me a couple of hours.

Best regards, 

Robin Verlangen

Chief Data Architect

W http://www.robinverlangen.nl

E ro...@us2.nl

What is CloudPelican?

Disclaimer: The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete this message and any copies.

--
You received this message because you are subscribed to the Google Groups "Presto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to presto-users...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.