Presto Training & Learning Center

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

Topics

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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

How To Connect To Presto | Connecting To Presto | Ahana

Feb 2, 20213 min read

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

How to Access Presto | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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

How To Make Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

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

Jan 27, 20213 min read

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

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

Jan 26, 20212 min read

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

How to Presto Data Share | Presto Data Sources & Usage | Ahana

Jan 21, 20213 min read

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

Presto Performance | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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

Presto REST API | Presto Client & REST API Examples | Ahana

Jan 21, 20213 min read

Presto REST API Presto’s HTTP API (Presto Rest API) is the communication protocol between server and client. It’s used to send query statements for execution on the server and to … Continue reading Presto REST API | Presto Client & REST API Examples | Ahana

Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Jan 21, 20212 min read

Presto Parquet Parquet is a columnar storage format for Hadoop, supported by Presto.  Storing data as columns as opposed to rows enables Presto to fulfill queries more efficiently. By discarding … Continue reading Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Presto Speed: How Fast is Presto?

Jan 21, 20213 min read

Presto Speed 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 that is stored externally … Continue reading Presto Speed: How Fast is Presto?

Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Jan 21, 20212 min read

Presto Tools Several tools  and libraries are available, some are bundled with core Presto and others are downloadable extras. See the documentation Resources page at  https://prestodb.io/resources.html for details.  Core Presto … Continue reading Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Presto Documentation & Presto Docs

Jan 21, 20212 min read

Presto Documentation Presto’s documentation is maintained by the Presto Foundation and the current version is available here: https://prestodb.io/docs/current/  Releases can be found at: https://github.com/prestodb and the Release Notes are at: … Continue reading Presto Documentation & Presto Docs

Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Jan 21, 20212 min read

Presto Query Example Since Presto is an ANSI SQL query engine, its SQL will be very familiar to practically anyone who has used a database, despite the fact Presto is … Continue reading Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Presto Best Practices | What Are The Best Practices for Presto | Ahana

Jan 21, 20216 min read

Presto Best Practices We’ve put together a list of Presto best practices, based on our experience. We hope you find these helpful. Configure Presto’s coordinator and workers to run on … Continue reading Presto Best Practices | What Are The Best Practices for Presto | Ahana

How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Jan 14, 20214 min read

How Presto Joins Data Because Presto is a distributed system composed of a coordinator and workers, each worker can connect to one or more data sources through corresponding connectors. The … Continue reading How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Jan 13, 20214 min read

Executing Presto Spark Executing Presto Spark queries is possible, but why leverage Spark as an execution framework for Presto’s queries when Presto is itself an efficient execution engine?  The fact … Continue reading Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Query Exhausted Resources On This Scale Factor Error | Ahana

Jan 12, 20213 min read

When I run a query with AWS Athena, I get the error message ‘query exhausted resources on this scale factor’. Why? AWS Athena is well documented in having performance issues, … Continue reading Query Exhausted Resources On This Scale Factor Error | Ahana

Creating Tables In A S3 Bucket Issues | Ahana

Jan 11, 20214 min read

Creating tables in a S3 Bucket gives “Query failed External location must be a directory” So here’s why you are here. You are using Presto’s Hive connector and you want … Continue reading Creating Tables In A S3 Bucket Issues | Ahana

Big Data Query | Presto Big Data | Ahana

Jan 11, 20213 min read

Big Data Query When it comes to querying big data using standard SQL you have come to the right place as this is what Presto was designed to do. Presto, … Continue reading Big Data Query | Presto Big Data | Ahana

RDS Postgres Databases Complex Queries | Ahana

Jan 8, 20214 min read

I use RDS Postgres databases and need some complex queries done which tend to slow down my databases for everyone else on the system. What do I need to consider … Continue reading RDS Postgres Databases Complex Queries | Ahana

Ahana Cofounders Make Data Predictions for 2021

Jan 6, 20215 min read

