Presto Training & Learning Center

The Ahana™ Learning Center covers beginner to advanced level Presto topics, questions, and answers to help you learn Presto.

Topics

How To Run A CTAS With A Query | Create Table As Query

May 4, 20212 min read

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

Difference Between Managed Table & External Tables | Ahana

May 4, 20212 min read

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

Utilizing SiSense and Presto For Distributed Data Analysis

Apr 30, 20213 min read

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

Collaborative Data Science Using Mode SQL And Presto

Apr 30, 20213 min read

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 & Presto FAQ | Presto Help & Support | Ahana

Apr 27, 20219 min read

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

What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana

Apr 22, 20218 min read

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

Presto & Superset | Turbocharge your BI and Analytics Using Superset & Presto

Apr 21, 20214 min read

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

Presto SQL & Redash | Turbocharge Business Intelligence Using Redash & Presto SQL

Apr 21, 20215 min read

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

Apr 13, 20214 min read

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

Presto SQL & Zeppelin | Turbocharge Zeppelin with Presto SQL query engine

Apr 12, 20213 min read

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

Presto SQL & Trifacta | Turbocharge Trifacta with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Tableau | Turbocharge Tableau with Presto SQL query engine

Apr 12, 20215 min read

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 & AWS S3 | AWS S3 & Presto Support | Ahana

Apr 12, 20213 min read

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 Vs Amazon Redshift | Redshift Vs Presto | Ahana

Apr 12, 20213 min read

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

Presto SQL & Qlik | Turbocharge Qlik with Presto SQL query engine

Apr 12, 20215 min read

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 & MySQL | MySQL & Presto Support | Ahana

Apr 12, 20214 min read

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 & PostgreSQL | PostgreSQL & Presto Support | Ahana

Apr 12, 20214 min read

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

Presto SQL & Looker |Turbocharge Looker with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Jupyter | Turbocharge Jupyter with Presto SQL query engine

Apr 12, 20213 min read

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

Ahana Welcomes Satish Ramakrishnan as VP, Engineering to Senior Management Team

Apr 7, 20214 min read

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

AWS Glue Partition Limits For AWS Athena | Ahana

Apr 1, 20212 min read

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

Presto Foundation compared to Single Vendor-Driven Open Source Projects

Apr 1, 20214 min read

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

AWS Athena vs. Ahana Cloud for Presto

Mar 30, 20211 min read

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.

Ahana Announces New Capabilities for Its Presto Managed Service Including Data Lake Caching, Security and Seamless Operations

Mar 24, 20217 min read

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

PrestoCon Day Showcases Momentum of Presto Community, Features Industry Leaders Sharing Use Cases and Best Practices

Mar 17, 20214 min read

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

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

Mar 16, 20214 min read

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 & Guide l Ahana

Mar 12, 20214 min read

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

Concurrency Performance Using Presto With AWS Athena Service | Ahana

Mar 9, 20213 min read

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

Comparing AWS Athena and PrestoDB Blog Series: Athena Alternatives

Mar 9, 20217 min read

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20215 min read

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

Using AWS Lambda To Connect To Data Sources With Athena | Ahana

Mar 5, 20213 min read

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

Geospatial Queries & Spatial Joins In Presto Guide | Ahana

Mar 4, 20214 min read

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 | Query JSON Docs | Ahana

Mar 3, 20213 min read

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

Latency Overhead For Presto Queries If Fits Into Memory | Ahana

Mar 1, 20212 min read

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 Hive Metastore Hard Dependency Of Presto | Postgres With Presto | Ahana

Mar 1, 20211 min read

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

What are the differences between Presto and Apache Drill?

Mar 1, 20213 min read

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?

Athena Partition Limits | Comparing AWS Athena & PrestoDB

Feb 24, 20215 min read

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, 20214 min read

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

Python Connect to Presto | Python Script To Connect To Presto Cluster

Feb 11, 20213 min read

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

Presto Resource Groups | Setting Up Presto Resource Group | Ahana

Feb 4, 20216 min read

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

Zero Records Returned CSV | Zero Records AWS Athena | Ahana

Feb 3, 20212 min read

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

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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 | Connecting To Presto | Ahana

Feb 2, 20213 min read

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 | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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 Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

Jan 27, 20213 min read

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

Athena Query Waiting In Queue or Athena Query Stuck In Queued State

Jan 26, 20212 min read

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 Data Sources & Usage | Ahana

