Presto Training & Learning Center

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?

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

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

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?

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:

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 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 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

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 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

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.

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. Follow along with 3 simple examples to get up and going.

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 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 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? 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

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.

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

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

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 provides a terminal-based interactive shell for running queries. Learn how to get started with it in 4 steps.

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.

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.

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.

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.

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

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 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

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

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 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 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

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.

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.

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? In this guide, you’ll learn how to query AWS S3 using Presto. Learn more about how to get started.

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

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

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.

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.

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 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

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.

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 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

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

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