Open Analytics, Open Source, Multi-Cloud and Federated, Disaggregated Stack Rise to the Top  San Mateo, Calif. – January 6, 2021 — Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and … Continue reading Ahana Cofounders Make Data Predictions for 2021

Advanced SQL Tutorial & SQL Queries Support

Jan 4, 20214 min read

Advanced SQL Tutorial JSON Presto has a wide-range of JSON functions. Consider this json test input data (represented in the query using the  VALUES function) which contains 3 key/value elements. … Continue reading Advanced SQL Tutorial & SQL Queries Support

Complex SQL Queries | SQL Complex Queries | Ahana

Jan 4, 20212 min read

Complex SQL Queries Complex SQL queries benefit from Presto’s distributed, parallel, in-memory processing architecture and cost-based optimizer. And with Presto’s federation capabilities even more complex queries can be unleashed on … Continue reading Complex SQL Queries | SQL Complex Queries | Ahana

What is DB Presto Online?

Dec 22, 20201 min read

If you are looking for online resources for Presto like the docs, then start here https://prestodb.io/  If you are looking for information on how to tell if your Presto cluster … Continue reading What is DB Presto Online?

Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Dec 14, 20202 min read

Advanced SQL Queries with Presto Advanced SQL features and functions are used by analysts when, for example, complex calculations are needed, or when many tables (perhaps from multiple sources) need … Continue reading Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Presto Platform Overview: Interactive Analytic Queries

Dec 14, 20202 min read

Presto Platform Overview Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes. Some of the world’s most innovative and … Continue reading Presto Platform Overview: Interactive Analytic Queries

0 to Presto in 30 minutes with AWS and Ahana Cloud

Dec 10, 20201 min read

In this on-demand recording will share how Ahana Cloud, the first managed service for PrestoDB, simplifies Presto deployment and management on AWS running in-VPC on Kubernetes. Register today to generate insights and self-service analytics, easier than ever.

How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Dec 10, 20201 min read

How To Stop Presto If you are using the presto-admin tool this is how to stop Presto safely: $ presto-admin server stop In addition these commands are also useful: presto-admin … Continue reading How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Presto New Releases & Latest Release

Dec 10, 20201 min read

Presto New Releases Where is the latest release of PrestoDB? And where can I find the release notes? Where is the documentation? These are common questions with easy answers. Presto’s … Continue reading Presto New Releases & Latest Release

How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Dec 10, 20203 min read

How Much Memory To Give A Presto Worker Node Presto is an in-memory query engine and so naturally memory configuration and management is important. A common question that comes up is … Continue reading How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Dec 9, 20205 min read

I’m thrilled to share that today Ahana Cloud for Presto on AWS is generally available and open for Open Analytics. Ahana Cloud 🌤 is the first fully integrated, cloud-native managed … Continue reading Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Ahana Announces General Availability of Managed Service for Presto on AWS; Delivers Combined Solution with Intel to Drive Adoption of Open Data Lakes Analytics

Dec 9, 20206 min read

Additionally, Ahana announced a go-to-market solution in collaboration with Intel via its participation in the Intel Disruptor Program to offer an Open Data Lake Analytics Accelerator Package for Ahana Cloud users that leverages Intel Optane on the cloud with AWS.

Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Nov 30, 20203 min read

How to Show Tables From All Schemas with Presto In Presto it is straightforward to show all tables in a schema e.g. If we have a MySQL data source/catalog that … Continue reading Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Nov 30, 20202 min read

How To Convert Bigint to Timestamp with Presto UNIX timestamps are normally stored as doubles. If you have UNIX timestamps stored as big integers then you may encounter errors when … Continue reading Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Convert Timestamp To Date With Presto | Ahana

Nov 30, 20204 min read

How do I convert timestamp to date with Presto? Luckily Presto has a wide range of conversion functions and they are listed in the docs.  Many of these allow us … Continue reading Convert Timestamp To Date With Presto | Ahana

Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Nov 30, 20203 min read

Case Sensitive Search Configuration with Presto When dealing with character data, case sensitivity can be important when  searching for specific matches or patterns. But not all databases and query engines … Continue reading Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Use ORC Versus Parquet When Using Presto | Ahana

