Presto Training & Learning Center

The Ahana™ Learning Center covers beginner to advanced level Presto topics, questions, and answers to help you learn Presto.

Topics

Hive vs Presto vs Spark

June 30, 20213 min read

What is Apache Hive? Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive provides an SQL-like interface called … Continue reading Hive vs Presto vs Spark

Ahana Cloud for Presto Versus Amazon EMR

May 27, 20213 min read

In this brief post, we’ll discuss some of the benefits of Ahana Cloud over Amazon Elastic MapReduce (EMR). While EMR offers optionality in the number of big data compute frameworks, … Continue reading Ahana Cloud for Presto Versus Amazon EMR

Presto Geospatial Functions Tutorial & Guide l Ahana

March 12, 20214 min read

Presto Geospatial Functions Tutorial A question that often comes up is “how do I do geospatial queries and spatial joins in Presto?”. Fortunately Presto supports a wealth of functions and … Continue reading Presto Geospatial Functions Tutorial & Guide l Ahana

Python Connect to Presto | Python Script To Connect To Presto Cluster

February 11, 20213 min read

How to Write a Python Script to Connect to a Presto Cluster If you need a quick tutorial on how to write a python script to connect to a Presto … Continue reading Python Connect to Presto | Python Script To Connect To Presto Cluster

Presto Resource Groups | Setting Up Presto Resource Group | Ahana

February 4, 20216 min read

Setting-up Presto Resource Groups Before you start allowing users on your Presto cluster it’s best practice to configure resource groups.  A resource group is a query admission control and workload … Continue reading Presto Resource Groups | Setting Up Presto Resource Group | Ahana

How To Connect To Presto | Connecting To Presto | Ahana

February 2, 20213 min read

How To Connect To Presto Connections to and from Presto fall into three main categories:   1) The Presto connectors that provide access to source data in various databases and file … Continue reading How To Connect To Presto | Connecting To Presto | Ahana

How to Access Presto | Best Ways to Connect to Presto | Ahana

February 2, 20212 min read

How To Access Presto There are several ways to access and use Presto. Here are 3 of the most common ways: Command Line Interface The Presto CLI provides a terminal-based … Continue reading How to Access Presto | Best Ways to Connect to Presto | Ahana

Presto Machine Learning | Machine Learning With Presto | Ahana

February 2, 20219 min read

Machine Learning With Presto Presto is an invaluable tool for accessing and combining data, and performing feature engineering and feature extraction, in a scalable way ready for machine learning and … Continue reading Presto Machine Learning | Machine Learning With Presto | Ahana

How To Make Presto Query Engine Run Fastest | Ahana

January 28, 20216 min read

How to Make The Presto Query Engine Run Fastest How do you make the Presto query engine run as fast as possible?  The following list of things to consider, check … Continue reading How To Make Presto Query Engine Run Fastest | Ahana

Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

January 27, 20213 min read

What Is A Presto Connection & How Does It Work? A Presto connection, connections to and from Presto, fall into two main categories:   1) The Presto connectors that provide access … Continue reading Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

How to Presto Data Share | Presto Data Sources & Usage | Ahana

January 21, 20213 min read

How to Presto Data Share Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. … Continue reading How to Presto Data Share | Presto Data Sources & Usage | Ahana

Presto Performance | Presto Speed, Optimization & Tuning | Ahana

January 21, 20218 min read

