Pricing calculator

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 do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20203 min read

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

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you CROSS JOIN UNNEST a JSON array in Presto?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by using Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you CROSS JOIN UNNEST a JSON array in Presto?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Presto Guide, Documentation & Support | Learn Presto | Ahana

Oct 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 Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Oct 30, 20202 min read

Check If Map Or Presto Array Is Empty Or Contains When working with array (indexable lists) or map (key-value tuple) complex types in Presto, it is useful to be able … Continue reading Presto Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Oct 30, 20203 min read

Export Result Of Select Statement in Presto A common question is “how can I run a query and export result of select statement quickly and easily in Presto?”  You are … Continue reading Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Ahana Wins Best Big Data Startup in Fifth Annual Datanami Readers’ and Editors’ Choice Awards

Oct 22, 20204 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.

Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Oct 14, 20202 min read

Extract Keys in a Nested JSON Array Object With Presto Let’s say we have some JSON that looks like this: In this instance our json contains key value pairs. How … Continue reading Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Generate Interval from Variable Using PrestoDB | Ahana

Oct 14, 20203 min read

Generate Interval from Variable Using PrestoDB. Follow along with 3 simple examples to get up and going.

Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

Oct 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

Oct 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

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

SQL has a number of functions for dealing with null values. Not all SQL engines support all functions. Use this as a guide to check if null.

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Understand timestamp and static date in where clause. Learn how to use it with PrestoDB. Use this article as a guide to better navigate PrestoDB.

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20204 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 you find different Presto metrics for monitoring? Learn how to easily find and monitor metrics with this article.

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Looking to learn where you can find Presto Logs? Check out this quick article to learn more and get instructions.

5 reasons why you should use PrestoDB

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

Presto CLI provides a terminal-based interactive shell for running queries. Learn how to get started with it in 4 steps.

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, 20205 min read

Presto supports ANSI SQL and includes support for several SQL dialects. Learn how easy it is to convert a date string to date format.

Presto Source Code

Sep 15, 20204 min read

In this article we will discuss where to find Presto source code and how you can get started working with it. Learn how to get going with Presto

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.

Querying AWS S3 with Presto | Ahana

Jul 31, 20203 min read

Querying AWS S3 with Presto? In this guide, you’ll learn how to query AWS S3 using Presto. Learn more about how to get started.

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

Curious about Ahana? In this article you’ll earn what Ahana is, what it’s used for, and how Ahana got started.

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

How do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20203 min read

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

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you CROSS JOIN UNNEST a JSON array in Presto?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by using Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you CROSS JOIN UNNEST a JSON array in Presto?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Presto Guide, Documentation & Support | Learn Presto | Ahana

Oct 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 Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Oct 30, 20202 min read

Check If Map Or Presto Array Is Empty Or Contains When working with array (indexable lists) or map (key-value tuple) complex types in Presto, it is useful to be able … Continue reading Presto Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Oct 30, 20203 min read

Export Result Of Select Statement in Presto A common question is “how can I run a query and export result of select statement quickly and easily in Presto?”  You are … Continue reading Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Ahana Wins Best Big Data Startup in Fifth Annual Datanami Readers’ and Editors’ Choice Awards

Oct 22, 20204 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.

Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Oct 14, 20202 min read

Extract Keys in a Nested JSON Array Object With Presto Let’s say we have some JSON that looks like this: In this instance our json contains key value pairs. How … Continue reading Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Generate Interval from Variable Using PrestoDB | Ahana

Oct 14, 20203 min read

Generate Interval from Variable Using PrestoDB. Follow along with 3 simple examples to get up and going.

Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

Oct 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

Oct 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

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

SQL has a number of functions for dealing with null values. Not all SQL engines support all functions. Use this as a guide to check if null.

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Understand timestamp and static date in where clause. Learn how to use it with PrestoDB. Use this article as a guide to better navigate PrestoDB.

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20204 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 you find different Presto metrics for monitoring? Learn how to easily find and monitor metrics with this article.

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Looking to learn where you can find Presto Logs? Check out this quick article to learn more and get instructions.