Nov 23, 20201 min read

When should I use ORC versus Parquet when using Presto? If you’re working with open data lakes using open source and open formats, you can have multiple formats. Presto works … Continue reading Use ORC Versus Parquet When Using Presto | Ahana

Benefits Of Hive Metastore With Presto | Ahana

Nov 23, 20202 min read

What’s the advantage of having your own Hive metastore with Presto? How does it compare to Amazon Glue? First let’s define what Apache Hive is versus Amazon Glue. Apache Hive … Continue reading Benefits Of Hive Metastore With Presto | Ahana

Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Nov 18, 20202 min read

How to Find Out Data Type of Value with Presto Presto has a typeof() function to make finding out data types of values easy. This is particularly useful when you … Continue reading Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

Nov 18, 20202 min read

How to Rotate Rows to Columns with Presto Sometimes called pivoting, here is one example of how to switch columns to rows via rotation with Presto.   Suppose we have rows … Continue reading Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

How do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20202 min read

Presto Architecture and Design The Presto architecture and design seamlessly integrates with an existing data ecosystem without needing to modify it. It’s an additional faster data access interface that turbocharges … Continue reading Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Benefits Of Using Managed Service For Presto | Ahana

Nov 11, 20203 min read

What are the operational benefits of using a managed service for Presto with Ahana Cloud? First let’s hear from an AWS Solution Architect: “Ahana Cloud uses the best practices of … Continue reading Benefits Of Using Managed Service For Presto | Ahana

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you cross join unnest a JSON array?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by doing Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you cross join unnest a JSON array?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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

How To Connect To Presto | Connecting To Presto | Ahana

Feb 2, 20213 min read

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

How to Access Presto | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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

How To Make Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

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

Jan 27, 20213 min read

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

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

Jan 26, 20212 min read

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

How to Presto Data Share | Presto Data Sources & Usage | Ahana

Jan 21, 20213 min read

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

Presto Performance | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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

Presto REST API | Presto Client & REST API Examples | Ahana

Jan 21, 20213 min read

Presto REST API Presto’s HTTP API (Presto Rest API) is the communication protocol between server and client. It’s used to send query statements for execution on the server and to … Continue reading Presto REST API | Presto Client & REST API Examples | Ahana

Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Jan 21, 20212 min read

Presto Parquet Parquet is a columnar storage format for Hadoop, supported by Presto.  Storing data as columns as opposed to rows enables Presto to fulfill queries more efficiently. By discarding … Continue reading Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Presto Speed: How Fast is Presto?

Jan 21, 20213 min read

Presto Speed 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 that is stored externally … Continue reading Presto Speed: How Fast is Presto?

Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Jan 21, 20212 min read

Presto Tools Several tools  and libraries are available, some are bundled with core Presto and others are downloadable extras. See the documentation Resources page at  https://prestodb.io/resources.html for details.  Core Presto … Continue reading Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Presto Documentation & Presto Docs

Jan 21, 20212 min read

Presto Documentation Presto’s documentation is maintained by the Presto Foundation and the current version is available here: https://prestodb.io/docs/current/  Releases can be found at: https://github.com/prestodb and the Release Notes are at: … Continue reading Presto Documentation & Presto Docs

Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Jan 21, 20212 min read

Presto Query Example Since Presto is an ANSI SQL query engine, its SQL will be very familiar to practically anyone who has used a database, despite the fact Presto is … Continue reading Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Presto Best Practices | What Are The Best Practices for Presto | Ahana

Jan 21, 20216 min read

Presto Best Practices We’ve put together a list of Presto best practices, based on our experience. We hope you find these helpful. Configure Presto’s coordinator and workers to run on … Continue reading Presto Best Practices | What Are The Best Practices for Presto | Ahana

How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Jan 14, 20214 min read

How Presto Joins Data Because Presto is a distributed system composed of a coordinator and workers, each worker can connect to one or more data sources through corresponding connectors. The … Continue reading How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Jan 13, 20214 min read

