Presto Training & Learning Center

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

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

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.

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

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

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

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

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

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

What is Presto and How Does Presto Work?

We are hiring rockstars across the board! Get in touch at hello@ahana.io