Presto Performance: Speed, Optimization & Tuning Presto is an open source distributed ANSI SQL query engine for analytics. Presto supports the separation of compute and storage (i.e. it queries data … Continue reading Presto Performance | Presto Speed, Optimization & Tuning | Ahana

Presto REST API | Presto Client & REST API Examples | Ahana

January 21, 20213 min read

Presto REST API Presto’s HTTP API (Presto Rest API) is the communication protocol between server and client. It’s used to send query statements for execution on the server and to … Continue reading Presto REST API | Presto Client & REST API Examples | Ahana

Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

January 21, 20212 min read

Presto Parquet Parquet is a columnar storage format for Hadoop, supported by Presto.  Storing data as columns as opposed to rows enables Presto to fulfill queries more efficiently. By discarding … Continue reading Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Presto Speed: How Fast is Presto?

January 21, 20213 min read

Presto Speed Presto is an open source distributed ANSI SQL query engine for analytics. Presto supports the separation of compute and storage (i.e. it queries data that is stored externally … Continue reading Presto Speed: How Fast is Presto?

Presto Tools & Presto Tool | Key Presto Libraries | Ahana

January 21, 20212 min read

Presto Tools Several tools  and libraries are available, some are bundled with core Presto and others are downloadable extras. See the documentation Resources page at  https://prestodb.io/resources.html for details.  Core Presto … Continue reading Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Presto Documentation & Presto Docs

January 21, 20212 min read

Presto Documentation Presto’s documentation is maintained by the Presto Foundation and the current version is available here: https://prestodb.io/docs/current/  Releases can be found at: https://github.com/prestodb and the Release Notes are at: … Continue reading Presto Documentation & Presto Docs

Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

January 21, 20212 min read

Presto Query Example Since Presto is an ANSI SQL query engine, its SQL will be very familiar to practically anyone who has used a database, despite the fact Presto is … Continue reading Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Presto Best Practices | What Are The Best Practices for Presto | Ahana

January 21, 20216 min read

Presto Best Practices We’ve put together a list of Presto best practices, based on our experience. We hope you find these helpful. Configure Presto’s coordinator and workers to run on … Continue reading Presto Best Practices | What Are The Best Practices for Presto | Ahana

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

November 12, 20202 min read

Presto Architecture and Design The Presto architecture and design seamlessly integrates with an existing data ecosystem without needing to modify it. It’s an additional faster data access interface that turbocharges … Continue reading Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Presto Guide, Documentation & Support | Learn Presto | Ahana

October 30, 20202 min read

Presto Guide, Documentation & Support Presto is a fast, flexible distributed SQL engine created and used by Facebook at scale. O’Reilly’s Learning and Operating Presto ebook is an approachable guide … Continue reading Presto Guide, Documentation & Support | Learn Presto | Ahana

Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

October 12, 20202 min read

Presto Data Sources Presto was designed and written from the ground up to efficiently query data against data sources of all sizes, ranging from gigabytes to petabytes. Presto connects to … Continue reading Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

Presto Server Types | Presto Server | Ahana

October 12, 20202 min read

Presto Server Types When it comes to Presto Server Types, Coordinators and workers are the two types of Presto servers. Here’s a look at each server type in more detail. … Continue reading Presto Server Types | Presto Server | Ahana

Is Presto Free | Sign Up For Presto Free | Presto Open source

October 3, 20201 min read

Is Presto Free? Many folks may wonder “is Presto free”? In fact, PrestoDB is a free, open source federated, distributed SQL query engine used for ad hoc analytics. The PrestoDB … Continue reading Is Presto Free | Sign Up For Presto Free | Presto Open source

EMR Cluster with Spark vs Presto | Presto Elasticsearch & HBase | Ahana

September 20, 20204 min read

Presto vs Spark With EMR Cluster Amazon EMR is a managed cluster platform that simplifies running big data frameworks, such as Apache Hadoop and Apache Spark, solely on AWS. An … Continue reading EMR Cluster with Spark vs Presto | Presto Elasticsearch & HBase | Ahana

Presto vs Spark SQL | Compare Spark SQL & Presto | Ahana

September 20, 20202 min read

Spark SQL vs Presto In this article we’ve tried to lay out the comparisons of Spark SQL vs Presto. When it comes to checking out Spark Presto, there are some … Continue reading Presto vs Spark SQL | Compare Spark SQL & Presto | Ahana

Presto Catalogs & Presto Use Catalogs | Data Catalog Connector | Ahana

September 20, 20202 min read

Presto Catalogs Presto has several important components that allow you to easily manage data. These components are catalogs, tables and schemas, and connectors. Presto accesses data via connectors; each data … Continue reading Presto Catalogs & Presto Use Catalogs | Data Catalog Connector | Ahana

Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

September 15, 20203 min read

Spark Streaming Alternatives When researching Spark alternatives it really depends on your use case. Are you processing streaming data or batch data? Do you prefer an open or closed source/proprietary … Continue reading Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

Presto Engine & Database | Presto Query Execution Model | Ahana

September 15, 20204 min read

Presto Engine and Database Explained What is Presto? PrestoDB is an open-source distributed SQL query engine for running interactive analytic queries against all types of data sources. It enables self-service … Continue reading Presto Engine & Database | Presto Query Execution Model | Ahana

Presto Query S3 & Presto AWS S3 | AWS Presto S3 Query | Ahana

July 31, 20202 min read

Querying AWS S3 with Presto In AWS, query S3 data with a technology like open source Presto. While users may think of S3 buckets as a datasource for the Presto … Continue reading Presto Query S3 & Presto AWS S3 | AWS Presto S3 Query | Ahana

EMR Presto Optimization & Configuration | Amazon EMR Presto Versions

July 29, 20204 min read

Optimize Presto on Amazon EMR What is Amazon EMR? Amazon Elastic MapReduce (EMR) simplifies running big data and analytics frameworks like Presto for scalable compute in the cloud. It provides … Continue reading EMR Presto Optimization & Configuration | Amazon EMR Presto Versions

Hadoop Presto | Using Presto With Hadoop Interactive Queries | Ahana

May 30, 20202 min read

Using Presto with Hadoop How does Presto work with Hadoop? What is Presto Hadoop? You use Presto to run interactive queries on Hadoop. The difference between using Presto versus something … Continue reading Hadoop Presto | Using Presto With Hadoop Interactive Queries | Ahana

Presto on AWS | Run Presto on AWS Athena & EMR | AWS Presto Tutorial

May 30, 20202 min read

Presto on AWS Presto and AWS Presto is an open-source distributed SQL query engine for running interactive analytic queries against all types of data sources. It enables self-service ad-hoc analytics … Continue reading Presto on AWS | Run Presto on AWS Athena & EMR | AWS Presto Tutorial

How Does Presto Work? | Presto Caching, Data Sources & Interner Usage Intro

May 30, 20204 min read

What is Presto and How Does Presto Work?

Presto REST API | Presto Client & REST API Examples | Ahana

January 21, 20213 min read

Presto REST API Presto’s HTTP API (Presto Rest API) is the communication protocol between server and client. It’s used to send query statements for execution on the server and to … Continue reading Presto REST API | Presto Client & REST API Examples | Ahana

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

November 12, 20202 min read

Presto Architecture and Design The Presto architecture and design seamlessly integrates with an existing data ecosystem without needing to modify it. It’s an additional faster data access interface that turbocharges … Continue reading Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

October 12, 20202 min read

Presto Data Sources Presto was designed and written from the ground up to efficiently query data against data sources of all sizes, ranging from gigabytes to petabytes. Presto connects to … Continue reading Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

Presto Server Types | Presto Server | Ahana

October 12, 20202 min read

Presto Server Types When it comes to Presto Server Types, Coordinators and workers are the two types of Presto servers. Here’s a look at each server type in more detail. … Continue reading Presto Server Types | Presto Server | Ahana

Is Presto Free | Sign Up For Presto Free | Presto Open source

October 3, 20201 min read

Is Presto Free? Many folks may wonder “is Presto free”? In fact, PrestoDB is a free, open source federated, distributed SQL query engine used for ad hoc analytics. The PrestoDB … Continue reading Is Presto Free | Sign Up For Presto Free | Presto Open source

Presto Catalogs & Presto Use Catalogs | Data Catalog Connector | Ahana

September 20, 20202 min read

Presto Catalogs Presto has several important components that allow you to easily manage data. These components are catalogs, tables and schemas, and connectors. Presto accesses data via connectors; each data … Continue reading Presto Catalogs & Presto Use Catalogs | Data Catalog Connector | Ahana

Hive vs Presto vs Spark

June 30, 20213 min read

What is Apache Hive? Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive provides an SQL-like interface called … Continue reading Hive vs Presto vs Spark

Ahana Cloud for Presto Versus Amazon EMR

May 27, 20213 min read

In this brief post, we’ll discuss some of the benefits of Ahana Cloud over Amazon Elastic MapReduce (EMR). While EMR offers optionality in the number of big data compute frameworks, … Continue reading Ahana Cloud for Presto Versus Amazon EMR

EMR Cluster with Spark vs Presto | Presto Elasticsearch & HBase | Ahana

September 20, 20204 min read

Presto vs Spark With EMR Cluster Amazon EMR is a managed cluster platform that simplifies running big data frameworks, such as Apache Hadoop and Apache Spark, solely on AWS. An … Continue reading EMR Cluster with Spark vs Presto | Presto Elasticsearch & HBase | Ahana

Presto vs Spark SQL | Compare Spark SQL & Presto | Ahana

September 20, 20202 min read

Spark SQL vs Presto In this article we’ve tried to lay out the comparisons of Spark SQL vs Presto. When it comes to checking out Spark Presto, there are some … Continue reading Presto vs Spark SQL | Compare Spark SQL & Presto | Ahana

Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

September 15, 20203 min read

Spark Streaming Alternatives When researching Spark alternatives it really depends on your use case. Are you processing streaming data or batch data? Do you prefer an open or closed source/proprietary … Continue reading Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana