Presto Training & Learning Center

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

Topics

How To Presto Escape Single Quote | Presto Escape Quote | Ahana

Oct 12, 20202 min read

How to Presto Escape a Single Quote In reality there will be some occasions when you need to use a quote character in your data, in your query, or in … Continue reading How To Presto Escape Single Quote | Presto Escape Quote | Ahana

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

Oct 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

Check If Null & Return Default (NVL analog) | Ahana

Oct 3, 20204 min read

Check if null and return default (NVL analog) SQL has a number of functions for dealing with null values, and everyone has their favorite. The complicating factor is that not … Continue reading Check If Null & Return Default (NVL analog) | Ahana

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Static date and timestamp in where clause In this post we’ll look at the static date and timestamp in where clause when it comes to Presto. Many databases automatically convert … Continue reading Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20203 min read

Where can I find the Presto Server Bootstrap logs? A common question is “where can I find the Presto server bootstrap logs?”  These are logs that indicate what is happening … Continue reading Where Can I Find The Presto Server Bootstrap Logs | Ahana

Where Can I Find Different Presto Metrics For Monitoring | Ahana

Oct 3, 20205 min read

Where can I find different Presto metrics for monitoring? If you’re wondering “Where can I find different Presto metrics for monitoring?”, we’ll help explain it. There are several ways to … Continue reading Where Can I Find Different Presto Metrics For Monitoring | Ahana

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Where to Find Presto Logs If you’re wondering “where do I find Presto logs”, we’ll help explain it. Presto needs a data directory for storing logs, etc. and it is … Continue reading Where To Find Presto Logs | Presto Logs EMR | Ahana

Presto Equivalent Of mysql group_concat | group_concat Presto

Oct 3, 20204 min read

Presto equivalent of mysql group_concat PrestoDB supports ANSI SQL and includes support for several SQL dialects, including MySQL dialect, making it easy to group and aggregate data in a variety … Continue reading Presto Equivalent Of mysql group_concat | group_concat Presto

Top 5 reasons Presto is the foundation of the data analytics stack and why you should use Presto

Oct 1, 20204 min read

Data platform teams are increasingly using the federated SQL query engine PrestoDB to run such analytics for a variety of use cases across a wide range of data lakes and databases in-place, without the need to move data. Here’s a look at some important characteristics of Presto that account for its growing adoption.

Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Sep 29, 20204 min read

How to Get the Presto CLI Tool The Presto CLI provides a terminal-based interactive shell for running queries. The CLI is a self-executing JAR file, which means it acts like … Continue reading Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Building Managed Services: Architecting Ahana Cloud for Presto with the In-VPC Deployment Model

Sep 24, 20208 min read

This blog post discusses how AWS users have evolved their big data requirements and how the Ahana team architected its managed service offering, highlighting the best practice of providing an “In-VPC” deployment.

Ahana Cloud for Presto: Analytics for Disaggregated Stack

Sep 21, 20206 min read

Today I am incredibly excited to announce Ahana Cloud for Presto, the first fully integrated, cloud-native managed service for Presto – that simplifies the ability of cloud and data platform teams of all sizes to provide self-service, SQL analytics for their data analysts and scientists.

Ahana Expands Seed Funding to $4.8 Million with Additional Funding Led by Lux Capital

Sep 21, 20205 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, today announced an additional investment of $2.3 million in seed financing led by new investor Lux Capital, along with participation from existing investor GV (formerly Google Ventures), bringing total funds raised to $4.8 million. Ahana has also expanded its technical team with three new co-founders adding top Presto and core database talent from Alibaba, Uber and Walmart, each responsible for running major Presto deployments.

Ahana Unveils First Cloud-native Managed Service for Presto on AWS

Sep 21, 20206 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, announced today its new Presto-as-a-Service offering designed to simplify the deployment, management and integration of Presto, an open source distributed SQL query engine, with data catalogs, databases and data lakes on Amazon Web Services (AWS). Ahana Cloud for Presto is the only easy-to-use, cloud-native managed service for Presto, and is deployed within the user’s AWS account, giving customers complete control and visibility of clusters and their data.

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

