Pricing calculator

Presto Training & Learning Center

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

Topics

Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

Jul 13, 20212 min read

Using Presto with a Hadoop cluster for SQL analytics is pretty common especially in on premise deployments.  With Presto, you can read and query data from the Hadoop datanodes but … Continue reading Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

How do I convert Unix Epoch time to a date or something more human readable with SQL?

Jul 13, 20211 min read

Many times the Unix Epoch Time gets stored in the database. But this is not very human readable and conversion is required for reports and dashboards.  Example of Unix Epoch … Continue reading How do I convert Unix Epoch time to a date or something more human readable with SQL?

How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Jul 13, 20212 min read

Hadoop is a system that manages both compute and data together. Hadoop cluster nodes have the HDFS file system and may also have different types of engines like Apache Hive, … Continue reading How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Jul 9, 20214 min read

Summary Prestodb is an open source distributed parallel query SQL engine. In tutorial 101 we walk through manual installation and configuration on a bare metal server or on a VM. It … Continue reading Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Enabling spill to disk for optimal price per performance

Jul 7, 20214 min read

Presto was born out of the need for low-latency interactive queries on large scale data, and hence, continually optimized for that use case. In such scenarios, the best practice is … Continue reading Enabling spill to disk for optimal price per performance

Presto substring operations: How do I get the X characters from a string of a known length?

Jul 7, 20212 min read

Presto provides an overloaded substring function to extract characters from a string. We will use the string “Presto String Operations” to demonstrate the use of this function. Extract last 7 … Continue reading Presto substring operations: How do I get the X characters from a string of a known length?

Presto 101 Tutorial: Installing & Configuring Presto

Jun 30, 20218 min read

Installing & Configuring Presto locally Presto Installation Presto can be installed manually or using docker images on: Single Node: Both co-ordinator and workers run on the same machine.  or even … Continue reading Presto 101 Tutorial: Installing & Configuring Presto

Spark SQL | What is Spark SQL & Spark SQL Guide | Ahana

Jun 30, 20213 min read

Spark is a general purpose computation engine for large-scale data processing. Spark SQL is the Spark module for working with structured data

Hive vs Presto vs Spark for Data Analysis

Jun 30, 20214 min read

Compare Presto to Hive and compare Presto to Spark for data analysis, Learn is best for you based on your data analytics goals.

Query Data Lake With Presto | Presto Google Cloud | Ahana

Jun 24, 20213 min read

How do I query a data lake with Presto? This article dives into how you can start querying a Data Lake with Presto

EMR Presto S3 Timeout Error | What is it?

Jun 24, 20214 min read

Using AWS EMR Presto on AWS S3? Read this article to understand the timeout error – what it is and how to fix it

Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Jun 24, 20216 min read

The Presto company also shows significant product momentum with numerous accolades and industry recognition  San Mateo, Calif. – June 24, 2021 — Ahana, the Presto company, today announced major momentum … Continue reading Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Why I’m betting on PrestoDB, and why you should too!

Jun 13, 20217 min read

By Dipti Borkar, Ahana Cofounder, Chief Product Officer & Chief Evangelist I’ve been in open source software companies and communities for over 10 years now, and in the database industry … Continue reading Why I’m betting on PrestoDB, and why you should too!

Running Presto Queries – Do I need to move data first?

Jun 3, 20212 min read

Are you running Presto queries? A frequent question is, “Do I need to move data first?”. Learn if you can keep your data in place

5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Jun 1, 20214 min read

In this brief post, we’ll discuss the 5 main reasons why data platform engineers decide to move their data analytics workloads from Amazon Athena to Ahana Cloud for Presto. While … Continue reading 5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Ahana Cloud for Presto Versus Amazon EMR

May 27, 20213 min read

In this brief post, we’ll discuss some of the benefits of Ahana Cloud over Amazon Elastic MapReduce (EMR). While EMR offers optionality in the number of big data compute frameworks, … Continue reading Ahana Cloud for Presto Versus Amazon EMR

