Presto Training & Learning Center

How do I run a CTAS (Create Table As) with a Query? There are a few different ways to run a CTAS with a Query in Presto. Below we’ll lay … Continue reading How To Run A CTAS With A Query | Create Table As Query

What is the difference between a managed table and external tables? The main difference between a managed and external table is that when you drop an external table, the underlying … Continue reading Difference Between Managed Table & External Tables | Ahana

Data Analysis Using SiSense SiSense is a full-fledged data analysis platform that provides actionable data analysis to its users for data-driven management. Being an end-to-end data analysis platform makes leveraging … Continue reading Utilizing SiSense and Presto For Distributed Data Analysis

Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and SQL tools like Mode SQL. Mode SQL In A Minute … Continue reading Collaborative Data Science Using Mode SQL And Presto

What is Presto and what are its frequently asked questions (FAQ)?

What Is Trino & FAQs Trino can query data where it is stored, without needing to move data into separate warehouse or analytics database. Queries are executed in parallel with … Continue reading What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana

Turbocharge your BI and Analytics Using Superset and Presto Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and … Continue reading Presto & Superset | Turbocharge your BI and Analytics Using Superset & Presto

Turbocharge Business Intelligence Using Redash and Presto SQL query engine Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, … Continue reading Presto SQL & Redash | Turbocharge Business Intelligence Using Redash & Presto SQL

Price-Performance Ratio of AWS Athena Presto vs Ahana Cloud for Presto Both AWS Athena and Ahana Cloud are based on the popular open-source Presto project which was originally developed by … Continue reading Price-Performance Ratio of AWS Athena Presto vs Ahana Cloud for Presto

Turbocharge Zeppelin with the lightning-fast Presto SQL query engine What is Zeppelin? Zeppelin is an open-source tool for producing data science notebooks that are then stored as .json files.  This … Continue reading Presto SQL & Zeppelin | Turbocharge Zeppelin with Presto SQL query engine

Turbocharge Trifacta with the lightning-fast Presto SQL query engine Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and … Continue reading Presto SQL & Trifacta | Turbocharge Trifacta with Presto SQL query engine

Turbocharge Tableau with the lightning-fast Presto SQL query engine Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and … Continue reading Presto SQL & Tableau | Turbocharge Tableau with Presto SQL query engine

Presto and AWS S3 What is AWS S3? Amazon Simple Storage Service (Amazon S3) is storage for the internet. Amazon S3 is used to store and retrieve any amount of … Continue reading Presto & AWS S3 | AWS S3 & Presto Support | Ahana

Presto and Amazon Redshift What is Amazon Redshift? Amazon Redshift is a cloud data warehouse application service used by data analysts or data warehouse engineers for analyzing data using standard … Continue reading Presto Vs Amazon Redshift | Redshift Vs Presto | Ahana

Turbocharge Qlik with the lightning-fast Presto SQL query engine Ahana Cloud for Presto is a SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and … Continue reading Presto SQL & Qlik | Turbocharge Qlik with Presto SQL query engine

Presto and MySQL What is MySQL? MySQL is a popular open-source relational database management system (RDBMS) that data engineers use to organize data into tables. MySQL supports foreign keys to … Continue reading Presto & MySQL | MySQL & Presto Support | Ahana

Presto and PostgreSQL What is PostgreSQL? PostgreSQL is an enterprise-grade open source database management system (DBMS) that is free and offers advanced functionality common to more expensive dbmses. It is … Continue reading Presto & PostgreSQL | PostgreSQL & Presto Support | Ahana

Turbocharge Looker with the lightning-fast Presto SQL query engine Ahana Cloud for Presto is the SaaS Managed Service which speeds up the performance of leading business intelligence, data visualization, and … Continue reading Presto SQL & Looker |Turbocharge Looker with Presto SQL query engine

Turbocharge Jupyter with the lightning-fast Presto SQL query engine What is Jupyter? Jupyter Notebook is open-source software for creating shareable documents and reports. Each such document can easily host a … Continue reading Presto SQL & Jupyter | Turbocharge Jupyter with Presto SQL query engine

Ramakrishnan brings deep SaaS and data management expertise to Presto managed service to lead engineering and technical operations San Mateo, Calif. – April 7, 2021 — Ahana, the self-service analytics … Continue reading Ahana Welcomes Satish Ramakrishnan as VP, Engineering to Senior Management Team

What are the AWS Glue partition limits and does it apply to AWS Athena? Typically you’ll use AWS Glue to create the data sources and tables that Athena will query. … Continue reading AWS Glue Partition Limits For AWS Athena | Ahana

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

In this webinar we’ll discuss two approaches: a serverless approach (AWS Athena) and a managed service approach (Ahana Cloud), along with key considerations when deciding which is right for you.