Executing Presto Spark Executing Presto Spark queries is possible, but why leverage Spark as an execution framework for Presto’s queries when Presto is itself an efficient execution engine?  The fact … Continue reading Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Query Exhausted Resources On This Scale Factor Error | Ahana

Jan 12, 20213 min read

When I run a query with AWS Athena, I get the error message ‘query exhausted resources on this scale factor’. Why? AWS Athena is well documented in having performance issues, … Continue reading Query Exhausted Resources On This Scale Factor Error | Ahana

Creating Tables In A S3 Bucket Issues | Ahana

Jan 11, 20214 min read

Creating tables in a S3 Bucket gives “Query failed External location must be a directory” So here’s why you are here. You are using Presto’s Hive connector and you want … Continue reading Creating Tables In A S3 Bucket Issues | Ahana

Big Data Query | Presto Big Data | Ahana

Jan 11, 20213 min read

Big Data Query When it comes to querying big data using standard SQL you have come to the right place as this is what Presto was designed to do. Presto, … Continue reading Big Data Query | Presto Big Data | Ahana

RDS Postgres Databases Complex Queries | Ahana

Jan 8, 20214 min read

I use RDS Postgres databases and need some complex queries done which tend to slow down my databases for everyone else on the system. What do I need to consider … Continue reading RDS Postgres Databases Complex Queries | Ahana

Ahana Cofounders Make Data Predictions for 2021

Jan 6, 20215 min read

Open Analytics, Open Source, Multi-Cloud and Federated, Disaggregated Stack Rise to the Top  San Mateo, Calif. – January 6, 2021 — Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and … Continue reading Ahana Cofounders Make Data Predictions for 2021

Advanced SQL Tutorial & SQL Queries Support

Jan 4, 20214 min read

Advanced SQL Tutorial JSON Presto has a wide-range of JSON functions. Consider this json test input data (represented in the query using the  VALUES function) which contains 3 key/value elements. … Continue reading Advanced SQL Tutorial & SQL Queries Support

Complex SQL Queries | SQL Complex Queries | Ahana

Jan 4, 20212 min read

Complex SQL Queries Complex SQL queries benefit from Presto’s distributed, parallel, in-memory processing architecture and cost-based optimizer. And with Presto’s federation capabilities even more complex queries can be unleashed on … Continue reading Complex SQL Queries | SQL Complex Queries | Ahana

What is DB Presto Online?

Dec 22, 20201 min read

If you are looking for online resources for Presto like the docs, then start here https://prestodb.io/  If you are looking for information on how to tell if your Presto cluster … Continue reading What is DB Presto Online?

Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Dec 14, 20202 min read

Advanced SQL Queries with Presto Advanced SQL features and functions are used by analysts when, for example, complex calculations are needed, or when many tables (perhaps from multiple sources) need … Continue reading Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Presto Platform Overview: Interactive Analytic Queries

Dec 14, 20202 min read

Presto Platform Overview Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes. Some of the world’s most innovative and … Continue reading Presto Platform Overview: Interactive Analytic Queries

0 to Presto in 30 minutes with AWS and Ahana Cloud

Dec 10, 20201 min read

In this on-demand recording will share how Ahana Cloud, the first managed service for PrestoDB, simplifies Presto deployment and management on AWS running in-VPC on Kubernetes. Register today to generate insights and self-service analytics, easier than ever.

How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Dec 10, 20201 min read

How To Stop Presto If you are using the presto-admin tool this is how to stop Presto safely: $ presto-admin server stop In addition these commands are also useful: presto-admin … Continue reading How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Presto New Releases & Latest Release

Dec 10, 20201 min read

Presto New Releases Where is the latest release of PrestoDB? And where can I find the release notes? Where is the documentation? These are common questions with easy answers. Presto’s … Continue reading Presto New Releases & Latest Release

How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Dec 10, 20203 min read

