Presto Training & Learning Center

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?

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?

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?

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

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

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 is a general purpose computation engine for large-scale data processing. Spark SQL is the Spark module for working with structured data

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Are you using Apache Superset? Learn how to simplify your BI reporting by integrating Apache Superset with Presto

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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