Jan 21, 20213 min read

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 | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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

How To Run A CTAS With A Query | Create Table As Query

May 4, 20212 min read

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

Difference Between Managed Table & External Tables | Ahana

May 4, 20212 min read

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

Utilizing SiSense and Presto For Distributed Data Analysis

Apr 30, 20213 min read

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

Collaborative Data Science Using Mode SQL And Presto

Apr 30, 20213 min read

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 & Presto FAQ | Presto Help & Support | Ahana

Apr 27, 20219 min read

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

What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana

Apr 22, 20218 min read

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

Presto & Superset | Turbocharge your BI and Analytics Using Superset & Presto

Apr 21, 20214 min read

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

Presto SQL & Redash | Turbocharge Business Intelligence Using Redash & Presto SQL

Apr 21, 20215 min read

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

Apr 13, 20214 min read

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

Presto SQL & Zeppelin | Turbocharge Zeppelin with Presto SQL query engine

Apr 12, 20213 min read

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

Presto SQL & Trifacta | Turbocharge Trifacta with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Tableau | Turbocharge Tableau with Presto SQL query engine

Apr 12, 20215 min read

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 & AWS S3 | AWS S3 & Presto Support | Ahana

Apr 12, 20213 min read

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 Vs Amazon Redshift | Redshift Vs Presto | Ahana

Apr 12, 20213 min read

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

Presto SQL & Qlik | Turbocharge Qlik with Presto SQL query engine

Apr 12, 20215 min read

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 & MySQL | MySQL & Presto Support | Ahana

Apr 12, 20214 min read

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 & PostgreSQL | PostgreSQL & Presto Support | Ahana

Apr 12, 20214 min read

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

Presto SQL & Looker |Turbocharge Looker with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Jupyter | Turbocharge Jupyter with Presto SQL query engine

Apr 12, 20213 min read

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

Ahana Welcomes Satish Ramakrishnan as VP, Engineering to Senior Management Team

Apr 7, 20214 min read

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

AWS Glue Partition Limits For AWS Athena | Ahana

Apr 1, 20212 min read

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

Presto Foundation compared to Single Vendor-Driven Open Source Projects

Apr 1, 20214 min read

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

AWS Athena vs. Ahana Cloud for Presto

Mar 30, 20211 min read

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.

Ahana Announces New Capabilities for Its Presto Managed Service Including Data Lake Caching, Security and Seamless Operations

Mar 24, 20217 min read

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

PrestoCon Day Showcases Momentum of Presto Community, Features Industry Leaders Sharing Use Cases and Best Practices

Mar 17, 20214 min read

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

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

Mar 16, 20214 min read

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 & Guide l Ahana

Mar 12, 20214 min read

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

Concurrency Performance Using Presto With AWS Athena Service | Ahana

Mar 9, 20213 min read

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

Comparing AWS Athena and PrestoDB Blog Series: Athena Alternatives

Mar 9, 20217 min read

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20215 min read

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

Using AWS Lambda To Connect To Data Sources With Athena | Ahana

Mar 5, 20213 min read

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

Geospatial Queries & Spatial Joins In Presto Guide | Ahana

Mar 4, 20214 min read

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 | Query JSON Docs | Ahana

Mar 3, 20213 min read

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

Latency Overhead For Presto Queries If Fits Into Memory | Ahana

Mar 1, 20212 min read

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 Hive Metastore Hard Dependency Of Presto | Postgres With Presto | Ahana

Mar 1, 20211 min read

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

What are the differences between Presto and Apache Drill?

Mar 1, 20213 min read

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?

Athena Partition Limits | Comparing AWS Athena & PrestoDB

Feb 24, 20215 min read

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, 20214 min read

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

Python Connect to Presto | Python Script To Connect To Presto Cluster

Feb 11, 20213 min read

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

Presto Resource Groups | Setting Up Presto Resource Group | Ahana

Feb 4, 20216 min read

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

Zero Records Returned CSV | Zero Records AWS Athena | Ahana

Feb 3, 20212 min read

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

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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 | Connecting To Presto | Ahana

Feb 2, 20213 min read

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 | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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 Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

Jan 27, 20213 min read

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

Athena Query Waiting In Queue or Athena Query Stuck In Queued State

Jan 26, 20212 min read

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 Data Sources & Usage | Ahana

Jan 21, 20213 min read

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 | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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

How To Run A CTAS With A Query | Create Table As Query