How Much Memory To Give A Presto Worker Node Presto is an in-memory query engine and so naturally memory configuration and management is important. A common question that comes up is … Continue reading How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Dec 9, 20205 min read

I’m thrilled to share that today Ahana Cloud for Presto on AWS is generally available and open for Open Analytics. Ahana Cloud 🌤 is the first fully integrated, cloud-native managed … Continue reading Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Ahana Announces General Availability of Managed Service for Presto on AWS; Delivers Combined Solution with Intel to Drive Adoption of Open Data Lakes Analytics

Dec 9, 20206 min read

Additionally, Ahana announced a go-to-market solution in collaboration with Intel via its participation in the Intel Disruptor Program to offer an Open Data Lake Analytics Accelerator Package for Ahana Cloud users that leverages Intel Optane on the cloud with AWS.

Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Nov 30, 20203 min read

How to Show Tables From All Schemas with Presto In Presto it is straightforward to show all tables in a schema e.g. If we have a MySQL data source/catalog that … Continue reading Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Nov 30, 20202 min read

How To Convert Bigint to Timestamp with Presto UNIX timestamps are normally stored as doubles. If you have UNIX timestamps stored as big integers then you may encounter errors when … Continue reading Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Convert Timestamp To Date With Presto | Ahana

Nov 30, 20204 min read

How do I convert timestamp to date with Presto? Luckily Presto has a wide range of conversion functions and they are listed in the docs.  Many of these allow us … Continue reading Convert Timestamp To Date With Presto | Ahana

Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Nov 30, 20203 min read

Case Sensitive Search Configuration with Presto When dealing with character data, case sensitivity can be important when  searching for specific matches or patterns. But not all databases and query engines … Continue reading Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Use ORC Versus Parquet When Using Presto | Ahana

Nov 23, 20201 min read

When should I use ORC versus Parquet when using Presto? If you’re working with open data lakes using open source and open formats, you can have multiple formats. Presto works … Continue reading Use ORC Versus Parquet When Using Presto | Ahana

Benefits Of Hive Metastore With Presto | Ahana

Nov 23, 20202 min read

What’s the advantage of having your own Hive metastore with Presto? How does it compare to Amazon Glue? First let’s define what Apache Hive is versus Amazon Glue. Apache Hive … Continue reading Benefits Of Hive Metastore With Presto | Ahana

Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Nov 18, 20202 min read

How to Find Out Data Type of Value with Presto Presto has a typeof() function to make finding out data types of values easy. This is particularly useful when you … Continue reading Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

Nov 18, 20202 min read

How to Rotate Rows to Columns with Presto Sometimes called pivoting, here is one example of how to switch columns to rows via rotation with Presto.   Suppose we have rows … Continue reading Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

How do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20202 min read

Presto Architecture and Design The Presto architecture and design seamlessly integrates with an existing data ecosystem without needing to modify it. It’s an additional faster data access interface that turbocharges … Continue reading Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Benefits Of Using Managed Service For Presto | Ahana

Nov 11, 20203 min read

What are the operational benefits of using a managed service for Presto with Ahana Cloud? First let’s hear from an AWS Solution Architect: “Ahana Cloud uses the best practices of … Continue reading Benefits Of Using Managed Service For Presto | Ahana

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you cross join unnest a JSON array?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by doing Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you cross join unnest a JSON array?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Presto Graphql | Does Presto Work Natively With GraphQL | Ahana

Feb 3, 20211 min read

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

How To Connect To Presto | Connecting To Presto | Ahana

Feb 2, 20213 min read

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

How to Access Presto | Best Ways to Connect to Presto | Ahana

Feb 2, 20212 min read

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

Presto Machine Learning | Machine Learning With Presto | Ahana

Feb 2, 20219 min read

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

How To Make Presto Query Engine Run Fastest | Ahana

Jan 28, 20216 min read

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

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

Jan 27, 20213 min read

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

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

Jan 26, 20212 min read

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

How to Presto Data Share | Presto Data Sources & Usage | Ahana

Jan 21, 20213 min read

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