Sep 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

Sep 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

Sep 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

Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Sep 17, 20204 min read

How To Convert Date String to Presto Date Format PrestoDB supports ANSI SQL and includes support for several SQL dialects, so it’s straightforward to convert a date string to date … Continue reading Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Sep 15, 20204 min read

Where to Find Presto Source Code & How to Work With It The main branch: PrestoDB source code Presto is an open source project that is developed in the open … Continue reading Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

Sep 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

Sep 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

An Introduction to Presto, an Open Source Distributed SQL Engine

Aug 28, 20202 min read

In this presentation from Women in Big Data, Dipti introduces the Presto technology and shares why it’s becoming so popular for interactive ad hoc queries, reporting & dashboarding, data lake analytics, and much more.

Tech Talk: Getting Started with Presto 103

Aug 25, 20202 min read

In this tech talk, we’ll take a look at the PrestoDB architecture in more technical depth. Next, we’ll have the Presto engineers at Twitter share their PrestoDB use case and architecture which includes several large Presto clusters with over 2,000 nodes.

Tech Talk: Getting Started with Presto 102

Aug 13, 20202 min read

In this tech talk, we’ll build on what we learned in Level 101 and show you how easy it is to get started with PrestoDB. We’ll also dive deeper into key features and connectors.

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

Jul 31, 20202 min read

Querying AWS S3 with Presto If you’re looking for a query engine for AWS S3, Presto is a popular choice. Presto is an open source SQL query engine, well known … Continue reading Presto Query S3 & Presto AWS S3 | AWS Presto S3 Query | Ahana

Getting Started with Presto on AWS and Docker: Video Demo Series

Jul 30, 20202 min read

See our video demo’s on how to get up and running with Presto on AWS and Docker.

EMR Presto Optimization & Configuration | Amazon EMR Presto Versions

Jul 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

Tech Talk: Getting Started with Presto 101

Jul 28, 20202 min read

In Level 101, you’ll get an overview of Presto, including a high level overview of Presto & most common use cases, the problems it solves and why you should use it, a live, hands-on demo on getting Presto running on AWS, and how Twitter uses Presto at scale.

Virtual Roundtable – Building the Presto Open Source Community

Jul 25, 20207 min read

Join us as experts from the Presto Foundation including Uber, Facebook, Alibaba, and Ahana share their views on building an open source community behind PrestoDB.

Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Jul 23, 20204 min read

Former Splunk Fellow and Chief Architect & Teradata Fellow brings 30+ years of database expertise to lead technology innovation San Mateo, CA — July 23, 2020 – Ahana, the SQL … Continue reading Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Jun 30, 20205 min read

Ahana to provide community and commercial support for PrestoDB users  San Mateo, CA — June 30, 2020 – Ahana, the Presto-based analytics company, announced today the availability of the completely … Continue reading Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Bridging the gap to bring two Presto communities together: Welcoming Starburst Data to the Presto Foundation

Jun 5, 20203 min read

Why are there two Presto projects and how many do we need? For the benefit of the community, I hope we can see the confusion end with: 1 foundation, 1 primary code base for new development, and 1 community.

Getting Perspective on Open Source Projects and Forks with Ted Dunning, Apache Software Expert

Jun 4, 20206 min read

We spent some time with Apache Software Foundation board member, PMC member, and open source expert Ted Dunning to get his thoughts on the state of open source software.

Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Jun 2, 20206 min read

Ahana to focus on growing the Presto community to simplify ad-hoc analytics with PrestoDB federated SQL engine San Mateo, CA — June 2, 2020 – Ahana, the Presto-based analytics company, … Continue reading Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Introducing Ahana

Jun 2, 20207 min read

There are many factors that contribute to strong co-founder relationships. Forbes refers to one set and defines them as the 3Ts…

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?

We’re Hiring!

May 20, 20201 min read

We are hiring rockstars across the board! Get in touch at hello@ahana.io

How To Presto Escape Single Quote | Presto Escape Quote | Ahana

Oct 12, 20202 min read

How to Presto Escape a Single Quote In reality there will be some occasions when you need to use a quote character in your data, in your query, or in … Continue reading How To Presto Escape Single Quote | Presto Escape Quote | Ahana

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