Caching advancements improve query performance up to 5x for complex workloads making Ahana the most advanced cloud service for Presto San Mateo, Calif. – March 24, 2021 — Ahana, the … Continue reading Ahana Announces New Capabilities for Its Presto Managed Service Including Data Lake Caching, Security and Seamless Operations

Popular session topics include the Presto and Apache Iceberg Connector by Twitter and the Presto, Today & Beyond panel with Ahana, Uber and Facebook San Mateo, Calif. – March 17, … Continue reading PrestoCon Day Showcases Momentum of Presto Community, Features Industry Leaders Sharing Use Cases and Best Practices

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

Presto Geospatial Functions Tutorial A question that often comes up is “how do I do geospatial queries and spatial joins in Presto?”. Fortunately Presto supports a wealth of functions and … Continue reading Presto Geospatial Functions Tutorial & Guide l Ahana

What level of concurrency performance can I expect using Presto as part of the AWS Athena service? I’m getting a lot of my workloads queued up when I use AWS … Continue reading Concurrency Performance Using Presto With AWS Athena Service | Ahana

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

How do I get deterministic performance out of Amazon Athena? What is Athena? Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data … Continue reading Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Do I have to use AWS Lambda to connect to data sources with Athena? The Athena Federated Query Journey AWS announced the public preview of Athena federated query in November … Continue reading Using AWS Lambda To Connect To Data Sources With Athena | Ahana

How do I do geospatial queries and spatial joins in Presto? A question that often comes up is “how do I do geospatial queries and spatial joins in Presto?”. Fortunately … Continue reading Geospatial Queries & Spatial Joins In Presto Guide | Ahana

How do I query JSON documents with Presto? JSON documents are a common data type. A lot of people collect logs and load them into S3. Querying JSON with Presto … Continue reading How Do I Query JSON Documents With Presto | Query JSON Docs | Ahana

Is there latency overhead for Presto queries if everything fits into memory and doesn’t need to be distributed? Presto is both in-memory and distributed, so each work has memory and … Continue reading Latency Overhead For Presto Queries If Fits Into Memory | Ahana

Is the Hive metastore a hard dependency of Presto, or could Presto be configured to use something else like Postgres? With Presto, there’s no hard dependency of having to use … Continue reading Is Hive Metastore Hard Dependency Of Presto | Postgres With Presto | Ahana

The Differences Between Apache Drill vs Presto Drill is an open source SQL query engine which began life as a paper “Dremel: Interactive Analysis of Web-Scale Datasets” from Google in … Continue reading What are the differences between Presto and Apache Drill?

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

How to Write a Python Script to Connect to a Presto Cluster If you need a quick tutorial on how to write a python script to connect to a Presto … Continue reading Python Connect to Presto | Python Script To Connect To Presto Cluster

Setting-up Presto Resource Groups Before you start allowing users on your Presto cluster it’s best practice to configure resource groups.  A resource group is a query admission control and workload … Continue reading Presto Resource Groups | Setting Up Presto Resource Group | Ahana

Why am I getting zero records when I use AWS Athena to query a CSV file? There’s a common error many AWS Athena users see when they query CSV files … Continue reading Zero Records Returned CSV | Zero Records AWS Athena | Ahana

Does Presto work natively with GraphQL? Some users may have a primary data store that is GraphQL-based (AWS AppSync) and want to leverage Presto. For context, GraphQL falls in the … Continue reading Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

How To Connect To Presto Connections to and from Presto fall into three main categories:   1) The Presto connectors that provide access to source data in various databases and file … Continue reading How To Connect To Presto | Connecting To Presto | Ahana

How To Access Presto There are several ways to access and use Presto. Here are 3 of the most common ways: Command Line Interface The Presto CLI provides a terminal-based … Continue reading How to Access Presto | Best Ways to Connect to Presto | Ahana

Machine Learning With Presto Presto is an invaluable tool for accessing and combining data, and performing feature engineering and feature extraction, in a scalable way ready for machine learning and … Continue reading Presto Machine Learning | Machine Learning With Presto | Ahana

How to Make The Presto Query Engine Run Fastest How do you make the Presto query engine run as fast as possible?  The following list of things to consider, check … Continue reading How To Make Presto Query Engine Run Fastest | Ahana

What Is A Presto Connection & How Does It Work? A Presto connection, connections to and from Presto, fall into two main categories:   1) The Presto connectors that provide access … Continue reading Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

Why does a single AWS Athena query get stuck in QUEUED state before being executed? One of the drawbacks of AWS Athena is the fact that as a user, you … Continue reading Athena Query Waiting In Queue or Athena Query Stuck In Queued State

How to Presto Data Share Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. … Continue reading How to Presto Data Share | Presto Data Sources & Usage | Ahana

Presto Performance: Speed, Optimization & Tuning Presto is an open source distributed ANSI SQL query engine for analytics. Presto supports the separation of compute and storage (i.e. it queries data … Continue reading Presto Performance | Presto Speed, Optimization & Tuning | Ahana