Resources

Presto Management Tools

Presto-Admin

Project
Presto-Admin
Maintained by
Teradata Center for Hadoop
Description
Presto-Admin is a tool for installing and managing the Presto query engine on a cluster. It provides easy-to-use commands:

  • Install and uninstall Presto across your cluster
  • Configure your Presto cluster
  • Start and stop the Presto servers
  • Gather status and log information from your Presto cluster
Examples
presto-admin server start|stop|restart|status
presto-admin server install path-to-presto-rpm
presto-admin connector add connector-name

Presto Clients and GUIs

Airpal

Project
Airpal
Maintained by
Airbnb
Description
Airpal is a web-based, query execution tool which leverages Facebook's PrestoDB to make authoring queries and retrieving results simple for users. Airpal provides the ability to find tables, see metadata, browse sample rows, write and edit queries, then submit queries all in a web interface.

Shib

Project
GitHub
Maintained by
Tagomori Satoshi
Description
Shib is a web-client written in Node.js designed to query Presto and Hive. To run Shib install node.js, alter your config.js, and follow the instructions on the shib project page. Shib can also be used as an proxy server for query engines.

yanagishima

Project
GitHub
Maintained by
wyukawa, okazou
Description
yanagishima is a web application for Presto. yanagishima provides the ability to execute query, show query, kill query, bookmark query, search table, share query/query result, format query, download as CSV/TSV file, insert chart, substitute query parameter, and so on.

Presto ODBC

Prestogres

Project
GitHub
Maintained by
Furuhashi Sadayuki
Description
Prestogres is a gateway server that allows clients to use PostgreSQL protocol and thus the PostgreSQL ODBC driver to run queries on Presto.

Presto Libraries

The following client libraries can be used to run queries from several programming languages: C, Java, Node.js, PHP, Python, R, Ruby.

Language: C

PrestoClient C

Project
GitHub
Maintained by
Ivo Herweijer
Description
C client for Presto.

Language: Java

Presto JDBC Driver

Project
Presto
Maintained by
Presto Team
Description
JDBC driver for Presto.
Example
String sql = "SELECT * FROM sys.node";
String url = "jdbc:presto://localhost:8080/catalog/schema";
try (Connection connection =
        DriverManager.getConnection(url, "test", null)) {
    try (Statement statement = connection.createStatement()) {
        try (ResultSet rs = statement.executeQuery(sql)) {
            while (rs.next()) {
                System.out.println(rs.getString("node_id"));
            }
        }
    }
}

Language: Node.js

presto-client-node

Project
GitHub
Maintained by
Satoshi Tagomori
Description
Node.js client for Presto.

Language: PHP

PhpPrestoClient

Project
GitHub
Maintained by
Xtendsys-labs
Description
PHP client for Presto.

Language: Python

PyHive

Project
GitHub
Maintained by
Dropbox
Description
PyHive is a collection of Python DB-API and SQLAlchemy interfaces for Presto and Hive.

PrestoClient Python

Project
GitHub
Maintained by
Ivo Herweijer
Description
Python client for Presto.

Language: R

RPresto

Project
GitHub
Maintained by
RPresto Team
Description
DBI-based adapter for Presto for R.

Language: Ruby

presto-client-ruby

Project
GitHub
Maintained by
Furuhashi Sadayuki
Description
Ruby client for Presto.

Presto Hosting

Qubole

Product
Presto as a Service
Description
Presto is integrated with the Qubole Data Service (QDS) platform. QDS is a web-based interface for launching Presto clusters and running queries across Presto clusters on Amazon's EC2.

Presto Connectors / Plugins

MySQL-Teradata

Project
MySQL-Teradata Plugin for Presto
Maintained by
HackShare
Description
This project isn't an install-ready plugin for MySQL-Teradata it is a fork of the entire Presto project and it contains a working MySQL-Teradata plugin. This integration was posted to the Google Group by maintainer Dheeban Govindarajan.

Presto Resources