Oct 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

Check If Null & Return Default (NVL analog) | Ahana

Oct 3, 20204 min read

Check if null and return default (NVL analog) SQL has a number of functions for dealing with null values, and everyone has their favorite. The complicating factor is that not … Continue reading Check If Null & Return Default (NVL analog) | Ahana

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Static date and timestamp in where clause In this post we’ll look at the static date and timestamp in where clause when it comes to Presto. Many databases automatically convert … Continue reading Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20203 min read

Where can I find the Presto Server Bootstrap logs? A common question is “where can I find the Presto server bootstrap logs?”  These are logs that indicate what is happening … Continue reading Where Can I Find The Presto Server Bootstrap Logs | Ahana

Where Can I Find Different Presto Metrics For Monitoring | Ahana

Oct 3, 20205 min read

Where can I find different Presto metrics for monitoring? If you’re wondering “Where can I find different Presto metrics for monitoring?”, we’ll help explain it. There are several ways to … Continue reading Where Can I Find Different Presto Metrics For Monitoring | Ahana

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Where to Find Presto Logs If you’re wondering “where do I find Presto logs”, we’ll help explain it. Presto needs a data directory for storing logs, etc. and it is … Continue reading Where To Find Presto Logs | Presto Logs EMR | Ahana

Presto Equivalent Of mysql group_concat | group_concat Presto

Oct 3, 20204 min read

Presto equivalent of mysql group_concat PrestoDB supports ANSI SQL and includes support for several SQL dialects, including MySQL dialect, making it easy to group and aggregate data in a variety … Continue reading Presto Equivalent Of mysql group_concat | group_concat Presto

Top 5 reasons Presto is the foundation of the data analytics stack and why you should use Presto

Oct 1, 20204 min read

Data platform teams are increasingly using the federated SQL query engine PrestoDB to run such analytics for a variety of use cases across a wide range of data lakes and databases in-place, without the need to move data. Here’s a look at some important characteristics of Presto that account for its growing adoption.

Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Sep 29, 20204 min read

How to Get the Presto CLI Tool The Presto CLI provides a terminal-based interactive shell for running queries. The CLI is a self-executing JAR file, which means it acts like … Continue reading Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Building Managed Services: Architecting Ahana Cloud for Presto with the In-VPC Deployment Model

Sep 24, 20208 min read

This blog post discusses how AWS users have evolved their big data requirements and how the Ahana team architected its managed service offering, highlighting the best practice of providing an “In-VPC” deployment.

Ahana Cloud for Presto: Analytics for Disaggregated Stack

Sep 21, 20206 min read

Today I am incredibly excited to announce Ahana Cloud for Presto, the first fully integrated, cloud-native managed service for Presto – that simplifies the ability of cloud and data platform teams of all sizes to provide self-service, SQL analytics for their data analysts and scientists.

Ahana Expands Seed Funding to $4.8 Million with Additional Funding Led by Lux Capital

Sep 21, 20205 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, today announced an additional investment of $2.3 million in seed financing led by new investor Lux Capital, along with participation from existing investor GV (formerly Google Ventures), bringing total funds raised to $4.8 million. Ahana has also expanded its technical team with three new co-founders adding top Presto and core database talent from Alibaba, Uber and Walmart, each responsible for running major Presto deployments.

Ahana Unveils First Cloud-native Managed Service for Presto on AWS

Sep 21, 20206 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, announced today its new Presto-as-a-Service offering designed to simplify the deployment, management and integration of Presto, an open source distributed SQL query engine, with data catalogs, databases and data lakes on Amazon Web Services (AWS). Ahana Cloud for Presto is the only easy-to-use, cloud-native managed service for Presto, and is deployed within the user’s AWS account, giving customers complete control and visibility of clusters and their data.

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

Sep 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

Sep 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

Sep 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

Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Sep 17, 20204 min read

How To Convert Date String to Presto Date Format PrestoDB supports ANSI SQL and includes support for several SQL dialects, so it’s straightforward to convert a date string to date … Continue reading Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Sep 15, 20204 min read