Streaming Data Processing Using Apache Kafka and Presto

May 12, 20213 min read

Kafka Quick Start Kafka is a distributed data streaming framework meant to enable the creation of highly scalable distributed systems. Developed at LinkedIn in 2008 and open-sourced in 2011, it … Continue reading Streaming Data Processing Using Apache Kafka and Presto

Business Intelligence And Data Analysis With Druid and Presto

May 12, 20214 min read

Apache Druid Helicopter View Apache Druid is a distributed, columnar database aimed at developing analytical solutions. It offers a real-time analytics database able to ingest and query massive amounts of … Continue reading Business Intelligence And Data Analysis With Druid and Presto

Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

May 12, 20213 min read

Apache Pinot Overview Apache Pinot is a distributed, low latency online analytical processing (OLAP) platform used for carrying out fast big data analytics. Developed at LinkedIn in 2014, the highly … Continue reading Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

Turbocharge your Analytics with MongoDB And Presto

May 12, 20214 min read

High-Level View Of MongoDB MongoDB is a NoSQL distributed document database meant to handle diverse data management requirements. Its design goals include creating an object-oriented, highly available, scalable, efficient, and … Continue reading Turbocharge your Analytics with MongoDB And Presto

CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

May 5, 20214 min read

Ahana also named to CRN’s 10 Hot Big Data Companies You Should Watch in 2021 list San Mateo, Calif. – May 5, 2021 — Ahana, the self-service analytics company for … Continue reading CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

May 4, 20212 min read

How do I sync my partition and metastore in Presto? Sync partition metadata is used to sync the metastore with information on the file system/s3 for the external table. Depending … Continue reading Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

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

May 4, 20212 min read

Learn how to run a CTAS with a query. This article explains the two simplest options to get up and going.

Difference Between Managed Table & External Tables | Ahana

May 4, 20214 min read

Trying to learn the difference between a managed table and external tables? This article explains it and provides guidance

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

Presto FAQ | What Is Presto? | Ahana

Apr 27, 20219 min read

Learn more about Presto and Presto FAQ’s. This article dives into understanding Presto at an operational level.

Turbocharge BI and Analytics: Presto & Apache Superset

Apr 21, 20215 min read

Are you using Apache Superset? Learn how to simplify your BI reporting by integrating Apache Superset with 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

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20216 min read

Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data. Learn how to get deterministic performance.

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

Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

Jul 13, 20212 min read

Using Presto with a Hadoop cluster for SQL analytics is pretty common especially in on premise deployments.  With Presto, you can read and query data from the Hadoop datanodes but … Continue reading Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

How do I convert Unix Epoch time to a date or something more human readable with SQL?

Jul 13, 20211 min read

Many times the Unix Epoch Time gets stored in the database. But this is not very human readable and conversion is required for reports and dashboards.  Example of Unix Epoch … Continue reading How do I convert Unix Epoch time to a date or something more human readable with SQL?

How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Jul 13, 20212 min read

Hadoop is a system that manages both compute and data together. Hadoop cluster nodes have the HDFS file system and may also have different types of engines like Apache Hive, … Continue reading How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Jul 9, 20214 min read

Summary Prestodb is an open source distributed parallel query SQL engine. In tutorial 101 we walk through manual installation and configuration on a bare metal server or on a VM. It … Continue reading Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Enabling spill to disk for optimal price per performance

Jul 7, 20214 min read

Presto was born out of the need for low-latency interactive queries on large scale data, and hence, continually optimized for that use case. In such scenarios, the best practice is … Continue reading Enabling spill to disk for optimal price per performance

Presto substring operations: How do I get the X characters from a string of a known length?

Jul 7, 20212 min read

Presto provides an overloaded substring function to extract characters from a string. We will use the string “Presto String Operations” to demonstrate the use of this function. Extract last 7 … Continue reading Presto substring operations: How do I get the X characters from a string of a known length?

