Presto Learning Center

The Ahana Learning Center covers beginner to advanced level Presto topics, questions, and answers

Topics

Presto Data Sources

October 12, 20201 min read

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 a wide variety … Continue reading Presto Data Sources

Presto Server Types

October 12, 20202 min read

Coordinators and workers are the two types of Presto servers. Here’s a look at each server type in more detail. A Presto coordinator parses statements, plans queries, and manages Presto … Continue reading Presto Server Types

Is Presto Free?

October 3, 20201 min read

PrestoDB is a free, open source federated, distributed SQL query engine used for ad hoc analytics. The PrestoDB AMI is 100% open source and available for use in production immediately. … Continue reading Is Presto Free?

EMR Cluster with Spark vs Presto | Presto vs Spark | 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 vs Spark | Ahana

Spark SQL vs Presto | Presto vs Spark SQL Comparison | Ahana

September 20, 20202 min read

Spark SQL vs Presto When it comes to comparing Spark SQL vs Presto there are some differences to be aware of:  Commonality:  They are both open source, “big data” software … Continue reading Spark SQL vs Presto | Presto vs Spark SQL Comparison | Ahana

Presto Catalogs & Presto Use Catalogs For Data Management | 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 For Data Management | Ahana

Spark Streaming Alternatives | Alternative To Spark Streaming

September 15, 20202 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 | Alternative To Spark Streaming

Presto Database & Engine | Presto SQL & Query Engine | Ahana

September 15, 20204 min read

Presto Database & Engine 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 Database & Engine | Presto SQL & Query Engine | Ahana

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

July 31, 20202 min read

Querying AWS Presto S3 data While users may think of S3 buckets as a datasource for the Presto query engine, from a Presto perspective, file systems and object stores are … Continue reading Presto Query S3 & Presto AWS S3 | AWS Presto S3 | Ahana

EMR Presto Optimization & Versions | Presto EMR | Ahana

July 29, 20203 min read

Optimize Presto 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 on-demand, scalable … Continue reading EMR Presto Optimization & Versions | Presto EMR | Ahana

Hadoop Presto | Using Presto With Hadoop Interactive Queries | Ahana

May 30, 20202 min read

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

Presto on AWS | How To Run Presto On AWS Athena & EMR | Ahana

May 30, 20201 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 | How To Run Presto On AWS Athena & EMR | Ahana

What is Presto | Presto Caching, Data Sources & Server Types Intro

May 30, 20204 min read

What Is Presto? An Introduction To Presto What is Presto? PrestoDB is an open-source distributed SQL query engine for running interactive analytic queries against all types of data sources. It … Continue reading What is Presto | Presto Caching, Data Sources & Server Types Intro

Presto Data Sources

October 12, 20201 min read

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 a wide variety … Continue reading Presto Data Sources

Presto Server Types

October 12, 20202 min read

Coordinators and workers are the two types of Presto servers. Here’s a look at each server type in more detail. A Presto coordinator parses statements, plans queries, and manages Presto … Continue reading Presto Server Types

Is Presto Free?

October 3, 20201 min read

PrestoDB is a free, open source federated, distributed SQL query engine used for ad hoc analytics. The PrestoDB AMI is 100% open source and available for use in production immediately. … Continue reading Is Presto Free?

Presto Catalogs & Presto Use Catalogs For Data Management | 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 For Data Management | Ahana

EMR Cluster with Spark vs Presto | Presto vs Spark | 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 vs Spark | Ahana

Spark SQL vs Presto | Presto vs Spark SQL Comparison | Ahana

September 20, 20202 min read

Spark SQL vs Presto When it comes to comparing Spark SQL vs Presto there are some differences to be aware of:  Commonality:  They are both open source, “big data” software … Continue reading Spark SQL vs Presto | Presto vs Spark SQL Comparison | Ahana

Spark Streaming Alternatives | Alternative To Spark Streaming

September 15, 20202 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 | Alternative To Spark Streaming