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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is Presto and How Does Presto Work?
How To Presto Escape Single Quote | Presto Escape Quote | Ahana
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is Presto and How Does Presto Work?
How To Presto Escape Single Quote | Presto Escape Quote | Ahana
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is Presto and How Does Presto Work?