How to install and start presto
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!
