Ahana blog for Presto

All the latest from Ahana and the Presto community

What is an Open Data Lake in the Cloud?

Mar 16, 2022
Data-driven insights can help business and product leaders hone in on customer needs and/or find untapped opportunities. Also, analytics dashboards can be presented to customers for added value.

Best Practices for Resource Management in PrestoDB

Mar 11, 2022
Resource management in databases allows administrators to have control over resources and assign a priority to sessions, ensuring the most important transactions get the major share of system resources. Resource management in a distributed environment makes accessibility of data easier and manages resources over the network of autonomous computers (i.e. Distributed System). The basis of resource management in the distributed system is also resource sharing.

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 2022
RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x faster on Meta- scale petabyte workloads. Here at … Continue reading Configuring RaptorX – a multi-level caching with Presto

Building an Open Data Lakehouse with Presto, Hudi and AWS S3

Feb 16, 2022
The Open Data Lakehouse – a quick intro Data warehouses have been considered a standard to perform analytics on structured data but cannot handle unstructured data such as text, images, audio, … Continue reading Building an Open Data Lakehouse with Presto, Hudi and AWS S3

Benchmarking Warehouse Workloads on the Data Lake using Presto

Jan 12, 2022
How to run a TPC-H Benchmark on Presto Presto is an open source MPP Query engine designed from the ground up for high performance with linear scaling. Businesses looking to solve … Continue reading Benchmarking Warehouse Workloads on the Data Lake using Presto

Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Dec 9, 2021
We’re excited to announce that Ahana Cloud for Presto now integrates with AWS Lake Formation, including support for the recent general availability of row-level security. AWS Lake Formation is a … Continue reading Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Presto on Spark

Nov 15, 2021
Overview Presto was originally designed to run interactive queries against data warehouses, but now it has evolved into a unified SQL engine on top of open data lake analytics for … Continue reading Presto on Spark

Tutorial: How to define SQL functions with Presto across all connectors

Nov 3, 2021
Presto supports many native functions, which are usually sufficient for most use cases. To simplify this, Presto allows users to define expressions as SQL functions.

Presto 105: Running Presto with AWS Glue as catalog on your Laptop

Oct 21, 2021
Introduction This is the 5th tutorial in our Getting Started with Presto series. To recap, here are the first 4 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 105: Running Presto with AWS Glue as catalog on your Laptop

Presto 104: Running Presto with Hive Metastore on your Laptop

Oct 8, 2021
Introduction This is the 4th tutorial in our Getting Started with Presto series. To recap, here are the first 3 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 104: Running Presto with Hive Metastore on your Laptop

Connecting to Presto with Superset

Oct 5, 2021
This blog post will provide you with an understanding of how to connect Superset to Presto. TL;DR Superset refers to a connection to a distinct data source as a database. … Continue reading Connecting to Presto with Superset

Presto Tutorial 103: PrestoDB cluster on GCP

Sep 21, 2021
Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL query engine. In tutorial 102 we covered … Continue reading Presto Tutorial 103: PrestoDB cluster on GCP

Announcing the workload profile feature in Ahana Cloud

Sep 20, 2021
Ahana Cloud for Presto is the first fully integrated, cloud native managed service that simplifies the ability of cloud and data platform teams. With the managed Presto service, we provide … Continue reading Announcing the workload profile feature in Ahana Cloud

Tutorial: How to run SQL queries with Presto on Amazon Redshift

Aug 10, 2021
Presto has evolved into a unified SQL engine on top of cloud data lakes for both interactive queries as well as batch workloads with multiple data sources. This tutorial is … Continue reading Tutorial: How to run SQL queries with Presto on Amazon Redshift

Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Aug 3, 2021
I’m very excited to announce that Ahana, the SaaS for Presto company, has raised a jumbo $20M Series A round from lead investor Third Point Ventures. Our SaaS managed service … Continue reading Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Autoscale your Presto cluster in Ahana Cloud

Jul 29, 2021
We’re excited to announce that autoscaling is now available on Ahana Cloud. In this initial release, the autoscaling feature will monitor the worker nodes’ average CPU Utilization of your presto … Continue reading Autoscale your Presto cluster in Ahana Cloud

Tutorial: How to run SQL queries with Presto on Google BigQuery

Jul 20, 2021
Presto has evolved into a unified SQL engine on top of cloud data lakes for both interactive queries as well as batch workloads with multiple data sources. This tutorial is … Continue reading Tutorial: How to run SQL queries with Presto on Google BigQuery

Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