May 4, 20212 min read

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

Difference Between Managed Table & External Tables | Ahana

May 4, 20212 min read

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

Utilizing SiSense and Presto For Distributed Data Analysis

Apr 30, 20213 min read

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

Collaborative Data Science Using Mode SQL And Presto

Apr 30, 20213 min read

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 & Presto FAQ | Presto Help & Support | Ahana

Apr 27, 20219 min read

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

What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana

Apr 22, 20218 min read

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

Presto & Superset | Turbocharge your BI and Analytics Using Superset & Presto

Apr 21, 20214 min read

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

Presto SQL & Redash | Turbocharge Business Intelligence Using Redash & Presto SQL

Apr 21, 20215 min read

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

Apr 13, 20214 min read

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

Presto SQL & Zeppelin | Turbocharge Zeppelin with Presto SQL query engine

Apr 12, 20213 min read

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

Presto SQL & Trifacta | Turbocharge Trifacta with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Tableau | Turbocharge Tableau with Presto SQL query engine

Apr 12, 20215 min read

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 & AWS S3 | AWS S3 & Presto Support | Ahana

Apr 12, 20213 min read

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 Vs Amazon Redshift | Redshift Vs Presto | Ahana

Apr 12, 20213 min read

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

Presto SQL & Qlik | Turbocharge Qlik with Presto SQL query engine

Apr 12, 20215 min read

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 & MySQL | MySQL & Presto Support | Ahana

Apr 12, 20214 min read

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 & PostgreSQL | PostgreSQL & Presto Support | Ahana

Apr 12, 20214 min read

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

Presto SQL & Looker |Turbocharge Looker with Presto SQL query engine

Apr 12, 20214 min read

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

Presto SQL & Jupyter | Turbocharge Jupyter with Presto SQL query engine

Apr 12, 20213 min read

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

Ahana Welcomes Satish Ramakrishnan as VP, Engineering to Senior Management Team

Apr 7, 20214 min read

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

AWS Glue Partition Limits For AWS Athena | Ahana

Apr 1, 20212 min read

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

Presto Foundation compared to Single Vendor-Driven Open Source Projects

Apr 1, 20214 min read

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

AWS Athena vs. Ahana Cloud for Presto

Mar 30, 20211 min read

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.

Ahana Announces New Capabilities for Its Presto Managed Service Including Data Lake Caching, Security and Seamless Operations

Mar 24, 20217 min read

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

PrestoCon Day Showcases Momentum of Presto Community, Features Industry Leaders Sharing Use Cases and Best Practices

Mar 17, 20214 min read

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

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

Mar 16, 20214 min read

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 & Guide l Ahana

Mar 12, 20214 min read

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

Concurrency Performance Using Presto With AWS Athena Service | Ahana

Mar 9, 20213 min read

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

Comparing AWS Athena and PrestoDB Blog Series: Athena Alternatives

Mar 9, 20217 min read

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20215 min read

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

Using AWS Lambda To Connect To Data Sources With Athena | Ahana

Mar 5, 20213 min read

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

Geospatial Queries & Spatial Joins In Presto Guide | Ahana

Mar 4, 20214 min read

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 | Query JSON Docs | Ahana

Mar 3, 20213 min read

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

Latency Overhead For Presto Queries If Fits Into Memory | Ahana

Mar 1, 20212 min read

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 Hive Metastore Hard Dependency Of Presto | Postgres With Presto | Ahana

Mar 1, 20211 min read

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

What are the differences between Presto and Apache Drill?

Mar 1, 20213 min read

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?

Athena Partition Limits | Comparing AWS Athena & PrestoDB

Feb 24, 20215 min read

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, 20214 min read

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

Python Connect to Presto | Python Script To Connect To Presto Cluster

Feb 11, 20213 min read

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

Presto Resource Groups | Setting Up Presto Resource Group | Ahana

Feb 4, 20216 min read

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

Zero Records Returned CSV | Zero Records AWS Athena | Ahana

Feb 3, 20212 min read

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

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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 | Connecting To Presto | Ahana

Feb 2, 20213 min read

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 | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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 Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

Presto Connections | How To Connect To Presto via JDBC, ODBC & API | Ahana

Jan 27, 20213 min read

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

Athena Query Waiting In Queue or Athena Query Stuck In Queued State

Jan 26, 20212 min read

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 Data Sources & Usage | Ahana

Jan 21, 20213 min read

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 | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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