PrestoDB: The Ultimate PrestoDB Course

Discover Presto, an open source distributed query engine that performs interactive analytics across disparate data sources without storing data, using a pluggable backend, in-memory parallel execution, and SQL support.

Explore Presto architecture with a coordinator and workers, including a discovery service, enabling SQL queries on diverse data sources through pluggable connectors and metadata, data location, and data stream APIs.

Get started with Presto by using the Presto sandbox in a VirtualBox, importing the VM, and accessing it at 192.168.1.3 with the username Presto and the password presto.

Deploy presto as a standalone cluster or co-located with Hadoop, minimize latency via network to hive metastore and hdfs, and meet Java 8 and 16 GB RAM requirements.

Install a single-node Presto, verify Java, configure node properties and config files, enable discovery server, and set up a TPC catalog to run queries.

Install java on mac, windows, and linux using a click-through installer or rpm, verify java eight update 60 for presto, and test the installation from the command line.

Download Presto and extract it to a chosen location on a single machine, establishing the installation directory with server, lib, and plugin components and connectors such as MySQL and Postgres.

Configure a single-node Presto by placing config files in the ETSI directory, enabling the coordinator to serve as a worker, and adding a catalog with a TPK connector.

Learn to add a hive connector to Presto, configure hive properties, start Presto, and run queries to create and insert data into a hive-backed table, then query results.

Learn to add a PostgreSQL connector in Presto using a properties file in the ETSI catalog. Create multiple catalogs to conduct federated queries across PostgreSQL databases.

Learn how to query data in S3 using the Hive connector by creating an external table in Hive and querying it from Presto, including geolocation data and access permissions.

Learn to perform data federation in Presto by querying across multiple data sources, joining S3 and PostgreSQL data in a single query using federated queries and fully qualified names.

Learn to use presto-admin to install, uninstall, upgrade, and manage a presto cluster across multiple nodes, including distribution of configuration and connectors like hive, with start, stop, and restart operations.

Install presto admin with pip to deploy presto on a cluster of EMR or Hadoop, then run sudo commands and explore basic presto admin tasks.

Configure Presto by defining coordinator and worker roles, securing SSL access for a single cluster user, and editing the Presto admin config file in /etc/presto-admin to enable proper cluster communication.

Explore how to use presto admin to install java on all cluster nodes, ensuring the required java eight update 60, deploying Oracle JDK via rpm across coordinator and workers.

Learn to install presto using presto admin, configure the coordinator and workers, deploy configs across a cluster, resolve port conflicts, start services, and run a basic query.

Connect to a Hive through Presto by creating and deploying the Hive connector properties file across all cluster nodes, restarting Presto, and verifying the connector with a server status check.

Install Presto through the Anbari management console using the Embury Presto plugin, set up the Presto directory, make files executable, and restart the Embury server to enable Presto.

Install presto with the Embury plug in on an Ambari cluster, configure the hive connector using the coordinator IP and port 80–85, then verify catalogs and nation tables.

Install and configure Presto yarn integration by building the package with Maven, deploying the yarn package to Ambari, restarting the server, and creating a Presto view in slider for Ambari.

Create and configure a Presto app to deploy a coordinator with two workers, adjust memory and ports, add custom properties, and verify catalogs and sample queries.

Explore the Presto web UI to monitor a cluster and individual queries, inspect stages, splits, and memory, diagnose slow queries, and manage query details and cancellation.

Master presto admin commands to manage and monitor a presto cluster, including deployment, configuration, memory settings, log collection, and diagnostics for coordinators and workers.

Learn how Kerberos authenticates Presto clients and coordinators, with emphasis on the hive connector. Configure principal and keytab, update the Java Cryptography Extension policy, and enable authentication.

Demonstrates configuring authorization in Presto with the hive connector, using default security modes, issuing grant and revoke commands, deploying properties via Presto admin, and testing access across users.

Learn how explain plans reveal Presto query execution from table scans to pre aggregation and final aggregation, using region key partitioning and fragments for distributed planning.

Learn how Presto coordinates query execution from parsing and planning to fragments and stages, then schedules tasks, pipelines, drivers, and operators across workers.

Explore PrestoDB memory management, including system, user, and reserve pools with default allocations (40%, 10%, 50%), and how max memory per node shapes concurrency and deadlock avoidance.

Explore presto tuning through cluster configuration and query rewriting to optimize joins and memory, covering node scheduler topology, max worker threads, memory limits, and distributed versus broadcast joins.

Learn the file formats supported by Presto, including ORC, Parquet, and text, and see how ORC provides faster queries; specify format in create table and insert data.

Configure resource management in Presto by defining queue templates and rules in a JSON file, control concurrent and queued queries, and balance load across user, admin, and global queues.

Explore how to download and set up PrestoDB JDBC drivers, including open source Java 8 driver and Teradata JDBC 4.0, with steps for Mac, Windows, and Linux.

Learn how to install the JDBC and ODBC drivers on Mac by adjusting security and privacy, opening the installer, and using the default installation location with password entry.

Install the ABC ODBC driver on Linux, build with configure, make, and make install, then test with the unixODBC driver manager to connect to Presto.

Learn to use the Presto JDBC driver to query Presto from a Java program, including downloading the driver, configuring connections, catalogs, and schema, and running a query that prints results.

Connect Tablo to Presto using the Presto OBC driver, select the server and schema, and drag a table to generate real-time Presto queries with measures like total price.