5 reasons why you should use PrestoDB

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

Presto CLI provides a terminal-based interactive shell for running queries. Learn how to get started with it in 4 steps.

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, 20205 min read

Presto supports ANSI SQL and includes support for several SQL dialects. Learn how easy it is to convert a date string to date format.

Presto Source Code

Sep 15, 20204 min read

In this article we will discuss where to find Presto source code and how you can get started working with it. Learn how to get going with Presto

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.

Querying AWS S3 with Presto | Ahana

Jul 31, 20203 min read

Querying AWS S3 with Presto? In this guide, you’ll learn how to query AWS S3 using Presto. Learn more about how to get started.

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

Curious about Ahana? In this article you’ll earn what Ahana is, what it’s used for, and how Ahana got started.

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

How do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20203 min read

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

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you CROSS JOIN UNNEST a JSON array in Presto?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by using Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you CROSS JOIN UNNEST a JSON array in Presto?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Presto Guide, Documentation & Support | Learn Presto | Ahana

Oct 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 Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Oct 30, 20202 min read

Check If Map Or Presto Array Is Empty Or Contains When working with array (indexable lists) or map (key-value tuple) complex types in Presto, it is useful to be able … Continue reading Presto Map | Check If Map Or Presto Array Is Empty Or Contains | Ahana

Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Oct 30, 20203 min read

Export Result Of Select Statement in Presto A common question is “how can I run a query and export result of select statement quickly and easily in Presto?”  You are … Continue reading Export Result Of Select Statement in Presto | Presto Export to CSV | Ahana

Ahana Wins Best Big Data Startup in Fifth Annual Datanami Readers’ and Editors’ Choice Awards

Oct 22, 20204 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.

Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Oct 14, 20202 min read

Extract Keys in a Nested JSON Array Object With Presto Let’s say we have some JSON that looks like this: In this instance our json contains key value pairs. How … Continue reading Presto JSON | Extract Keys In A Nested JSON Array Object | Ahana

Generate Interval from Variable Using PrestoDB | Ahana

Oct 14, 20203 min read

Generate Interval from Variable Using PrestoDB. Follow along with 3 simple examples to get up and going.

Presto Data Sources | Cassandra Presto & Presto Accumlo | Ahana

Oct 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

Oct 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

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

SQL has a number of functions for dealing with null values. Not all SQL engines support all functions. Use this as a guide to check if null.

Static Date & Timestamp In Where Clause | PrestoDB Timestamp

Oct 3, 20202 min read

Understand timestamp and static date in where clause. Learn how to use it with PrestoDB. Use this article as a guide to better navigate PrestoDB.

Where Can I Find The Presto Server Bootstrap Logs | Ahana

Oct 3, 20204 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 you find different Presto metrics for monitoring? Learn how to easily find and monitor metrics with this article.

Where To Find Presto Logs | Presto Logs EMR | Ahana

Oct 3, 20205 min read

Looking to learn where you can find Presto Logs? Check out this quick article to learn more and get instructions.

5 reasons why you should use PrestoDB

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

Presto CLI provides a terminal-based interactive shell for running queries. Learn how to get started with it in 4 steps.

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, 20205 min read

Presto supports ANSI SQL and includes support for several SQL dialects. Learn how easy it is to convert a date string to date format.

Presto Source Code

Sep 15, 20204 min read

In this article we will discuss where to find Presto source code and how you can get started working with it. Learn how to get going with Presto

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.

Querying AWS S3 with Presto | Ahana

Jul 31, 20203 min read

Querying AWS S3 with Presto? In this guide, you’ll learn how to query AWS S3 using Presto. Learn more about how to get started.

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

Curious about Ahana? In this article you’ll earn what Ahana is, what it’s used for, and how Ahana got started.

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