Pricing calculator

PrestoDB Questions & Answers

Answers to your questions about PrestoDB

Topics

4 Amazon Redshift Alternatives for Better Analytics

Sep 20, 20227 min read

Using Amazon Redshift? If you are looking to replace Amazon Redshift due to the limitations look at the AWS Redshift Alternatives.

Problems with Amazon Redshift

Sep 20, 20225 min read

Redshift vs Redshift Spectrum: in this article we’ll cover what both are, how they are used, and pros and cons.

Amazon Redshift Spectrum vs Redshift: Key Differences

Aug 2, 20224 min read

Redshift vs Redshift Spectrum: in this article we’ll cover what both are, how they are used, and pros and cons.

Using AWS Redshift Spectrum in AWS Lake Formation | Ahana

Jul 25, 20225 min read

Lake Formation makes it easier to set up the data lake, and to incorporate Redshift as part of the compute layer alongside other analytics tools and services.

Data Warehouse: Understanding the Types & Architecture

Jul 5, 20225 min read

Data Warehouse: A Comprehensive Guide Introduction A data warehouse is a data repository that is typically used for analytic systems and Business Intelligence tools. It is typically composed of operational … Continue reading Data Warehouse: Understanding the Types & Architecture

Data Warehouse Concepts for Beginners | Ahana

Jul 5, 20225 min read

Data Warehouse Concepts for Beginners A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. Typically a data warehouse contains historical … Continue reading Data Warehouse Concepts for Beginners | Ahana

AWS Redshift Limitations | Redshift Pros and Cons

Jun 17, 20225 min read

Redshift is an Amazon petabyte-scale data warehouse product that is based on PostgreSQL version 8.0.2. While there are pros to Redshift, there are also cons. One of which is query limits. In this article we will dive deeper into the restrictions of Redshift including query limitations.

Benefits Of Using Managed Service For Presto | Ahana

Jun 11, 20224 min read

Ahana Cloud offers a fully managed service for PrestoDB. This article will explain the benefits and need of a managed service.

AWS Athena Pricing vs Ahana Pricing

Jun 7, 20225 min read

What does AWS Athena cost? Compare Price-Performance Ratio of AWS Athena vs Ahana. Understand the value of Athena and Ahana for Presto.

What is Amazon Redshift Spectrum? | Ahana

Jun 7, 20225 min read

Launched in 2017, Redshift Spectrum is a feature within Redshift that enables you to query data stored in AWS S3 using SQL. Spectrum allows you to do federated queries from within the Redshift SQL query editor to data in S3, while also being able to combine it with data in Redshift.

Building a Data Lake Using Lake Formation on AWS

Jun 7, 20225 min read

AWS lake formation helps users to build, manage and secure their data lakes in a very short amount of time, meaning days instead of months as is common with a traditional data lake approach.

Is Amazon Redshift Expensive?

Jun 6, 20225 min read

AWS Redshift is a completely managed cloud data warehouse service with the ability to scale on-demand and is compatible with multitudes of AWS tools and technologies. AWS Redshift is considered the preferred cloud data warehouse of choice for most customers but the pricing is not simple, since it tries to accommodate different use cases and customers. Let us try to understand the pricing details of Amazon Redshift.

Presto vs Snowflake: Data Warehousing Comparisons

May 27, 20228 min read

Snowflake is a cloud data warehouse that offers a cloud-based data storage and analytics service. Snowflake runs completely on cloud infrastructure.

AWS Redshift Data Warehouse Architecture | Ahana

May 24, 20228 min read

Amazon Redshift is a cloud data warehouse offered as a managed service by AWS, and a popular choice for business intelligence and reporting use cases

What Is Trino?

May 22, 20228 min read

Heard about Trino and curious about what it is? This article breaks down what it is, how it’s started, and how Trino is used.

What Is AWS Redshift Used For | Redshift Use Cases

May 13, 20226 min read

Amazon Redshift is one of the most widely-used services in the AWS ecosystem and is a familiar component in many cloud architectures.

ETL and ELT | What are the differences between ETL and ELT?

May 12, 20225 min read

ETL and ELT in Data Warehousing What is the difference between ETL and ELT? What is ETL used for? If you’re looking to understand, ETL and ELT differences let’s start … Continue reading ETL and ELT | What are the differences between ETL and ELT?

The Differences Between AWS RedShift Spectrum vs Athena

May 1, 20225 min read

AWS Redshift Spectrum vs Athena: Redshift is the storage and Redshift Spectrum is a SQL engine extension. Athena is a standalone SQL engine

How Much Does Amazon Athena Cost? | Ahana

Apr 25, 20224 min read

Understanding AWS Athena Costs with Examples What Is Amazon Athena?  Since you’re reading this to understand Athena costs, you likely already know, so we’ll just very briefly touch on what … Continue reading How Much Does Amazon Athena Cost? | Ahana