Presto 101 Tutorial: Installing & Configuring Presto

Jun 30, 20218 min read

Installing & Configuring Presto locally Presto Installation Presto can be installed manually or using docker images on: Single Node: Both co-ordinator and workers run on the same machine.  or even … Continue reading Presto 101 Tutorial: Installing & Configuring Presto

Spark SQL | What is Spark SQL & Spark SQL Guide | Ahana

Jun 30, 20213 min read

Spark is a general purpose computation engine for large-scale data processing. Spark SQL is the Spark module for working with structured data

Hive vs Presto vs Spark for Data Analysis

Jun 30, 20214 min read

Compare Presto to Hive and compare Presto to Spark for data analysis, Learn is best for you based on your data analytics goals.

Query Data Lake With Presto | Presto Google Cloud | Ahana

Jun 24, 20213 min read

How do I query a data lake with Presto? This article dives into how you can start querying a Data Lake with Presto

EMR Presto S3 Timeout Error | What is it?

Jun 24, 20214 min read

Using AWS EMR Presto on AWS S3? Read this article to understand the timeout error – what it is and how to fix it

Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Jun 24, 20216 min read

The Presto company also shows significant product momentum with numerous accolades and industry recognition  San Mateo, Calif. – June 24, 2021 — Ahana, the Presto company, today announced major momentum … Continue reading Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Why I’m betting on PrestoDB, and why you should too!

Jun 13, 20217 min read

By Dipti Borkar, Ahana Cofounder, Chief Product Officer & Chief Evangelist I’ve been in open source software companies and communities for over 10 years now, and in the database industry … Continue reading Why I’m betting on PrestoDB, and why you should too!

Running Presto Queries – Do I need to move data first?

Jun 3, 20212 min read

Are you running Presto queries? A frequent question is, “Do I need to move data first?”. Learn if you can keep your data in place

5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Jun 1, 20214 min read

In this brief post, we’ll discuss the 5 main reasons why data platform engineers decide to move their data analytics workloads from Amazon Athena to Ahana Cloud for Presto. While … Continue reading 5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Ahana Cloud for Presto Versus Amazon EMR

May 27, 20213 min read

In this brief post, we’ll discuss some of the benefits of Ahana Cloud over Amazon Elastic MapReduce (EMR). While EMR offers optionality in the number of big data compute frameworks, … Continue reading Ahana Cloud for Presto Versus Amazon EMR

Streaming Data Processing Using Apache Kafka and Presto

May 12, 20213 min read

Kafka Quick Start Kafka is a distributed data streaming framework meant to enable the creation of highly scalable distributed systems. Developed at LinkedIn in 2008 and open-sourced in 2011, it … Continue reading Streaming Data Processing Using Apache Kafka and Presto

Business Intelligence And Data Analysis With Druid and Presto

May 12, 20214 min read

Apache Druid Helicopter View Apache Druid is a distributed, columnar database aimed at developing analytical solutions. It offers a real-time analytics database able to ingest and query massive amounts of … Continue reading Business Intelligence And Data Analysis With Druid and Presto

Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

May 12, 20213 min read

Apache Pinot Overview Apache Pinot is a distributed, low latency online analytical processing (OLAP) platform used for carrying out fast big data analytics. Developed at LinkedIn in 2014, the highly … Continue reading Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

Turbocharge your Analytics with MongoDB And Presto

May 12, 20214 min read

High-Level View Of MongoDB MongoDB is a NoSQL distributed document database meant to handle diverse data management requirements. Its design goals include creating an object-oriented, highly available, scalable, efficient, and … Continue reading Turbocharge your Analytics with MongoDB And Presto

CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

May 5, 20214 min read

Ahana also named to CRN’s 10 Hot Big Data Companies You Should Watch in 2021 list San Mateo, Calif. – May 5, 2021 — Ahana, the self-service analytics company for … Continue reading CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

May 4, 20212 min read