Where to Find Presto Source Code & How to Work With It The main branch: PrestoDB source code Presto is an open source project that is developed in the open … Continue reading Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

Sep 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

Sep 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

An Introduction to Presto, an Open Source Distributed SQL Engine

Aug 28, 20202 min read

In this presentation from Women in Big Data, Dipti introduces the Presto technology and shares why it’s becoming so popular for interactive ad hoc queries, reporting & dashboarding, data lake analytics, and much more.

Tech Talk: Getting Started with Presto 103

Aug 25, 20202 min read

In this tech talk, we’ll take a look at the PrestoDB architecture in more technical depth. Next, we’ll have the Presto engineers at Twitter share their PrestoDB use case and architecture which includes several large Presto clusters with over 2,000 nodes.

Tech Talk: Getting Started with Presto 102

Aug 13, 20202 min read

In this tech talk, we’ll build on what we learned in Level 101 and show you how easy it is to get started with PrestoDB. We’ll also dive deeper into key features and connectors.

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

Jul 31, 20202 min read

Querying AWS S3 with Presto If you’re looking for a query engine for AWS S3, Presto is a popular choice. Presto is an open source SQL query engine, well known … Continue reading Presto Query S3 & Presto AWS S3 | AWS Presto S3 Query | Ahana

Getting Started with Presto on AWS and Docker: Video Demo Series

Jul 30, 20202 min read

See our video demo’s on how to get up and running with Presto on AWS and Docker.

EMR Presto Optimization & Configuration | Amazon EMR Presto Versions

Jul 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

Tech Talk: Getting Started with Presto 101

Jul 28, 20202 min read

In Level 101, you’ll get an overview of Presto, including a high level overview of Presto & most common use cases, the problems it solves and why you should use it, a live, hands-on demo on getting Presto running on AWS, and how Twitter uses Presto at scale.

Virtual Roundtable – Building the Presto Open Source Community

Jul 25, 20207 min read

Join us as experts from the Presto Foundation including Uber, Facebook, Alibaba, and Ahana share their views on building an open source community behind PrestoDB.

Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Jul 23, 20204 min read

Former Splunk Fellow and Chief Architect & Teradata Fellow brings 30+ years of database expertise to lead technology innovation San Mateo, CA — July 23, 2020 – Ahana, the SQL … Continue reading Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Jun 30, 20205 min read

Ahana to provide community and commercial support for PrestoDB users  San Mateo, CA — June 30, 2020 – Ahana, the Presto-based analytics company, announced today the availability of the completely … Continue reading Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Bridging the gap to bring two Presto communities together: Welcoming Starburst Data to the Presto Foundation

Jun 5, 20203 min read

Why are there two Presto projects and how many do we need? For the benefit of the community, I hope we can see the confusion end with: 1 foundation, 1 primary code base for new development, and 1 community.

Getting Perspective on Open Source Projects and Forks with Ted Dunning, Apache Software Expert

Jun 4, 20206 min read

We spent some time with Apache Software Foundation board member, PMC member, and open source expert Ted Dunning to get his thoughts on the state of open source software.

Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Jun 2, 20206 min read

Ahana to focus on growing the Presto community to simplify ad-hoc analytics with PrestoDB federated SQL engine San Mateo, CA — June 2, 2020 – Ahana, the Presto-based analytics company, … Continue reading Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Introducing Ahana

Jun 2, 20207 min read

There are many factors that contribute to strong co-founder relationships. Forbes refers to one set and defines them as the 3Ts…

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?

We’re Hiring!

May 20, 20201 min read

We are hiring rockstars across the board! Get in touch at hello@ahana.io

How To Presto Escape Single Quote | Presto Escape Quote | Ahana

Oct 12, 20202 min read

How to Presto Escape a Single Quote In reality there will be some occasions when you need to use a quote character in your data, in your query, or in … Continue reading How To Presto Escape Single Quote | Presto Escape Quote | Ahana

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

Oct 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

Check If Null & Return Default (NVL analog) | Ahana

Oct 3, 20204 min read