5 Components of Data Warehouse Architecture | Ahana

Apr 25, 20225 min read

In this article we’ll look at the contextual requirements of a data warehouse, which are the five components of a data warehouse.

What is a Data Lakehouse Architecture?

Apr 16, 20225 min read

Overview The term Data Lakehouse has become very popular over the last year or so, especially as more customers are migrating their workloads to the cloud. This article will help … Continue reading What is a Data Lakehouse Architecture?

AWS Lake Formation for Enterprise Data Lakes | Ahana Cloud

Apr 6, 20223 min read

AWS Lake Formation is a service that makes it easy to set up a secure data lake very quickly (in a matter of days), providing a governance layer for data lakes on AWS S3. 

How to Use AWS Athena to Query JSON Data | Ahana

Mar 30, 20224 min read

A popular use case is to use Athena to query Parquet, ORC, CSV and JSON files that are typically used for querying directly, or transformed and loaded into a data warehouse.

The Differences Between AWS Athena and AWS Glue | Ahana

Mar 16, 20224 min read

Here, we are going to talk about AWS Athena vs Glue, which is an interesting pairing as they are both complementary and competitive. So, what are they exactly?

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20224 min read

Querying Parquet Files using AWS Amazon Athena Parquet is one of the latest file formats with many advantages over some of the more commonly used formats like CSV and JSON. … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

AWS Lake Formation Blueprints | Amazon Blueprint Types

Mar 7, 20222 min read

This article is focused on the first step and how AWS Lake Formation Blueprints can make that easy and automated. Before you can run analytics to get insights, you need your data continuously pooling into your lake!

How To Query Data in AWS S3 Using Athena | Ahana

Mar 1, 20224 min read

Learn how to use Athena to query Amazon S3 and start running queries on your S3 data lake. Query JSON, Apache Parquet, Apache ORC, CSV, and more.

Difference Between AWS Lake Formation vs AWS Glue

Feb 22, 20223 min read

AWS Lake Formation vs AWS Glue – What are the differences? As you start building your analytics stack in AWS, there are several AWS technologies to understand as you begin. … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Limitations of Amazon S3 Select | AWS Select Capabilities

Feb 2, 20226 min read

Amazon S3 Select Limitations What is Amazon S3 Select? Amazon S3 Select allows you to use simple structured query language (SQL) statements to filter the contents of an Amazon S3 … Continue reading Limitations of Amazon S3 Select | AWS Select Capabilities

What is AWS Lake Formation? | Amazon S3 Lake formation

Jan 31, 20222 min read

What is AWS Lake Formation? For AWS users who want to get governance on their data lake, AWS Lake Formation is a service that makes it easy to set up … Continue reading What is AWS Lake Formation? | Amazon S3 Lake formation

How does Presto work with LDAP | Presto LDAP Authentication

Jan 28, 20223 min read

LDAP is an industry standard application used for directory services authentication. Learn how does Presto work with LDAP

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20223 min read

What is Apache Ranger? Apache Ranger is a framework to enable, monitor and manage comprehensive data security across the data platform. It is an open-source authorization solution that provides access … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Presto functions: mathematical, operators and aggregate

Sep 21, 20216 min read

Presto functions. Presto offers several classes of functions and operators. Learn more about them and their use.

What is a Presto lag example?

Aug 31, 20212 min read

The Presto lag function a window function that returns the value of an offset before the current row in a window. One common use case for the lag function is … Continue reading What is a Presto lag example?

How do I get the date_diff from previous rows?

Aug 24, 20211 min read

To find the difference in time between consecutive dates in a result set, Presto offers window functions. Take the example table below which contains sample data of users who watched … Continue reading How do I get the date_diff from previous rows?

How do I use the approx_percentile function in Presto?

Aug 9, 20216 min read

The Presto approx_percentile is one of the approximate aggregate functions, and it returns an approximate percentile for a set of values (e.g. column). In this short article, we will explain … Continue reading How do I use the approx_percentile function in Presto?

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 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?

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

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

Presto EMR S3 Timeout Error | Presto Query Timeout | Ahana

Jun 24, 20212 min read

Why am I getting a Presto EMR S3 timeout error? If you’re using AWS EMR Presto, you can use the S3 select pushdown feature to push down compute operations (i.e. … Continue reading Presto EMR S3 Timeout Error | Presto Query Timeout | Ahana

Do I need to move my data to query it with Presto?

Jun 3, 20211 min read

No, Presto queries your data in-place so you don’t need to move it. If you’re using AWS S3 for your data lake, for example, you wouldn’t need to ingest it … Continue reading Do I need to move my data to query it with Presto?

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

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

Difference Between Managed Table & External Tables | Ahana

May 4, 20212 min read

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

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.

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

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