Jul 20, 2021
Since COVID, every business has pivoted and moved everything online, accelerating digital transformation with data and AI. Self-service, accelerated analytics has become more and more critical for businesses and Snowflake … Continue reading Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

Hands-on Presto Tutorial: How to run Presto on Kubernetes

Jul 12, 2021
What is Presto? Presto is a distributed query engine designed from the ground up for data lake analytics and interactive query workloads. Presto supports connectivity to a wide variety of … Continue reading Hands-on Presto Tutorial: How to run Presto on Kubernetes

Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Jul 9, 2021
Summary Prestodb is an open source distributed parallel query SQL engine. In tutorial 101 we walk through manual installation and configuration on a bare metal server or on a VM. It … Continue reading Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Enabling spill to disk for optimal price per performance

Jul 7, 2021
Presto was born out of the need for low-latency interactive queries on large scale data, and hence, continually optimized for that use case. In such scenarios, the best practice is … Continue reading Enabling spill to disk for optimal price per performance

Presto 101 Tutorial: Installing & Configuring Presto

Jun 30, 2021
Installing & Configuring Presto locally Presto Installation Presto can be installed manually or using docker images on: Single Node: Both co-ordinator and workers run on the same machine.  or even … Continue reading Presto 101 Tutorial: Installing & Configuring Presto

Why I’m betting on PrestoDB, and why you should too!

Jun 13, 2021
By Dipti Borkar, Ahana Cofounder, Chief Product Officer & Chief Evangelist I’ve been in open source software companies and communities for over 10 years now, and in the database industry … Continue reading Why I’m betting on PrestoDB, and why you should too!

5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Jun 1, 2021
In this brief post, we’ll discuss the 5 main reasons why data platform engineers decide to move their data analytics workloads from Amazon Athena to Ahana Cloud for Presto. While … Continue reading 5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Presto Foundation compared to Single Vendor-Driven Open Source Projects

Apr 1, 2021
Why Project Neutrality Matters Steven Mih, Cofounder and CEO, Ahana PrestoCon Day was last week on March 24, and it was an incredible event with lots of great speakers, great … Continue reading Presto Foundation compared to Single Vendor-Driven Open Source Projects

Upsolver and Ahana Announce Technology Partnership to Accelerate Adoption of Open Data Lake Analytics in the Cloud with Presto

Mar 16, 2021
Todd Odess, Head of Partnerships at Upsolver | Ali LeClerc, Head of Marketing at Ahana Today we’re thrilled to announce our joint technology partnership. Upsolver, the first no-code, high-speed cloud … Continue reading Upsolver and Ahana Announce Technology Partnership to Accelerate Adoption of Open Data Lake Analytics in the Cloud with Presto

Comparing AWS Athena and PrestoDB Blog Series: Athena Alternatives

Mar 9, 2021
This is the 4th blog in our comparing AWS Athena to PrestoDB series. If you missed the others, you can find them here: Part 1: AWS Athena vs. PrestoDB Blog … Continue reading Comparing AWS Athena and PrestoDB Blog Series: Athena Alternatives

Athena Partition Limits | Comparing AWS Athena & PrestoDB

Feb 24, 2021
This is our 3rd blog in the comparing AWS Athena to PrestoDB series. If you missed the first two, you can find them here: Part 1: AWS Athena vs. PrestoDB … Continue reading Athena Partition Limits | Comparing AWS Athena & PrestoDB

Athena Query Limits | Comparing AWS Athena & PrestoDB

Feb 19, 2021
Welcome to the 2nd blog in our blog series on comparing AWS Athena, a serverless Presto service, to open source PrestoDB. In this series we’ll discuss Amazon’s Athena service versus … Continue reading Athena Query Limits | Comparing AWS Athena & PrestoDB

Athena Limitations & AWS Athena Limits | Comparing AWS Athena

Feb 19, 2021
Welcome to our blog series on comparing AWS Athena, a serverless Presto service, to open source PrestoDB. In this series we’ll discuss Amazon’s Athena service versus PrestoDB and some of … Continue reading Athena Limitations & AWS Athena Limits | Comparing AWS Athena

Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Dec 9, 2020
I’m thrilled to share that today Ahana Cloud for Presto on AWS is generally available and open for Open Analytics. Ahana Cloud 🌤 is the first fully integrated, cloud-native managed … Continue reading Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

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

Oct 1, 2020
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.

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

Sep 24, 2020
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, 2020
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.

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

Jun 5, 2020
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, 2020
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.

Introducing Ahana

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