How do I sync my partition and metastore in Presto? Sync partition metadata is used to sync the metastore with information on the file system/s3 for the external table. Depending … Continue reading Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

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

May 4, 20212 min read

Learn how to run a CTAS with a query. This article explains the two simplest options to get up and going.

Difference Between Managed Table & External Tables | Ahana

May 4, 20214 min read

Trying to learn the difference between a managed table and external tables? This article explains it and provides guidance

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

Presto FAQ | What Is Presto? | Ahana

Apr 27, 20219 min read

Learn more about Presto and Presto FAQ’s. This article dives into understanding Presto at an operational level.

Turbocharge BI and Analytics: Presto & Apache Superset

Apr 21, 20215 min read

Are you using Apache Superset? Learn how to simplify your BI reporting by integrating Apache Superset with 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

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20216 min read

Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data. Learn how to get deterministic performance.

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

Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

Jul 13, 20212 min read

Using Presto with a Hadoop cluster for SQL analytics is pretty common especially in on premise deployments.  With Presto, you can read and query data from the Hadoop datanodes but … Continue reading Can I write back or update data in my Hadoop / Apache Hive cluster through Presto?

How do I convert Unix Epoch time to a date or something more human readable with SQL?

Jul 13, 20211 min read

Many times the Unix Epoch Time gets stored in the database. But this is not very human readable and conversion is required for reports and dashboards.  Example of Unix Epoch … Continue reading How do I convert Unix Epoch time to a date or something more human readable with SQL?

How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Jul 13, 20212 min read

Hadoop is a system that manages both compute and data together. Hadoop cluster nodes have the HDFS file system and may also have different types of engines like Apache Hive, … Continue reading How do I transfer data from a Hadoop / Hive cluster to a Presto cluster?

Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Jul 9, 20214 min read

Summary Prestodb is an open source distributed parallel query SQL engine. In tutorial 101 we walk through manual installation and configuration on a bare metal server or on a VM. It … Continue reading Presto 102 Tutorial: Install PrestoDB on a Laptop or PC

Enabling spill to disk for optimal price per performance

Jul 7, 20214 min read

Presto was born out of the need for low-latency interactive queries on large scale data, and hence, continually optimized for that use case. In such scenarios, the best practice is … Continue reading Enabling spill to disk for optimal price per performance

Presto substring operations: How do I get the X characters from a string of a known length?

Jul 7, 20212 min read

Presto provides an overloaded substring function to extract characters from a string. We will use the string “Presto String Operations” to demonstrate the use of this function. Extract last 7 … Continue reading Presto substring operations: How do I get the X characters from a string of a known length?

Presto 101 Tutorial: Installing & Configuring Presto

Jun 30, 20218 min read

Installing & Configuring Presto locally Presto Installation Presto can be installed manually or using docker images on: Single Node: Both co-ordinator and workers run on the same machine.  or even … Continue reading Presto 101 Tutorial: Installing & Configuring Presto

Spark SQL | What is Spark SQL & Spark SQL Guide | Ahana

Jun 30, 20213 min read

Spark is a general purpose computation engine for large-scale data processing. Spark SQL is the Spark module for working with structured data

Hive vs Presto vs Spark for Data Analysis

Jun 30, 20214 min read

Compare Presto to Hive and compare Presto to Spark for data analysis, Learn is best for you based on your data analytics goals.

Query Data Lake With Presto | Presto Google Cloud | Ahana

Jun 24, 20213 min read

How do I query a data lake with Presto? This article dives into how you can start querying a Data Lake with Presto

EMR Presto S3 Timeout Error | What is it?

Jun 24, 20214 min read

Using AWS EMR Presto on AWS S3? Read this article to understand the timeout error – what it is and how to fix it

Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Jun 24, 20216 min read

The Presto company also shows significant product momentum with numerous accolades and industry recognition  San Mateo, Calif. – June 24, 2021 — Ahana, the Presto company, today announced major momentum … Continue reading Ahana Demonstrates Major Momentum in Customer and Community Adoption for Presto 1H 2021

