Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to install and start presto, with a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

The presto keyword catalogs data source name is customized (such as hive mysql oracle), the schemas database (similar to databases in mysql), and the tables table is consistent with other databases.

Show schemas from mysql; / / View the database under the mysql data source.

Show catalogs; / / check how many data sources there are currently.

Start up and run Presto

Start at the background:

Bin/launcher start

Or the front desk starts:

Bin/launcher run

(the output log makes it easy to view startup problems)

Stop:

Bin/launcher stop

View the process:

Jps

Output process:

137442 PrestoServer

Stop:

Bin/launcher stop

After startup, the log will be written in the / var/presto/data/var/log directory:

Launcher.log: this log file is created by launcher, and server's stdout and stderr are redirected to this log file. There will be only a small amount of information in this log file, including logs generated during server log system initialization and diagnostic and test information generated by JVM.

Server.log: this is the main log file used by Presto. In general, this file will include information about server initialization failures. This document will be automatically rotated and compressed.

Http-request.log: this is the log file for HTTP requests, including every HTTP request information received by server, which is automatically rotated and compressed.

Start the client

. / presto-- server cdh-1:8080-- catalog hive-- schema hivedemo_1

Thank you for reading this article carefully. I hope the article "how to install and start presto" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.