Check if null and return default (NVL analog) SQL has a number of functions for dealing with null values, and everyone has their favorite. The complicating factor is that not … Continue reading Check If Null & Return Default (NVL analog) | Ahana

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Static date and timestamp in where clause In this post we’ll look at the static date and timestamp in where clause when it comes to Presto. Many databases automatically convert … Continue reading Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20203 min read

Where can I find the Presto Server Bootstrap logs? A common question is “where can I find the Presto server bootstrap logs?”  These are logs that indicate what is happening … Continue reading Where Can I Find The Presto Server Bootstrap Logs | Ahana

Where Can I Find Different Presto Metrics For Monitoring | Ahana

Oct 3, 20205 min read

Where can I find different Presto metrics for monitoring? If you’re wondering “Where can I find different Presto metrics for monitoring?”, we’ll help explain it. There are several ways to … Continue reading Where Can I Find Different Presto Metrics For Monitoring | Ahana

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Where to Find Presto Logs If you’re wondering “where do I find Presto logs”, we’ll help explain it. Presto needs a data directory for storing logs, etc. and it is … Continue reading Where To Find Presto Logs | Presto Logs EMR | Ahana

Presto Equivalent Of mysql group_concat | group_concat Presto

Oct 3, 20204 min read

Presto equivalent of mysql group_concat PrestoDB supports ANSI SQL and includes support for several SQL dialects, including MySQL dialect, making it easy to group and aggregate data in a variety … Continue reading Presto Equivalent Of mysql group_concat | group_concat Presto

Top 5 reasons Presto is the foundation of the data analytics stack and why you should use Presto

Oct 1, 20204 min read

Data platform teams are increasingly using the federated SQL query engine PrestoDB to run such analytics for a variety of use cases across a wide range of data lakes and databases in-place, without the need to move data. Here’s a look at some important characteristics of Presto that account for its growing adoption.

Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Sep 29, 20204 min read

How to Get the Presto CLI Tool The Presto CLI provides a terminal-based interactive shell for running queries. The CLI is a self-executing JAR file, which means it acts like … Continue reading Presto CLI Download | How to Get the Presto CLI Tool | Ahana

Building Managed Services: Architecting Ahana Cloud for Presto with the In-VPC Deployment Model

Sep 24, 20208 min read

This blog post discusses how AWS users have evolved their big data requirements and how the Ahana team architected its managed service offering, highlighting the best practice of providing an “In-VPC” deployment.

Ahana Cloud for Presto: Analytics for Disaggregated Stack

Sep 21, 20206 min read

Today I am incredibly excited to announce Ahana Cloud for Presto, the first fully integrated, cloud-native managed service for Presto – that simplifies the ability of cloud and data platform teams of all sizes to provide self-service, SQL analytics for their data analysts and scientists.

Ahana Expands Seed Funding to $4.8 Million with Additional Funding Led by Lux Capital

Sep 21, 20205 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, today announced an additional investment of $2.3 million in seed financing led by new investor Lux Capital, along with participation from existing investor GV (formerly Google Ventures), bringing total funds raised to $4.8 million. Ahana has also expanded its technical team with three new co-founders adding top Presto and core database talent from Alibaba, Uber and Walmart, each responsible for running major Presto deployments.

Ahana Unveils First Cloud-native Managed Service for Presto on AWS

Sep 21, 20206 min read

San Mateo, CA – September 21, 2020 — Ahana, the self-service analytics company for Presto, announced today its new Presto-as-a-Service offering designed to simplify the deployment, management and integration of Presto, an open source distributed SQL query engine, with data catalogs, databases and data lakes on Amazon Web Services (AWS). Ahana Cloud for Presto is the only easy-to-use, cloud-native managed service for Presto, and is deployed within the user’s AWS account, giving customers complete control and visibility of clusters and their data.

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

Sep 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

Sep 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

Sep 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

Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Sep 17, 20204 min read

How To Convert Date String to Presto Date Format PrestoDB supports ANSI SQL and includes support for several SQL dialects, so it’s straightforward to convert a date string to date … Continue reading Convert Date String to Date Format in Presto | Presto Date Function | Ahana

Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Sep 15, 20204 min read

