Ahana blog for Presto

See how Ahana and Cube work together to help you set up a Presto cluster and build a single source of truth for metrics without spending days reading cryptic docs

AWS Athena query limits cause problems, and data engineering teams spend hours diagnosing them. Learn what the limitations are and how to fix.

Learn how you can start building an Open Data Lakehouse analytics stack using Presto, Hudi and AWS S3 and solve the challenges of a data warehouse.

In this tutorial, we use a step-by-step approach so you can learn how to query redshift using SQL with Presto (running with Kubernetes).

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 BigQuery

The Open Data Lake in the cloud is the solution to the massive data problem. Many companies are adopting that architecture because of better price-performance, scale, and non-proprietary architecture.

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.

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

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

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

Overview Presto was originally designed to run interactive queries against data warehouses. However, now it has evolved into a unified SQL engine on top of open data lake analytics for … Continue reading What is Presto on Spark?

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.

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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”

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.

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.

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.

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