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
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
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
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
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
What is Presto and what are its frequently asked questions (FAQ)?
What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is Presto and what are its frequently asked questions (FAQ)?
What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is Presto and what are its frequently asked questions (FAQ)?
What Is Trino & Trino Data | Trino SQL FAQs & Support | Ahana
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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