Resources

• 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

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"));
            }
        }
    }
}

At Starburst, our team is a major contributor to the open source Presto project. We consist of many of the experts and committers who have been contributing to and advancing the Presto product over the last few years. Starburst provides an enterprise ready Presto distribution and Presto support. Starburst's distribution of Presto consists of additional tooling and configurations to make it work well in the enterprise. Further, it is rigorously tested at scale and patched as needed. And with our wide range of services, support, and training we will help you be successful in this new world of open source technologies in the enterprise.

In addition to implementing Presto internals to make it the most reliable, robust, and performant open source distributed query engine, our team at Starburst is dedicated to continually improve and add the needed features for the enterprise. Our major enterprise focus areas are ease-of-use, security, robustness, wide range of integrations, and reliable support SLAs.

Starburst Presto on AWS combines the reliable, scalable, and cost-effective cloud computing services provided by Amazon Web Services (AWS) with the power of Presto, the fastest growing distributed SQL query engine within the industry.

Through the use of Starburst’s CloudFormation template and Starburst Presto AMI, Starburst Presto on AWS enables you to run analytic SQL queries across a wide variety of data sources with elastic scaling and usage-based pricing. Read more how to use Presto on AWS on our AWS Documentation site.

Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats. Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata repository across various services, crawl data sources to discover schemas and populate your Catalog with new and modified table and partition definitions, and maintain schema versioning.

Amazon EMR provides a managed Hadoop framework that makes it easy, fast, and cost-effective to process vast amounts of data across dynamically scalable Amazon EC2 instances. With EMR, you can launch a large Presto cluster in minutes. You don't need to worry about node provisioning, cluster setup or tuning.

Using Presto on EMR provides these benefits to customers:

• Elasticity: With Amazon EMR, you can provision one, hundreds, or thousands of compute instances to process data at any scale. You can easily increase or decrease the number of instances manually or with Auto Scaling, and you only pay for what you use.
• Simple and predictable pricing: You pay a per-second rate for every second used, with a one-minute minimum charge.

Starburst Presto for HDInsight is a distributed SQL query engine that is integrated into Azure HDInsight Platform and available via the Azure Marketplace.

Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Presto and HDInsight were both designed for the separation of storage and compute which allows for flexible performance and cost. You pay only for what you use by creating clusters on demand scaling them up and down. Read more how to use Presto on Azure on our Azure Documentation site.

Integrating Presto with HDInsight provides Azure users with two new capabilities:

• A fast, scalable, interactive SQL interface to data in Azure Blob and Azure Data Lake Storage
• An easy way to integrate data with HDInsight by leveraging Presto’s vast portfolio of data connectors.