Why I’m betting on PrestoDB, and why you should too!

Jun 13, 20217 min read

By Dipti Borkar, Ahana Cofounder, Chief Product Officer & Chief Evangelist I’ve been in open source software companies and communities for over 10 years now, and in the database industry … Continue reading Why I’m betting on PrestoDB, and why you should too!

Running Presto Queries – Do I need to move data first?

Jun 3, 20212 min read

Are you running Presto queries? A frequent question is, “Do I need to move data first?”. Learn if you can keep your data in place

5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Jun 1, 20214 min read

In this brief post, we’ll discuss the 5 main reasons why data platform engineers decide to move their data analytics workloads from Amazon Athena to Ahana Cloud for Presto. While … Continue reading 5 main reasons Data Engineers move from AWS Athena to Ahana Cloud

Ahana Cloud for Presto Versus Amazon EMR

May 27, 20213 min read

In this brief post, we’ll discuss some of the benefits of Ahana Cloud over Amazon Elastic MapReduce (EMR). While EMR offers optionality in the number of big data compute frameworks, … Continue reading Ahana Cloud for Presto Versus Amazon EMR

Streaming Data Processing Using Apache Kafka and Presto

May 12, 20213 min read

Kafka Quick Start Kafka is a distributed data streaming framework meant to enable the creation of highly scalable distributed systems. Developed at LinkedIn in 2008 and open-sourced in 2011, it … Continue reading Streaming Data Processing Using Apache Kafka and Presto

Business Intelligence And Data Analysis With Druid and Presto

May 12, 20214 min read

Apache Druid Helicopter View Apache Druid is a distributed, columnar database aimed at developing analytical solutions. It offers a real-time analytics database able to ingest and query massive amounts of … Continue reading Business Intelligence And Data Analysis With Druid and Presto

Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

May 12, 20213 min read

Apache Pinot Overview Apache Pinot is a distributed, low latency online analytical processing (OLAP) platform used for carrying out fast big data analytics. Developed at LinkedIn in 2014, the highly … Continue reading Flexible And Low Latency OLAP Using Apache Pinot and Presto for real time analytics

Turbocharge your Analytics with MongoDB And Presto

May 12, 20214 min read

High-Level View Of MongoDB MongoDB is a NoSQL distributed document database meant to handle diverse data management requirements. Its design goals include creating an object-oriented, highly available, scalable, efficient, and … Continue reading Turbocharge your Analytics with MongoDB And Presto

CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

May 5, 20214 min read

Ahana also named to CRN’s 10 Hot Big Data Companies You Should Watch in 2021 list San Mateo, Calif. – May 5, 2021 — Ahana, the self-service analytics company for … Continue reading CRN® Recognizes Ahana on Its 2021 Big Data 100 List As One of The Coolest Business Analytics Companies

Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

May 4, 20212 min read

How do I sync my partition and metastore in Presto? Sync partition metadata is used to sync the metastore with information on the file system/s3 for the external table. Depending … Continue reading Presto Sync Partition Metastore & Metadata | Presto Sync | Ahana

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

May 4, 20212 min read

Learn how to run a CTAS with a query. This article explains the two simplest options to get up and going.

Difference Between Managed Table & External Tables | Ahana

May 4, 20214 min read

Trying to learn the difference between a managed table and external tables? This article explains it and provides guidance

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

Presto FAQ | What Is Presto? | Ahana

Apr 27, 20219 min read

Learn more about Presto and Presto FAQ’s. This article dives into understanding Presto at an operational level.

Turbocharge BI and Analytics: Presto & Apache Superset

Apr 21, 20215 min read

Are you using Apache Superset? Learn how to simplify your BI reporting by integrating Apache Superset with 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

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

Getting Deterministic Performance Out Of Amazon Athena Guide | Ahana

Mar 5, 20216 min read

Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data. Learn how to get deterministic performance.

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