Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to configure FaceBook Prestodb, which is very detailed and has a certain reference value. Friends who are interested must finish it!

Install and configure wget https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.145/presto-server-0.145.tar.gztar xzvf presto-server-0.145.tar.gzcd presto-server-0.145mkdir etc

Create the following files in the etc directory

1. Node.properties2. Jvm.config3. Config.properties4. Log.properties5. The name of the Catalog Propertiesnode.propertiesnode.environment=production # environment. In the case of a cluster, each presto node name needs to be uniquely marked with a consistent node.id=ffffffff-ffff-ffff-ffff-ffffffffffff # presto node, and each node should have a different node.data-dir=/data/store/presto # data storage directory. Presto will store logs and other data here jvm.properties-server-Xmx16G-XX:+UseG1GC-XX:G1HeapRegionSize=32M-XX:+UseGCOverheadLimit-XX:+ExplicitGCInvokesConcurrent-XX:+HeapDumpOnOutOfMemoryError-XX:OnOutOfMemoryError=kill-9% pconfig.properties#cordinator minimum configuration coordinator=truenode-scheduler.include-coordinator=falsehttp-server.http.port=8080query.max-memory=50GBquery.max-memory-per-node=1GBdiscovery-server.enabled=truediscovery.uri= http://example.net:8080#worker minimum configuration coordinator=falsehttp-server.http.port=8080query.max-memory=50GBquery.max-memory-per-node=1GBdiscovery Uri = http://example.net:8080# when testing a machine as both cordinator and work, then we configure coordinator=truenode-scheduler.include-coordinator=truehttp-server.http.port=8080query.max-memory=5GBquery.max-memory-per-node=1GBdiscovery-server.enabled=truediscovery.uri= http://example.net:8080log.propertiescom.facebook.presto=INFOCatalog configuration as follows # We need to create a catalog directory under the etc directory Then create the corresponding configuration file according to the connector you want to use. # for example, if I want to use the mysql connector, I will create the mysql.properties#. Many people use the hive connector. Later, if I have a chance to share connector.name=mysqlconnection-url=jdbc:mysql://localhost:3306connection-user=rootconnection-password=secret while I am studying, what if I have more than one mysql? we will set up multiple properties files under catalog, but we need to end with .properties and have different names. # start bin/launcher start# in the background and start in the foreground. You can observe the output log bin/launcher run# to stop bin/launcher stop.

After startup, you can find the output log in the / data/store/presto directory

Command line # download wget https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.146/presto-cli-0.146-executable.jar# modification file name: prestomv presto-cli-0.146-executable.jar presto# add executable permissions chmod + x presto# execute schema depends on its own table name. / presto--server localhost:8080-- catalog mysql-- schema zhanshen above is all the content of the article "how to configure FaceBook Prestodb" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.