Presto Performance | Presto Speed, Optimization & Tuning | Ahana

Jan 21, 20218 min read

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

Presto REST API | Presto Client & REST API Examples | Ahana

Jan 21, 20213 min read

Presto REST API Presto’s HTTP API (Presto Rest API) is the communication protocol between server and client. It’s used to send query statements for execution on the server and to … Continue reading Presto REST API | Presto Client & REST API Examples | Ahana

Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Jan 21, 20212 min read

Presto Parquet Parquet is a columnar storage format for Hadoop, supported by Presto.  Storing data as columns as opposed to rows enables Presto to fulfill queries more efficiently. By discarding … Continue reading Presto Parquet | Presto Parquet Tools & Tutorial | Ahana

Presto Speed: How Fast is Presto?

Jan 21, 20213 min read

Presto Speed 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 that is stored externally … Continue reading Presto Speed: How Fast is Presto?

Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Jan 21, 20212 min read

Presto Tools Several tools  and libraries are available, some are bundled with core Presto and others are downloadable extras. See the documentation Resources page at  https://prestodb.io/resources.html for details.  Core Presto … Continue reading Presto Tools & Presto Tool | Key Presto Libraries | Ahana

Presto Documentation & Presto Docs

Jan 21, 20212 min read

Presto Documentation Presto’s documentation is maintained by the Presto Foundation and the current version is available here: https://prestodb.io/docs/current/  Releases can be found at: https://github.com/prestodb and the Release Notes are at: … Continue reading Presto Documentation & Presto Docs

Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Jan 21, 20212 min read

Presto Query Example Since Presto is an ANSI SQL query engine, its SQL will be very familiar to practically anyone who has used a database, despite the fact Presto is … Continue reading Presto Query Examples | Presto CTE Examples & SQL Syntax| Ahana

Presto Best Practices | What Are The Best Practices for Presto | Ahana

Jan 21, 20216 min read

Presto Best Practices We’ve put together a list of Presto best practices, based on our experience. We hope you find these helpful. Configure Presto’s coordinator and workers to run on … Continue reading Presto Best Practices | What Are The Best Practices for Presto | Ahana

How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Jan 14, 20214 min read

How Presto Joins Data Because Presto is a distributed system composed of a coordinator and workers, each worker can connect to one or more data sources through corresponding connectors. The … Continue reading How Presto Joins Data | Presto Data Connectors & Join Example | Ahana

Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Jan 13, 20214 min read

Executing Presto Spark Executing Presto Spark queries is possible, but why leverage Spark as an execution framework for Presto’s queries when Presto is itself an efficient execution engine?  The fact … Continue reading Executing Presto Spark | Using Spark’s Execution Engine With Presto | Ahana

Query Exhausted Resources On This Scale Factor Error | Ahana

Jan 12, 20213 min read

When I run a query with AWS Athena, I get the error message ‘query exhausted resources on this scale factor’. Why? AWS Athena is well documented in having performance issues, … Continue reading Query Exhausted Resources On This Scale Factor Error | Ahana

Creating Tables In A S3 Bucket Issues | Ahana

Jan 11, 20214 min read

Creating tables in a S3 Bucket gives “Query failed External location must be a directory” So here’s why you are here. You are using Presto’s Hive connector and you want … Continue reading Creating Tables In A S3 Bucket Issues | Ahana

Big Data Query | Presto Big Data | Ahana

Jan 11, 20213 min read

Big Data Query When it comes to querying big data using standard SQL you have come to the right place as this is what Presto was designed to do. Presto, … Continue reading Big Data Query | Presto Big Data | Ahana

RDS Postgres Databases Complex Queries | Ahana

Jan 8, 20214 min read

I use RDS Postgres databases and need some complex queries done which tend to slow down my databases for everyone else on the system. What do I need to consider … Continue reading RDS Postgres Databases Complex Queries | Ahana

Ahana Cofounders Make Data Predictions for 2021

Jan 6, 20215 min read

