Overview#

Presto#

Presto is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.

Presto is maintained by the large community of contributors and users of the Presto Software Foundation.

Starburst Enterprise Presto#

Starburst Enterprise Presto (SEP) is the commercial distribution of Presto. It is is maintained by Starburst and free to download and use. It includes additional security features, more connectors, a cost-based query optimizer, support for running additional deployment platforms and much more.

Download Starburst Enterprise Presto now!

A number of enterprise features require a license key to be enabled. For more information about obtaining and installing a license, see Starburst Enterprise Presto license.

This following feature lists are designed to help you understand the similarities and differences between open source Presto, and Starburst Enterprise Presto across several categories: platform, deployment scenarios, management, clients, security, support, and connectors.

Cloud providers#

Comparison of Presto and SEP support for cloud provider features#

Cloud provider feature

Presto

Starburst Enterprise Presto

Amazon Web Services

S3 Support

check_circle_outline

check_circle_outline

AWS Glue catalog support

check_circle_outline

check_circle_outline

Amazon Elastic Kubernetes service availability

check_circle_outline

CloudWatch Presto logs integration

check_circle_outline

CloudWatch dashboard integration

check_circle_outline

AWS Marketplace availability

check_circle_outline

Microsoft Azure

Azure data lake storage support

check_circle_outline

check_circle_outline

Azure Blob storage support

check_circle_outline

check_circle_outline

Azure Kubernetes service support

check_circle_outline

Azure Marketplace availability

check_circle_outline

Google Cloud Platform

Google Cloud storage support

check_circle_outline

check_circle_outline

Google Stackdriver integration

check_circle_outline

Google Kubernetes Engine availability

check_circle_outline

Google Cloud Marketplace availability

check_circle_outline

Red Hat Openshift

OpenShift Availability

check_circle_outline

Red Hat Marketplace Availability

check_circle_outline

Kubernetes support

Docker containers

check_circle_outline

check_circle_outline

Starburst Enterprise Presto integration on Kubernetes

check_circle_outline

Out-of-box Kubernetes configuration

check_circle_outline

Apache Ranger integration

check_circle_outline

Hive Metastore Service container

check_circle_outline

Certified for AWS EKS, GCP GKE, Microsoft Azure AKS, RedHat OpenShift

check_circle_outline

Management and administration#

Comparison of Presto and SEP support management features#

Feature

Presto

Starburst Enterprise Presto

Web UI

check_circle_outline

check_circle_outline

Monitoring with JMX

check_circle_outline

check_circle_outline

High availability

check_circle_outline

Autoscaling with graceful scaledown

check_circle_outline

Usage metrics

check_circle_outline

Connectors#

SEP contains many additional connectors, as well as improvements of Presto connectors to increase performance, add security features and others. A detailed feature comparison is available in the SEP connectors overview.

Clients#

Clients are anything that connects to Presto to enable users of that tool to run SQL queries.

For more information about connectors and related extensions, see SEP connectors overview.

Comparison of Presto and SEP clients#

Client

Presto

Starburst Enterprise Presto

Command Line Interface

check_circle_outline

check_circle_outline

Presto JDBC driver

check_circle_outline

check_circle_outline

Starburst Generic JDBC connector

check_circle_outline

Starburst ODBC driver

check_circle_outline

Starburst Power BI DirectQuery driver

check_circle_outline

Additional community clients

check_circle_outline

check_circle_outline

Security#

All security features require a license. For a full list of security documentation, see Security.

Comparison of Presto and SEP security features#

Feature

Presto

Starburst Enterprise Presto

Kerberos support

check_circle_outline

check_circle_outline

Kerberos delegation

check_circle_outline

Kerberos support with caching

check_circle_outline

LDAP authentication

check_circle_outline

check_circle_outline

Secrets

check_circle_outline

check_circle_outline

Encryption - secure internal communication

check_circle_outline

check_circle_outline

User impersonation

Hive only

check_circle_outline

Event logger

check_circle_outline

Query audit

check_circle_outline

Apache Ranger overview

  • access control for all catalogs, schemas, and tables

  • column level access control and data masking

  • row level filters

check_circle_outline

Hive access control with Apache Sentry

check_circle_outline

Okta authentication

check_circle_outline

Support#

Comparison of Presto and SEP support availability#

Feature overview

Presto

Starburst Enterprise Presto

Online community interaction

check_circle_outline

check_circle_outline

24x7 support, 365, under 30 minute SLA

check_circle_outline

Largest team of Presto experts in the World

check_circle_outline

Dedicated technical account manager

check_circle_outline

Fully tested, stable releases, curated by the Presto creators

check_circle_outline

Hot fixes and security patches

check_circle_outline

Long Term Support (LTS) releases

check_circle_outline

Short Term Support (STS) releases with newest features

check_circle_outline

Presto: The Definitive Guide#

_images/ptdg-cover.jpg

Enjoy a free copy of Presto: The Definitive Guide from Starburst to learn much more about Presto!