Where to Find Presto Source Code & How to Work With It The main branch: PrestoDB source code Presto is an open source project that is developed in the open … Continue reading Where to Find Presto Source Code | PrestoDB Source Code GitHub | Ahana

Spark Streaming Alternatives | Alternatives to Using Apache Spark | Ahana

Sep 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

Sep 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

An Introduction to Presto, an Open Source Distributed SQL Engine

Aug 28, 20202 min read

In this presentation from Women in Big Data, Dipti introduces the Presto technology and shares why it’s becoming so popular for interactive ad hoc queries, reporting & dashboarding, data lake analytics, and much more.

Tech Talk: Getting Started with Presto 103

Aug 25, 20202 min read

In this tech talk, we’ll take a look at the PrestoDB architecture in more technical depth. Next, we’ll have the Presto engineers at Twitter share their PrestoDB use case and architecture which includes several large Presto clusters with over 2,000 nodes.

Tech Talk: Getting Started with Presto 102

Aug 13, 20202 min read

In this tech talk, we’ll build on what we learned in Level 101 and show you how easy it is to get started with PrestoDB. We’ll also dive deeper into key features and connectors.

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

Jul 31, 20202 min read

Querying AWS S3 with Presto If you’re looking for a query engine for AWS S3, Presto is a popular choice. Presto is an open source SQL query engine, well known … Continue reading Presto Query S3 & Presto AWS S3 | AWS Presto S3 Query | Ahana

Getting Started with Presto on AWS and Docker: Video Demo Series

Jul 30, 20202 min read

See our video demo’s on how to get up and running with Presto on AWS and Docker.

EMR Presto Optimization & Configuration | Amazon EMR Presto Versions

Jul 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

Tech Talk: Getting Started with Presto 101

Jul 28, 20202 min read

In Level 101, you’ll get an overview of Presto, including a high level overview of Presto & most common use cases, the problems it solves and why you should use it, a live, hands-on demo on getting Presto running on AWS, and how Twitter uses Presto at scale.

Virtual Roundtable – Building the Presto Open Source Community

Jul 25, 20207 min read

Join us as experts from the Presto Foundation including Uber, Facebook, Alibaba, and Ahana share their views on building an open source community behind PrestoDB.

Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Jul 23, 20204 min read

Former Splunk Fellow and Chief Architect & Teradata Fellow brings 30+ years of database expertise to lead technology innovation San Mateo, CA — July 23, 2020 – Ahana, the SQL … Continue reading Ahana Welcomes Database Pioneer David E. Simmen to Executive Team as Chief Technology Officer

Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Jun 30, 20205 min read

Ahana to provide community and commercial support for PrestoDB users  San Mateo, CA — June 30, 2020 – Ahana, the Presto-based analytics company, announced today the availability of the completely … Continue reading Ahana Announces Linux Foundation’s PrestoDB Now Available on AWS Marketplace and DockerHub

Bridging the gap to bring two Presto communities together: Welcoming Starburst Data to the Presto Foundation

Jun 5, 20203 min read

Why are there two Presto projects and how many do we need? For the benefit of the community, I hope we can see the confusion end with: 1 foundation, 1 primary code base for new development, and 1 community.

Getting Perspective on Open Source Projects and Forks with Ted Dunning, Apache Software Expert

Jun 4, 20206 min read

We spent some time with Apache Software Foundation board member, PMC member, and open source expert Ted Dunning to get his thoughts on the state of open source software.

Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Jun 2, 20206 min read

Ahana to focus on growing the Presto community to simplify ad-hoc analytics with PrestoDB federated SQL engine San Mateo, CA — June 2, 2020 – Ahana, the Presto-based analytics company, … Continue reading Ahana Raises $2.25 Million Seed Funding Led by GV and Joins Linux Foundation’s Presto Foundation

Introducing Ahana

Jun 2, 20207 min read

There are many factors that contribute to strong co-founder relationships. Forbes refers to one set and defines them as the 3Ts…

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?

We’re Hiring!

May 20, 20201 min read

We are hiring rockstars across the board! Get in touch at hello@ahana.io