Open Analytics, Open Source, Multi-Cloud and Federated, Disaggregated Stack Rise to the Top  San Mateo, Calif. – January 6, 2021 — Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and … Continue reading Ahana Cofounders Make Data Predictions for 2021

Advanced SQL Tutorial & SQL Queries Support

Jan 4, 20214 min read

Advanced SQL Tutorial JSON Presto has a wide-range of JSON functions. Consider this json test input data (represented in the query using the  VALUES function) which contains 3 key/value elements. … Continue reading Advanced SQL Tutorial & SQL Queries Support

Complex SQL Queries | SQL Complex Queries | Ahana

Jan 4, 20212 min read

Complex SQL Queries Complex SQL queries benefit from Presto’s distributed, parallel, in-memory processing architecture and cost-based optimizer. And with Presto’s federation capabilities even more complex queries can be unleashed on … Continue reading Complex SQL Queries | SQL Complex Queries | Ahana

What is DB Presto Online?

Dec 22, 20201 min read

If you are looking for online resources for Presto like the docs, then start here https://prestodb.io/  If you are looking for information on how to tell if your Presto cluster … Continue reading What is DB Presto Online?

Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Dec 14, 20202 min read

Advanced SQL Queries with Presto Advanced SQL features and functions are used by analysts when, for example, complex calculations are needed, or when many tables (perhaps from multiple sources) need … Continue reading Advanced SQL Queries with Presto | SQL Queries Presto | Ahana

Presto Platform Overview: Interactive Analytic Queries

Dec 14, 20202 min read

Presto Platform Overview Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes. Some of the world’s most innovative and … Continue reading Presto Platform Overview: Interactive Analytic Queries

0 to Presto in 30 minutes with AWS and Ahana Cloud

Dec 10, 20201 min read

In this on-demand recording will share how Ahana Cloud, the first managed service for PrestoDB, simplifies Presto deployment and management on AWS running in-VPC on Kubernetes. Register today to generate insights and self-service analytics, easier than ever.

How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Dec 10, 20201 min read

How To Stop Presto If you are using the presto-admin tool this is how to stop Presto safely: $ presto-admin server stop In addition these commands are also useful: presto-admin … Continue reading How to Stop Presto Tutorial | EMR Restart Presto Tutorial | Ahana

Presto New Releases & Latest Release

Dec 10, 20201 min read

Presto New Releases Where is the latest release of PrestoDB? And where can I find the release notes? Where is the documentation? These are common questions with easy answers. Presto’s … Continue reading Presto New Releases & Latest Release

How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Dec 10, 20203 min read

How Much Memory To Give A Presto Worker Node Presto is an in-memory query engine and so naturally memory configuration and management is important. A common question that comes up is … Continue reading How Much Memory To Give A Presto Worker Node | Presto Memory | Ahana

Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Dec 9, 20205 min read

I’m thrilled to share that today Ahana Cloud for Presto on AWS is generally available and open for Open Analytics. Ahana Cloud 🌤 is the first fully integrated, cloud-native managed … Continue reading Ahana Cloud for Presto 🌤 – Now “Open” for “Open Analytics”

Ahana Announces General Availability of Managed Service for Presto on AWS; Delivers Combined Solution with Intel to Drive Adoption of Open Data Lakes Analytics

Dec 9, 20206 min read

Additionally, Ahana announced a go-to-market solution in collaboration with Intel via its participation in the Intel Disruptor Program to offer an Open Data Lake Analytics Accelerator Package for Ahana Cloud users that leverages Intel Optane on the cloud with AWS.

Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Nov 30, 20203 min read

How to Show Tables From All Schemas with Presto In Presto it is straightforward to show all tables in a schema e.g. If we have a MySQL data source/catalog that … Continue reading Show Tables From Schemas With Presto | Presto Information_Shema | Ahana

Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Nov 30, 20202 min read

How To Convert Bigint to Timestamp with Presto UNIX timestamps are normally stored as doubles. If you have UNIX timestamps stored as big integers then you may encounter errors when … Continue reading Convert Presto Bigint To Timestamp | Bigint To Timestamp Presto | Ahana

