# presto

**Repository Path**: zoujgitee/presto

## Basic Information

- **Project Name**: presto
- **Description**: Home of the community managed version of Presto, the distributed SQL query engine for big data, under the auspices of the Presto Software Foundation.
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2020-11-08
- **Last Updated**: 2021-08-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

<p align="center">
    <img alt="Presto Logo" src="presto-docs/src/main/resources/logo/web/main/white/Presto_Logo_WhiteBG-01.png" width="25%" />
</p>
<p align="center">Presto is a distributed SQL query engine for big data.</p>
<p align="center">See the <a href="https://prestosql.io/docs/current/">User Manual</a> for deployment instructions and end user documentation.</p>
<p align="center">
   <a href="https://prestosql.io/download.html">
       <img src="https://img.shields.io/maven-central/v/io.prestosql/presto-server.svg?label=Download" alt="Maven Central" />
   </a>
   <a href="https://prestosql.io/slack.html">
       <img src="https://img.shields.io/static/v1?logo=slack&logoColor=959DA5&label=Slack&labelColor=333a41&message=join%20conversation&color=3AC358" alt="Presto Slack" />
   </a>
   <a href="https://www.starburstdata.com/oreilly-presto-guide-download">
       <img src="https://img.shields.io/badge/Presto%3A%20The%20Definitive%20Guide-download-brightgreen" alt="Presto: The Definitive Guide book download" />
   </a>
</p>

## Build requirements

* Mac OS X or Linux
* Java 11.0.8, 64-bit
* Python 2.6+ (for running with the launcher script)
* Docker

## Building Presto

Presto is a standard Maven project. Simply run the following command from the
project root directory:

    ./mvnw clean install

On the first build, Maven downloads all the dependencies from the internet
and caches them in the local repository (`~/.m2/repository`), which can take a
considerable amount of time. Subsequent builds are faster.

Presto has a comprehensive set of unit tests that can also take a considerable
amount of time to run. You can disable the tests when building:

    ./mvnw clean install -DskipTests

## Running Presto in your IDE

### Overview

After building Presto for the first time, you can load the project into your IDE
and run the server. We recommend using [IntelliJ
IDEA](http://www.jetbrains.com/idea/). Because Presto is a standard Maven
project, you can import it into your IDE using the root `pom.xml` file. In
IntelliJ, choose Open Project from the Quick Start box or choose Open from the
File menu and select the root `pom.xml` file.

After opening the project in IntelliJ, double check that the Java SDK is
properly configured for the project:

* Open the File menu and select Project Structure
* In the SDKs section, ensure that JDK 11 is selected (create one if none exist)
* In the Project section, ensure the Project language level is set to 8 (Presto
  does not yet use Java 11 language features)

Presto comes with sample configuration that should work out-of-the-box for
development. Use the following options to create a run configuration:

* Main Class: `io.prestosql.server.PrestoServer`
* VM Options: `-ea -XX:+UseG1GC -XX:G1HeapRegionSize=32M -XX:+UseGCOverheadLimit -XX:+ExplicitGCInvokesConcurrent -Xmx2G -Dconfig=etc/config.properties -Dlog.levels-file=etc/log.properties -Djdk.attach.allowAttachSelf=true`
* Working directory: `$MODULE_DIR$`
* Use classpath of module: `presto-server-main`

The working directory should be the `presto-server-main` subdirectory. In
IntelliJ, using `$MODULE_DIR$` accomplishes this automatically.

Additionally, the Hive plugin must be configured with the location of your Hive
metastore Thrift service. Add the following to the list of VM options, replacing
`localhost:9083` with the correct host and port (or use the below value if you
do not have a Hive metastore):

    -Dhive.metastore.uri=thrift://localhost:9083

### Using SOCKS for Hive or HDFS

If your Hive metastore or HDFS cluster is not directly accessible to your local
machine, you can use SSH port forwarding to access it. Setup a dynamic SOCKS
proxy with SSH listening on local port 1080:

    ssh -v -N -D 1080 server

Then add the following to the list of VM options:

    -Dhive.metastore.thrift.client.socks-proxy=localhost:1080
    -Dhive.hdfs.socks-proxy=localhost:1080

### Running the CLI

Start the CLI to connect to the server and run SQL queries:

    presto-cli/target/presto-cli-*-executable.jar

Run a query to see the nodes in the cluster:

    SELECT * FROM system.runtime.nodes;

In the sample configuration, the Hive connector is mounted in the `hive`
catalog, so you can run the following queries to show the tables in the Hive
database `default`:

    SHOW TABLES FROM hive.default;

## Development

See [DEVELOPMENT](./DEVELOPMENT.md) for information about code style,
development process & guidelines.