Convert Timestamp To Date With Presto | Ahana

Nov 30, 20204 min read

How do I convert timestamp to date with Presto? Luckily Presto has a wide range of conversion functions and they are listed in the docs.  Many of these allow us … Continue reading Convert Timestamp To Date With Presto | Ahana

Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Nov 30, 20203 min read

Case Sensitive Search Configuration with Presto When dealing with character data, case sensitivity can be important when  searching for specific matches or patterns. But not all databases and query engines … Continue reading Case Sensitive Search Configuration with Presto | Presto Regex | Ahana

Use ORC Versus Parquet When Using Presto | Ahana

Nov 23, 20201 min read

When should I use ORC versus Parquet when using Presto? If you’re working with open data lakes using open source and open formats, you can have multiple formats. Presto works … Continue reading Use ORC Versus Parquet When Using Presto | Ahana

Benefits Of Hive Metastore With Presto | Ahana

Nov 23, 20202 min read

What’s the advantage of having your own Hive metastore with Presto? How does it compare to Amazon Glue? First let’s define what Apache Hive is versus Amazon Glue. Apache Hive … Continue reading Benefits Of Hive Metastore With Presto | Ahana

Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Nov 18, 20202 min read

How to Find Out Data Type of Value with Presto Presto has a typeof() function to make finding out data types of values easy. This is particularly useful when you … Continue reading Find Out Data Type of Value with Presto | Presto Check Data Type | Ahana

Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

Nov 18, 20202 min read

How to Rotate Rows to Columns with Presto Sometimes called pivoting, here is one example of how to switch columns to rows via rotation with Presto.   Suppose we have rows … Continue reading Presto Pivot Rows to Columns | Rows to Columns via Rotation | Ahana

How do you rotate columns to rows with Presto?

Nov 18, 20201 min read

Sometimes called unpivoting, here is one example of how to rotate column data with Presto.   Suppose we have some integer data arranged in two columns called a and b: a … Continue reading How do you rotate columns to rows with Presto?

Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Nov 12, 20202 min read

Presto Architecture and Design The Presto architecture and design seamlessly integrates with an existing data ecosystem without needing to modify it. It’s an additional faster data access interface that turbocharges … Continue reading Apache Presto Architecture & Design | PrestoDB Architecture | Ahana

Benefits Of Using Managed Service For Presto | Ahana

Nov 11, 20203 min read

What are the operational benefits of using a managed service for Presto with Ahana Cloud? First let’s hear from an AWS Solution Architect: “Ahana Cloud uses the best practices of … Continue reading Benefits Of Using Managed Service For Presto | Ahana

Presto Explode Array | Lateral View Explode in Presto | Ahana

Nov 11, 20202 min read

How to Lateral View Explode in Presto Hive’s explode() function takes an array (or a map) as input and outputs the elements of the array (map) as separate rows. Explode … Continue reading Presto Explode Array | Lateral View Explode in Presto | Ahana

How do you cross join unnest a JSON array?

Nov 11, 20202 min read

Let’s take a look at how you can cross join unnest a JSON array by doing Presto joins. Here’s an example using test results data in json form as input, … Continue reading How do you cross join unnest a JSON array?

How can you write the output of queries to S3 easily?

Nov 10, 20201 min read

With Ahana Cloud, we’ve made it easy for you write output of queries to S3. While there’s a variety of formats, here’s an example:

Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

Nov 5, 20201 min read

With Amazon Athena you’re limited in scope when it comes to doing joins across other data sources like relational data systems and more. You have to set up a Lambda, … Continue reading Does Amazon Athena do joins across other data sources besides S3? Does Amazon Athena connect to other data sources?

If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?

Nov 5, 20201 min read

If you’re managing Presto on your own, either through your own installation or through a service like AWS EMR or AWS Athena, you have to maintain and manage all of … Continue reading If I have catalogs connected and configurations attached to my Presto cluster, what happens when I take the cluster down?