# prestodb/presto **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/prestodb-presto).** 16,662 stars · 5,530 forks · Java · apache-2.0 ## Links - GitHub: https://github.com/prestodb/presto - Homepage: http://prestodb.io - awesome-repositories: https://awesome-repositories.com/repository/prestodb-presto.md ## Topics `big-data` `data` `hadoop` `hive` `java` `lakehouse` `presto` `query` `sql` ## Description Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing model that coordinates tasks across worker nodes. It incorporates cost-based query optimization to rewrite execution paths based on table statistics and historical data, ensuring efficient resource utilization. To maintain stability during large-scale operations, the system features a memory-spilling execution engine that offloads intermediate results to disk when memory thresholds are exceeded. The platform provides extensive capabilities for multi-tenant resource management, allowing administrators to enforce concurrency, memory, and CPU limits through hierarchical resource grouping. It supports a wide range of analytical operations, including advanced windowing, geospatial processing, and probabilistic data structures for approximate statistics. Security is integrated through granular access control policies, role-based authentication, and encrypted communication across the cluster. Presto is implemented in Java and supports deployment via containerized instances or distributed cluster orchestration in Kubernetes environments. ## Tags ### Data & Databases - [Cross-Source Querying](https://awesome-repositories.com/f/data-databases/data-querying/cross-source-querying.md) — Executes SQL queries against external databases by mapping remote tables to local schemas for unified analysis. ([source](http://prestodb.io/docs/current/connector/scylladb.html)) - [Distributed Query Engines](https://awesome-repositories.com/f/data-databases/distributed-query-engines.md) — Provides a high-performance distributed engine for executing interactive analytical queries across heterogeneous data sources. ([source](http://prestodb.io/docs/current/installation.html)) - [Distributed SQL Engines](https://awesome-repositories.com/f/data-databases/distributed-sql-engines.md) — Executes interactive analytical queries across heterogeneous data sources using a unified SQL interface. - [Federated Data Query Engines](https://awesome-repositories.com/f/data-databases/federated-data-query-engines.md) — Integrates and joins data from diverse storage systems without requiring data migration to a central repository. ([source](http://prestodb.io/docs/current/connector.html)) - [Cost-Based Optimizers](https://awesome-repositories.com/f/data-databases/query-optimizers/cost-based-optimizers.md) — Provides cost-based query optimization to rewrite execution paths based on table statistics and historical data. - [SQL Query Execution Engines](https://awesome-repositories.com/f/data-databases/sql-query-execution-engines.md) — Provides a high-performance distributed SQL engine for interactive analytical queries across heterogeneous data sources. ([source](http://prestodb.io/docs/current/)) - [SQL Query Interfaces](https://awesome-repositories.com/f/data-databases/sql-query-interfaces.md) — Provides a terminal-based shell for running ad-hoc queries against distributed data sources and viewing results directly in the command line. ([source](http://prestodb.io/docs/current/clients/presto-cli.html)) - [Advanced Analytics Functions](https://awesome-repositories.com/f/data-databases/data-analysis-visualization/analytical-platforms-engines/advanced-analytics-functions.md) — Provides advanced analytical functions including windowing, geospatial processing, and probabilistic data structures. ([source](http://prestodb.io/docs/current/functions.html)) - [Metadata-Driven Schema Mappers](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/schema-mapping/metadata-driven-schema-mappers.md) — Exposes external data structures as relational tables by mapping remote metadata and types to a consistent internal representation. - [Data Source Connectivity Tools](https://awesome-repositories.com/f/data-databases/data-source-connectivity-tools.md) — Provides standardized interfaces and drivers for executing distributed SQL queries across heterogeneous data environments. ([source](http://prestodb.io/docs/current/clients.html)) - [Federated Databases](https://awesome-repositories.com/f/data-databases/federated-databases.md) — Integrates diverse storage environments into a single logical namespace for cross-platform data analysis. - [Pluggable Connector Frameworks](https://awesome-repositories.com/f/data-databases/pluggable-storage-drivers/pluggable-connector-frameworks.md) — Uses a standardized service interface to integrate heterogeneous data sources and storage systems into a unified query engine. - [Statistical Aggregators](https://awesome-repositories.com/f/data-databases/data-analysis-visualization/analytical-platforms-engines/advanced-analytics-functions/statistical-aggregators.md) — Calculates summary statistics such as counts, averages, and bitwise operations across groups of input data. ([source](http://prestodb.io/docs/current/functions/aggregate.html)) - [Trino Connectors](https://awesome-repositories.com/f/data-databases/data-integration-synchronization/data-integration/data-source-connections/trino-connectors.md) — Enables the development of custom connectors to integrate and join external data sources. ([source](http://prestodb.io/docs/current/develop.html)) - [Data Modification Interfaces](https://awesome-repositories.com/f/data-databases/data-modification-interfaces.md) — Performs read, insert, update, and delete operations on tables using standard SQL syntax. ([source](http://prestodb.io/docs/current/connector/kudu.html)) - [Data Virtualization](https://awesome-repositories.com/f/data-databases/data-virtualization.md) — Maps remote data structures to relational schemas, allowing users to query external systems without moving data. - [BigQuery Connectors](https://awesome-repositories.com/f/data-databases/database-connectivity/bigquery-connectors.md) — Connects to cloud-based data warehouses to perform SQL queries and join data across heterogeneous sources. ([source](http://prestodb.io/docs/current/connector/bigquery.html)) - [Table Property Management](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-management/schema-designers/table-schemas/table-property-management.md) — Trino updates storage or engine-specific settings for a table to optimize performance or behavior without altering the underlying data schema. ([source](http://prestodb.io/docs/current/sql/alter-table.html)) - [Database Query Joins](https://awesome-repositories.com/f/data-databases/database-query-joins.md) — Automatically selects between partitioned and broadcast join strategies to optimize query performance based on data size and memory constraints. ([source](http://prestodb.io/docs/current/optimizer/cost-based-optimizations.html)) - [Grouped Aggregations](https://awesome-repositories.com/f/data-databases/grouped-aggregations.md) — Divides query results into groups based on column values to perform calculations on subsets of data. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Materialized Views](https://awesome-repositories.com/f/data-databases/materialized-views.md) — Persists query results to disk to accelerate data retrieval and improve read performance. ([source](http://prestodb.io/docs/current/sql/create-materialized-view.html)) - [Resource Governance](https://awesome-repositories.com/f/data-databases/multi-tenant-data-management/resource-governance.md) — Enforces CPU, memory, and concurrency limits for different users and workloads to ensure cluster stability in shared environments. - [Memory-Spilling Engines](https://awesome-repositories.com/f/data-databases/persistent-storage-providers/memory-disk-layering/memory-spilling-engines.md) — Offloads intermediate query results to disk when memory thresholds are exceeded to ensure stability during large-scale analytical processing. - [Execution Performance Analyzers](https://awesome-repositories.com/f/data-databases/query-performance-analyzers/execution-performance-analyzers.md) — Provides detailed distributed execution plans and operator-level metrics to identify performance bottlenecks. ([source](http://prestodb.io/docs/current/sql/explain-analyze.html)) - [Execution Detail Visualizers](https://awesome-repositories.com/f/data-databases/query-performance-monitors/execution-detail-visualizers.md) — Visualizes query performance metrics and execution plans to help identify bottlenecks. ([source](http://prestodb.io/docs/current/clients/presto-console.html)) - [Relational Join Engines](https://awesome-repositories.com/f/data-databases/relational-join-engines.md) — Combines data from different sources based on related columns. ([source](http://prestodb.io/docs/current/sql/select.html)) - [SQL Engines](https://awesome-repositories.com/f/data-databases/sql-engines.md) — Supports complex data manipulation through advanced SQL operations like UPDATE and MERGE. ([source](http://prestodb.io/docs/current/connector/iceberg.html)) - [Virtual Table Definitions](https://awesome-repositories.com/f/data-databases/view-definitions/virtual-table-definitions.md) — Stores queries as virtual tables that execute underlying logic whenever referenced to simplify data access. ([source](http://prestodb.io/docs/current/sql/create-view.html)) - [Cardinality Estimation](https://awesome-repositories.com/f/data-databases/cardinality-estimation.md) — Approximates the number of unique values in a dataset using probabilistic algorithms. ([source](http://prestodb.io/docs/current/functions/aggregate.html)) - [Time-Travel Query Interfaces](https://awesome-repositories.com/f/data-databases/data-access-querying/historical-data-querying-interfaces/time-travel-query-interfaces.md) — Supports time-travel analysis by accessing previous versions of table data using snapshot identifiers or timestamps. ([source](http://prestodb.io/docs/current/connector/iceberg.html)) - [Atomic Transaction Execution](https://awesome-repositories.com/f/data-databases/data-integration-synchronization/data-integration/database-integrations/atomic-transaction-execution.md) — Supports multi-statement transactions with snapshot isolation for atomic updates. ([source](http://prestodb.io/docs/current/connector/iceberg.html)) - [Join Skew Mitigators](https://awesome-repositories.com/f/data-databases/data-joins/join-skew-mitigators.md) — Rewrites join keys containing excessive null values based on historical distribution data to prevent performance bottlenecks. ([source](http://prestodb.io/docs/current/optimizer/history-based-optimization.html)) - [Data Lake Acceleration](https://awesome-repositories.com/f/data-databases/data-lake-acceleration.md) — Reads data from table formats by accessing metadata directly from storage or metastores. ([source](http://prestodb.io/docs/current/connector/deltalake.html)) - [Data Type Mappings](https://awesome-repositories.com/f/data-databases/data-type-mappings.md) — Converts data types between the local engine and external systems to ensure compatibility. ([source](http://prestodb.io/docs/current/connector/elasticsearch.html)) - [Oracle Database Querying](https://awesome-repositories.com/f/data-databases/database-connectivity/oracle-connectors/oracle-database-querying.md) — Enables querying and joining data from Oracle databases alongside other heterogeneous sources. ([source](http://prestodb.io/docs/current/connector/oracle.html)) - [Table Metadata Inspection](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-management/schema-designers/table-schemas/table-metadata-inspection.md) — Trino retrieves a list of columns for a specified table including data types, precision, scale, and metadata comments to assist with query construction. ([source](http://prestodb.io/docs/current/sql/describe.html)) - [Join Strategy Selectors](https://awesome-repositories.com/f/data-databases/database-query-joins/join-strategy-selectors.md) — Selects between partitioned, broadcast, or cost-based join strategies to optimize performance based on table size and memory. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Database Schema Managers](https://awesome-repositories.com/f/data-databases/database-schema-managers.md) — Exposes remote database structures for discovery and interaction through standard query commands. ([source](http://prestodb.io/docs/current/connector/postgresql.html)) - [Disk-Based Offloading Systems](https://awesome-repositories.com/f/data-databases/disk-caching-systems/disk-based-offloading-systems.md) — Moves intermediate results to local storage when memory usage exceeds defined limits to allow completion of large-scale operations. ([source](http://prestodb.io/docs/current/admin/spill.html)) - [Distributed Data Caching Layers](https://awesome-repositories.com/f/data-databases/distributed-caching/distributed-data-caching-layers.md) — Stores files and objects from remote storage in a local cache layer to speed up data retrieval. ([source](http://prestodb.io/docs/current/connector/hive.html)) - [Distributed Query Stream Processors](https://awesome-repositories.com/f/data-databases/distributed-query-processing/distributed-query-stream-processors.md) — Executes query plans through a hierarchy of stages, tasks, and operators that transform and exchange data across the cluster. ([source](http://prestodb.io/docs/current/overview/concepts.html)) - [Grouped Filters](https://awesome-repositories.com/f/data-databases/grouped-filters.md) — Enables conditional filtering of aggregated data groups to refine analytical results. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Prepared Statements](https://awesome-repositories.com/f/data-databases/prepared-statements.md) — Executes parameterized query templates to improve performance and prevent injection. ([source](http://prestodb.io/docs/current/sql/execute.html)) - [Query Planning](https://awesome-repositories.com/f/data-databases/query-planning.md) — Transforms declarative SQL into efficient logical and physical execution plans for distributed processing. ([source](http://prestodb.io/docs/current/overview/concepts.html)) - [Execution Plan Exporters](https://awesome-repositories.com/f/data-databases/query-planning/execution-plan-exporters.md) — Displays logical or distributed execution plans for SQL statements to validate syntax and data processing paths. ([source](http://prestodb.io/docs/current/sql/explain.html)) - [Cassandra Connectors](https://awesome-repositories.com/f/data-databases/sql-query-interfaces/cassandra-connectors.md) — Connects to Cassandra or ScyllaDB clusters to perform SQL queries and map native data types. ([source](http://prestodb.io/docs/current/connector/cassandra.html)) - [Performance Metric Exposure](https://awesome-repositories.com/f/data-databases/sql-query-interfaces/system-state-querying/performance-metric-exposure.md) — Exposes internal system and connector performance data as virtual tables for SQL-based monitoring and analysis. ([source](http://prestodb.io/docs/current/admin/jmx-metrics.html)) - [Database Indexes](https://awesome-repositories.com/f/data-databases/table-indexing-systems/database-indexes.md) — Maintains secondary index tables to accelerate query execution and row retrieval. ([source](http://prestodb.io/docs/current/connector/accumulo.html)) - [Window Functions](https://awesome-repositories.com/f/data-databases/window-functions.md) — Computes aggregate, ranking, or value-based metrics across defined partitions and sliding frames of rows. ([source](http://prestodb.io/docs/current/functions/window.html)) - [Business Intelligence Connectors](https://awesome-repositories.com/f/data-databases/business-intelligence-connectors.md) — Integrates with external business intelligence platforms to perform interactive analysis of distributed datasets. ([source](http://prestodb.io/docs/current/clients/tableau.html)) - [Business Intelligence Platforms](https://awesome-repositories.com/f/data-databases/business-intelligence-platforms.md) — Connects visualization and business intelligence platforms to distributed datasets for real-time analysis via standard interfaces. - [Data Write Throughput Optimizers](https://awesome-repositories.com/f/data-databases/concurrent-write-optimizations/data-write-throughput-optimizers.md) — Redistributes data across nodes to prevent skew and dynamically scales writer tasks to improve throughput. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Custom Data Types](https://awesome-repositories.com/f/data-databases/custom-data-types.md) — Implements new data types to support specialized data structures or formats not natively provided by the core engine. ([source](http://prestodb.io/docs/current/develop.html)) - [Statistical Sampling](https://awesome-repositories.com/f/data-databases/data-management/sample-data-loaders/statistical-sampling.md) — Retrieves a representative subset of data from a table using statistical or logical sampling methods. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Columnar Dataset Querying](https://awesome-repositories.com/f/data-databases/data-processing-pipelines/data-processing/dataset-formats/columnar-dataset-querying.md) — Reads and writes data stored in columnar formats by mapping dataset fragments to parallel processing splits. ([source](http://prestodb.io/docs/current/connector/lance.html)) - [Data Type Casting](https://awesome-repositories.com/f/data-databases/data-type-casting.md) — Transforms values between different data types explicitly with support for null-handling on conversion failure. ([source](http://prestodb.io/docs/current/functions/conversion.html)) - [Table Schemas](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-management/schema-designers/table-schemas.md) — Manages table structures and metadata using standard SQL commands. ([source](http://prestodb.io/docs/current/connector/lance.html)) - [Schema Modification](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-management/schema-designers/table-schemas/schema-modification.md) — Updates table structures by renaming elements and modifying column constraints. ([source](http://prestodb.io/docs/current/sql/alter-table.html)) - [External Data Access](https://awesome-repositories.com/f/data-databases/external-data-access.md) — Accesses diverse storage systems and databases through a pluggable architecture to enable cross-platform data analysis. ([source](http://prestodb.io/docs/current/)) - [Management](https://awesome-repositories.com/f/data-databases/materialized-views/management.md) — Provides controls for managing materialized view freshness and cost-based selection for query optimization. ([source](http://prestodb.io/docs/current/admin/properties-session.html)) - [Refresh](https://awesome-repositories.com/f/data-databases/materialized-views/refresh.md) — Ensures materialized views reflect current data by re-executing underlying queries. ([source](http://prestodb.io/docs/current/sql/refresh-materialized-view.html)) - [Query Management](https://awesome-repositories.com/f/data-databases/query-management.md) — Controls task parallelism, memory spilling, and writer scaling to balance resource utilization and query throughput. ([source](http://prestodb.io/docs/current/admin/properties-session.html)) - [Query Lifecycle Policies](https://awesome-repositories.com/f/data-databases/query-management/query-lifecycle-policies.md) — Sets timeouts, queue limits, and execution priorities to manage how long queries wait and run before termination. ([source](http://prestodb.io/docs/current/admin/properties-session.html)) - [Data Layout Optimizers](https://awesome-repositories.com/f/data-databases/query-optimizations/data-layout-optimizers.md) — Arranges table data during write operations using specific sort orders to make filtering and searching more efficient. ([source](http://prestodb.io/docs/current/connector/iceberg.html)) - [Execution Statistics](https://awesome-repositories.com/f/data-databases/query-optimizers/execution-statistics.md) — Records execution statistics from past queries to refine future query plans and improve performance. ([source](http://prestodb.io/docs/current/optimizer/history-based-optimization.html)) - [Query Statistics Repositories](https://awesome-repositories.com/f/data-databases/query-performance-monitors/query-statistics-repositories.md) — Saves execution metrics in a database to inform future query planning and improve the efficiency of subsequent analytical tasks. ([source](http://prestodb.io/docs/current/plugin/redis-hbo-provider.html)) - [Statistics Collectors](https://awesome-repositories.com/f/data-databases/query-performance-monitors/query-statistics-repositories/statistics-collectors.md) — Gathers metadata about row counts and column distributions to help the query planner choose efficient execution paths. ([source](http://prestodb.io/docs/current/connector/hive.html)) - [Redis Clients](https://awesome-repositories.com/f/data-databases/redis-clients.md) — Exposes Redis key-value pairs as relational tables for cross-system analysis. ([source](http://prestodb.io/docs/current/connector/redis.html)) - [Remote Query Execution](https://awesome-repositories.com/f/data-databases/remote-query-execution.md) — Sends SQL statements from a client environment to a distributed query engine and retrieves resulting data sets for local processing. ([source](http://prestodb.io/docs/current/clients/js.html)) - [Subquery Support](https://awesome-repositories.com/f/data-databases/subquery-support.md) — Evaluates nested queries that reference columns from the outer scope for each row processed. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Table Definitions](https://awesome-repositories.com/f/data-databases/table-definitions.md) — Maps raw message keys and payloads to typed columns using JSON configuration files to enable standard SQL operations. ([source](http://prestodb.io/docs/current/connector/kafka-tutorial.html)) - [Object Mappings](https://awesome-repositories.com/f/data-databases/table-definitions/object-mappings.md) — Exposes document collections as relational tables by mapping fields to SQL-compatible data types. ([source](http://prestodb.io/docs/current/connector/mongodb.html)) - [CTE Materialization Engines](https://awesome-repositories.com/f/data-databases/virtual-table-querying/cte-materialization-engines.md) — Saves the results of repeated subqueries in temporary storage to prevent redundant calculations and speed up execution. ([source](http://prestodb.io/docs/current/admin/cte-materialization.html)) - [Table Creation](https://awesome-repositories.com/f/data-databases/virtual-table-querying/table-creation.md) — Enables creating and populating new tables directly from query results with custom storage settings. ([source](http://prestodb.io/docs/current/sql/create-table-as.html)) - [Table Format Integrations](https://awesome-repositories.com/f/data-databases/virtual-table-querying/table-format-integrations.md) — Integrates with metastores to query data stored in specialized table formats like Hudi. ([source](http://prestodb.io/docs/current/connector/hudi.html)) - [Temporal Truncators](https://awesome-repositories.com/f/data-databases/as-of-merges/temporal-truncators.md) — Rounds timestamps down to the start of a specified unit, such as the beginning of a day or month. ([source](http://prestodb.io/docs/current/functions/datetime.html)) - [Private Cardinality Estimators](https://awesome-repositories.com/f/data-databases/cardinality-estimation/private-cardinality-estimators.md) — Generates probabilistic sketches for approximate distinct counts with privacy protections. ([source](http://prestodb.io/docs/current/functions/noisy.html)) - [Metadata Query Interfaces](https://awesome-repositories.com/f/data-databases/cluster-query-interfaces/metadata-query-interfaces.md) — Retrieves real-time information and performance metrics about the running cluster using standard SQL queries. ([source](http://prestodb.io/docs/current/connector/system.html)) - [Complex Data Types](https://awesome-repositories.com/f/data-databases/complex-data-types.md) — Organizes information into arrays, maps, and nested structures to support complex data models within SQL queries. ([source](http://prestodb.io/docs/current/language/types.html)) - [Write Task Scalers](https://awesome-repositories.com/f/data-databases/concurrent-write-optimizations/write-task-scalers.md) — Adjusts the initial number of concurrent write tasks based on historical output volume to optimize file creation. ([source](http://prestodb.io/docs/current/optimizer/history-based-optimization.html)) - [Metastore Integrations](https://awesome-repositories.com/f/data-databases/connection-management/metastore-integrations.md) — Connects to central repositories to access table definitions and structural details for data stored in various formats. ([source](http://prestodb.io/docs/current/connector/hive.html)) - [Remote Dataset Caching](https://awesome-repositories.com/f/data-databases/data-caching/remote-dataset-caching.md) — Stores data from various sources in a local cache to reduce network latency and input/output overhead. ([source](http://prestodb.io/docs/current/cache/local.html)) - [Data Constraints](https://awesome-repositories.com/f/data-databases/data-constraints.md) — Enforces data integrity and validation rules through primary key and unique constraints. ([source](http://prestodb.io/docs/current/sql/alter-table.html)) - [Query Result Caching](https://awesome-repositories.com/f/data-databases/data-engineering-infrastructure/caching-performance/caching-strategies/query-result-caching.md) — Saves the output of complex calculations to disk to avoid redundant processing and provide faster access. ([source](http://prestodb.io/docs/current/admin/materialized-views.html)) - [Data Schemas](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/data-schemas.md) — Structures data into catalogs, schemas, and tables for consistent cross-source querying. ([source](http://prestodb.io/docs/current/overview/concepts.html)) - [Schema Evolution](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/schema-evolution.md) — Supports schema changes over time by allowing type conversions and handling backward-compatible schema definitions. ([source](http://prestodb.io/docs/current/connector/hive.html)) - [Data Versioning](https://awesome-repositories.com/f/data-databases/data-management/table-data-managers/data-versioning.md) — Captures specific snapshots of data using system versions or timestamps for historical analysis. ([source](http://prestodb.io/docs/current/sql/alter-table.html)) - [Data Partitioning](https://awesome-repositories.com/f/data-databases/data-partitioning.md) — Configures hash or range partitioning schemes during table creation to optimize data distribution and query performance. ([source](http://prestodb.io/docs/current/connector/kudu.html)) - [Array Manipulation Utilities](https://awesome-repositories.com/f/data-databases/data-processing-pipelines/data-transformation/array-tensor-manipulation/array-manipulation-utilities.md) — Performs set operations, statistical calculations, and sorting on array elements to transform complex data structures. ([source](http://prestodb.io/docs/current/functions/plugin-loaded-functions.html)) - [Flight Streaming Interfaces](https://awesome-repositories.com/f/data-databases/data-querying/cross-source-querying/flight-streaming-interfaces.md) — Executes SQL queries against data sources exposed via flight servers for parallel data streaming. ([source](http://prestodb.io/docs/current/connector/base-arrow-flight.html)) - [Data Serialization Formats](https://awesome-repositories.com/f/data-databases/data-serialization-formats.md) — Supports pluggable serialization formats for reading and writing data with custom encoding implementations. ([source](http://prestodb.io/docs/current/connector/accumulo.html)) - [JSON](https://awesome-repositories.com/f/data-databases/data-serialization-formats/data-formats/json.md) — Parses and stores JSON strings as objects within document fields to support flexible data structures. ([source](http://prestodb.io/docs/current/connector/mongodb.html)) - [JSON Serialization](https://awesome-repositories.com/f/data-databases/data-serialization-formats/json-serialization.md) — Converts between JSON values and their string representations using standard parsing and formatting functions. ([source](http://prestodb.io/docs/current/functions/json.html)) - [Text Transformation Functions](https://awesome-repositories.com/f/data-databases/data-transformation-functions/text-transformation-functions.md) — Modifies text content through pattern replacement and extraction. ([source](http://prestodb.io/docs/current/functions/plugin-loaded-functions.html)) - [Cloud Data Warehouse Connectivity](https://awesome-repositories.com/f/data-databases/data-warehouse-integrations/cloud-data-warehouse-connectivity.md) — Provides secure, real-time interactive connectivity to cloud-hosted data warehouse clusters for SQL analysis. ([source](http://prestodb.io/docs/current/connector/redshift.html)) - [SQL Query Execution](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-operations/sql-query-execution.md) — Embeds custom query language strings directly into SQL statements to leverage specialized search and retrieval capabilities. ([source](http://prestodb.io/docs/current/connector/elasticsearch.html)) - [Windowed Row Accessors](https://awesome-repositories.com/f/data-databases/database-schema-mapping/row-mapping-logic/row-record-access/windowed-row-accessors.md) — Retrieves values from relative rows within a partition. ([source](http://prestodb.io/docs/current/functions/window.html)) - [Date and Time Libraries](https://awesome-repositories.com/f/data-databases/date-and-time-libraries.md) — Converts timestamps into formatted strings or parses date and time strings into structured objects. ([source](http://prestodb.io/docs/current/functions/teradata.html)) - [Date Component Extractors](https://awesome-repositories.com/f/data-databases/date-and-time-libraries/date-component-extractors.md) — Retrieves specific units like year, month, day, or hour from date and time values for analytical grouping. ([source](http://prestodb.io/docs/current/functions/datetime.html)) - [Date Manipulation Utilities](https://awesome-repositories.com/f/data-databases/date-manipulation-utilities.md) — Calculates new dates, times, or timestamps by adding or subtracting specified intervals. ([source](http://prestodb.io/docs/current/functions/datetime.html)) - [Distribution Sketching](https://awesome-repositories.com/f/data-databases/distributed-data-processing/distribution-sketching.md) — Generates quantile sketches to approximate the distribution of values for efficient rank calculation. ([source](http://prestodb.io/docs/current/functions/sketch.html)) - [External Data Connectors](https://awesome-repositories.com/f/data-databases/external-data-connectors.md) — Implements a standard service interface to fetch metadata and records from custom external storage systems. ([source](http://prestodb.io/docs/current/connector/thrift.html)) - [Construction Utilities](https://awesome-repositories.com/f/data-databases/geospatial-data-converters/construction-utilities.md) — Enables the creation of geometry and spherical geography objects from various input formats for spatial analysis. ([source](http://prestodb.io/docs/current/functions/geospatial.html)) - [Geospatial Tile Processors](https://awesome-repositories.com/f/data-databases/geospatial-tile-processors.md) — Converts between geographic coordinates and tile representations to support map-based indexing and spatial analysis. ([source](http://prestodb.io/docs/current/functions/geospatial.html)) - [In-Memory Databases](https://awesome-repositories.com/f/data-databases/in-memory-databases.md) — Maintains temporary datasets in worker RAM to provide high-performance, volatile storage for analytical queries. ([source](http://prestodb.io/docs/current/connector/memory.html)) - [JSON Data Parsers](https://awesome-repositories.com/f/data-databases/json-data-parsers.md) — Parses JSON strings into corresponding types with support for partial casting and configurable mapping. ([source](http://prestodb.io/docs/current/functions/json.html)) - [JSON Document Stores](https://awesome-repositories.com/f/data-databases/json-document-stores.md) — Manages native JSON objects and arrays to allow querying of semi-structured data within SQL statements. ([source](http://prestodb.io/docs/current/language/types.html)) - [JSON Processors](https://awesome-repositories.com/f/data-databases/json-processors.md) — Extracts values via paths, validates scalar types, and checks for element existence within JSON documents. ([source](http://prestodb.io/docs/current/functions/json.html)) - [Materialized View Selectors](https://awesome-repositories.com/f/data-databases/materialized-views/materialized-view-selectors.md) — Automatically selects the most efficient materialized view using cost-based analysis for query optimization. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Named Relation Definitions](https://awesome-repositories.com/f/data-databases/named-relation-definitions.md) — Simplifies complex queries by creating temporary, reusable result sets. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Nested Collection Expansion](https://awesome-repositories.com/f/data-databases/nested-collection-expansion.md) — Enables querying of complex data structures by expanding nested collections into relational rows. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Null Value Handling](https://awesome-repositories.com/f/data-databases/null-value-handling.md) — Simplifies data cleaning by providing functions to handle and replace null values. ([source](http://prestodb.io/docs/current/functions/comparison.html)) - [Percentile Calculation](https://awesome-repositories.com/f/data-databases/percentile-calculation.md) — Calculates approximate distribution percentiles for large datasets with configurable accuracy. ([source](http://prestodb.io/docs/current/functions/aggregate.html)) - [Metadata Inspection](https://awesome-repositories.com/f/data-databases/prepared-statements/metadata-inspection.md) — Assists with query planning by providing schema and type metadata for prepared statements. ([source](http://prestodb.io/docs/current/sql/describe-output.html)) - [Parameter Inspection](https://awesome-repositories.com/f/data-databases/prepared-statements/parameter-inspection.md) — Helps verify parameter requirements by inspecting placeholders in prepared queries. ([source](http://prestodb.io/docs/current/sql/describe-input.html)) - [Membership-Based Filtering](https://awesome-repositories.com/f/data-databases/probabilistic-data-structures/probabilistic-membership-filters/membership-based-filtering.md) — Filters records based on membership within specified lists or subqueries. ([source](http://prestodb.io/docs/current/functions/comparison.html)) - [Metric Query Interfaces](https://awesome-repositories.com/f/data-databases/query-engines/metric-query-languages/metric-query-interfaces.md) — Exposes Java Management Extensions data as SQL tables for monitoring and debugging. ([source](http://prestodb.io/docs/current/connector/jmx.html)) - [Query Optimizers](https://awesome-repositories.com/f/data-databases/query-optimizers.md) — Adjusts system parameters and manages memory spilling to optimize performance for complex analytical workloads. ([source](http://prestodb.io/docs/current/admin/properties-session.html)) - [Metadata-Driven Optimizers](https://awesome-repositories.com/f/data-databases/query-performance-monitors/query-statistics-repositories/metadata-driven-optimizers.md) — Uses table-level metadata to inform the query planner and improve execution performance. ([source](http://prestodb.io/docs/current/optimizer/statistics.html)) - [Query Performance Tuning](https://awesome-repositories.com/f/data-databases/query-performance-tuning.md) — Applies cost-based and history-based strategies to improve execution efficiency and resource usage for large-scale data sets. ([source](http://prestodb.io/docs/current/)) - [Query Sorting](https://awesome-repositories.com/f/data-databases/query-sorting.md) — Orders query results by expressions in ascending or descending sequence. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Query Validation](https://awesome-repositories.com/f/data-databases/query-validation.md) — Checks whether queries can be successfully explained and compares execution plans between environments to identify performance or structural differences. ([source](http://prestodb.io/docs/current/admin/verifier.html)) - [Record Deletion](https://awesome-repositories.com/f/data-databases/record-deletion.md) — Deletes specific rows from data sources based on conditional filters. ([source](http://prestodb.io/docs/current/sql/delete.html)) - [JSON Structure Mappers](https://awesome-repositories.com/f/data-databases/redis-clients/object-to-redis-mappers/json-structure-mappers.md) — Maps Redis data structures to relational columns using JSON definitions. ([source](http://prestodb.io/docs/current/connector/redis.html)) - [Set Intersection Analysis](https://awesome-repositories.com/f/data-databases/relationship-management/set-intersection-analysis.md) — Computes intersection cardinality and Jaccard similarity to measure data overlap. ([source](http://prestodb.io/docs/current/functions/khyperloglog.html)) - [Set Operation Engines](https://awesome-repositories.com/f/data-databases/result-set-search/multi-result-set-fetching/set-operation-engines.md) — Combines query results using set operations like union and intersection. ([source](http://prestodb.io/docs/current/sql/select.html)) - [Schema Management](https://awesome-repositories.com/f/data-databases/schema-management.md) — Initializes and manages containers for database objects like tables and views. ([source](http://prestodb.io/docs/current/sql/create-schema.html)) - [Vector Search Indexes](https://awesome-repositories.com/f/data-databases/search-indexing-technologies/search-indexing/search-and-indexing/vector-search-indexes.md) — Creates specialized indexes on table columns containing embeddings to enable high-performance similarity searches. ([source](http://prestodb.io/docs/current/sql/create-vector-index.html)) - [Shared Memory Data Exchange](https://awesome-repositories.com/f/data-databases/shared-memory-data-exchange.md) — Writes intermediate data to disk during execution to support memory-intensive operations and ensure large-scale task completion. ([source](http://prestodb.io/docs/current/admin/exchange-materialization.html)) - [Similarity Search](https://awesome-repositories.com/f/data-databases/similarity-search.md) — Identifies overlaps and near-duplicates using probabilistic MinHash structures for set similarity. ([source](http://prestodb.io/docs/current/functions/setdigest.html)) - [Spatial Aggregation Functions](https://awesome-repositories.com/f/data-databases/spatial-data-extensions/spatial-aggregation-functions.md) — Combines multiple geometry objects into single results using spatial operations. ([source](http://prestodb.io/docs/current/functions/geospatial.html)) - [Spatial Predicate Evaluators](https://awesome-repositories.com/f/data-databases/spatial-indexing/spatial-predicate-evaluators.md) — Evaluates geometric predicates to determine spatial relationships between objects. ([source](http://prestodb.io/docs/current/functions/geospatial.html)) - [Stored Procedures](https://awesome-repositories.com/f/data-databases/stored-procedures.md) — Runs stored procedures and manages transaction lifecycles to support complex data manipulation and multi-step operations. ([source](http://prestodb.io/docs/current/sql.html)) - [Storage Procedures](https://awesome-repositories.com/f/data-databases/stored-procedures/storage-procedures.md) — Executes administrative and data manipulation tasks directly on the storage layer using specialized SQL procedure calls. ([source](http://prestodb.io/docs/current/connector/iceberg.html)) - [Table Deletion](https://awesome-repositories.com/f/data-databases/table-definitions/table-deletion.md) — Deletes existing tables from the data source, optionally suppressing errors if the table does not exist. ([source](http://prestodb.io/docs/current/sql/drop-table.html)) - [Temporal Data Management](https://awesome-repositories.com/f/data-databases/temporal-data-management.md) — Handles calendar dates, timestamps, and interval types for temporal calculations. ([source](http://prestodb.io/docs/current/language/types.html)) - [Text Pattern Matching](https://awesome-repositories.com/f/data-databases/text-pattern-matching.md) — Supports wildcard-based pattern matching for filtering text data. ([source](http://prestodb.io/docs/current/functions/comparison.html)) - [Time Zone Management](https://awesome-repositories.com/f/data-databases/time-zone-management.md) — Adjusts timestamps to specific time zones for accurate query processing. ([source](http://prestodb.io/docs/current/functions/datetime.html)) - [View Definitions](https://awesome-repositories.com/f/data-databases/view-definitions.md) — Defines security execution modes for database views to manage data access policies. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [External Table Querying](https://awesome-repositories.com/f/data-databases/virtual-table-querying/external-table-querying.md) — Integrates external database tables into a unified analytical view for cross-platform SQL querying. ([source](http://prestodb.io/docs/current/connector/clickhouse.html)) - [Table Function Invocation](https://awesome-repositories.com/f/data-databases/virtual-table-querying/external-table-querying/table-function-invocation.md) — Executes functions that return tables directly within SQL queries for dynamic data processing. ([source](http://prestodb.io/docs/current/functions/table.html)) ### Software Engineering & Architecture - [Distributed Query Coordinators](https://awesome-repositories.com/f/software-engineering-architecture/distributed-coordination-systems/distributed-query-coordinators.md) — Parses SQL into distributed execution plans and manages task scheduling across a cluster of worker nodes. - [Extensible Component Architectures](https://awesome-repositories.com/f/software-engineering-architecture/software-architecture/architectural-patterns/modular-decoupled-design/modular-design-patterns/extensible-component-architectures.md) — Integrates custom components such as external data providers or sidecar services to augment core capabilities through a modular plugin architecture. ([source](http://prestodb.io/docs/current/installation.html)) - [Task Execution Engines](https://awesome-repositories.com/f/software-engineering-architecture/task-execution-engines.md) — Processes data by running tasks on worker nodes, fetching data from connectors, and exchanging intermediate results. ([source](http://prestodb.io/docs/current/overview/concepts.html)) - [Parallel Processing Pipelines](https://awesome-repositories.com/f/software-engineering-architecture/parallel-processing-pipelines.md) — Coordinates query execution across worker nodes to process large-scale datasets in parallel. - [Shared-Nothing Processing Engines](https://awesome-repositories.com/f/software-engineering-architecture/shared-nothing-architectures/shared-nothing-processing-engines.md) — Executes tasks independently on worker nodes by exchanging intermediate data through a high-performance network shuffle mechanism. - [Module Functionality Extenders](https://awesome-repositories.com/f/software-engineering-architecture/integration-extensibility/extensibility/plugin-architectures/developer-authoring-interfaces/custom-module-implementations/module-functionality-extenders.md) — Loads custom modules at startup to extend engine functionality with new data sources and logic. ([source](http://prestodb.io/docs/current/installation/deploy-custom-plugins.html)) - [Distributed Sorting](https://awesome-repositories.com/f/software-engineering-architecture/sorting-algorithms/hybrid-sorts/distributed-sorting.md) — Distributes sorting operations across multiple cluster nodes to process data volumes exceeding single-worker memory capacity. ([source](http://prestodb.io/docs/current/admin/dist-sort.html)) - [Cluster Query Schedulers](https://awesome-repositories.com/f/software-engineering-architecture/distributed-coordination-systems/distributed-query-coordinators/cluster-query-schedulers.md) — Distributes incoming SQL queries across multiple query engine clusters to balance load. ([source](http://prestodb.io/docs/current/router.html)) - [Column Access Optimizers](https://awesome-repositories.com/f/software-engineering-architecture/query-optimization/column-access-optimizers.md) — Reads only the specific data fields requested by a query from the storage layer to minimize disk input and output. ([source](http://prestodb.io/docs/current/connector/lance.html)) - [Query-Parameter-Driven Configurations](https://awesome-repositories.com/f/software-engineering-architecture/application-lifecycle-management/configuration-management/configuration-sourcing-and-binding/query-parameter-driven-configurations.md) — Modifies query execution settings at the session level to control performance and behavior. ([source](http://prestodb.io/docs/current/sql/set-session.html)) - [Query Branching](https://awesome-repositories.com/f/software-engineering-architecture/conditional-branching/conditional-expression-returns/query-branching.md) — Executes branching logic within queries by testing expressions or boolean conditions to return specific results. ([source](http://prestodb.io/docs/current/functions/conditional.html)) - [Decimal Comparison Operators](https://awesome-repositories.com/f/software-engineering-architecture/logical-comparison-operators/decimal-comparison-operators.md) — Evaluates equality and magnitude relationships between decimal numbers using standard comparison operators. ([source](http://prestodb.io/docs/current/functions/decimal.html)) ### Security & Cryptography - [Resource Management Groups](https://awesome-repositories.com/f/security-cryptography/account-management/hierarchical-grouping/resource-management-groups.md) — Provides hierarchical resource groups to enforce concurrency, memory, and CPU limits across multi-tenant workloads. ([source](http://prestodb.io/docs/current/admin/resource-groups.html)) - [Data Access Policies](https://awesome-repositories.com/f/security-cryptography/data-source-access-management/data-access-policies.md) — Defines session properties, function namespaces, and security settings to control how users interact with connected data sources. ([source](http://prestodb.io/docs/current/admin.html)) - [Granular Access Controls](https://awesome-repositories.com/f/security-cryptography/granular-access-controls.md) — Enforces granular permissions on catalogs, schemas, tables, and columns. ([source](http://prestodb.io/docs/current/security.html)) - [Access Control](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control.md) — Restricts user operations on tables and data by applying authorization policies defined through configuration or external providers. ([source](http://prestodb.io/docs/current/admin/properties-session.html)) - [Kerberos Authentication](https://awesome-repositories.com/f/security-cryptography/kerberos-authentication.md) — Authenticates the engine against Hadoop services using Kerberos principals and keytabs. ([source](http://prestodb.io/docs/current/connector/hive-security.html)) - [LDAP Services](https://awesome-repositories.com/f/security-cryptography/ldap-services.md) — Validates client credentials against external directory services using LDAP. ([source](http://prestodb.io/docs/current/security/ldap.html)) - [Role-Based Access Control](https://awesome-repositories.com/f/security-cryptography/role-based-access-control.md) — Implements role-based access control to manage user permissions and secure data access. ([source](http://prestodb.io/docs/current/sql.html)) - [Secure Network Communication](https://awesome-repositories.com/f/security-cryptography/secure-network-communication.md) — Secures client-to-coordinator communication using TLS certificates and Java keystores. ([source](http://prestodb.io/docs/current/security/tls.html)) - [User Authentication Strategies](https://awesome-repositories.com/f/security-cryptography/user-authentication-strategies.md) — Verifies user identity using standard protocols like Kerberos, LDAP, and OAuth 2.0. ([source](http://prestodb.io/docs/current/security.html)) - [Communication Encryption](https://awesome-repositories.com/f/security-cryptography/communication-encryption.md) — Secures data in transit between the engine and HDFS using wire encryption. ([source](http://prestodb.io/docs/current/connector/hive-security.html)) - [Data Encryption](https://awesome-repositories.com/f/security-cryptography/data-encryption.md) — Secures internal cluster communication using Java keystores and truststores. ([source](http://prestodb.io/docs/current/security.html)) - [Policy-Based Access Control](https://awesome-repositories.com/f/security-cryptography/policy-based-access-control.md) — Enforces data access restrictions using configurable authorization models including SQL-standard privileges and external policy management. ([source](http://prestodb.io/docs/current/connector/hive-security.html)) - [Secure Connection Handlers](https://awesome-repositories.com/f/security-cryptography/secure-connection-handlers.md) — Encrypts data in transit between the query engine and database hosts using TLS. ([source](http://prestodb.io/docs/current/connector/hana.html)) - [Secure Node Networking](https://awesome-repositories.com/f/security-cryptography/secure-node-networking.md) — Enforces SSL/TLS encryption for all internal network traffic between cluster nodes. ([source](http://prestodb.io/docs/current/security/internal-communication.html)) - [Global Authorization Policies](https://awesome-repositories.com/f/security-cryptography/security/policies/host-resource-access/file-system-access-controls/path-access-restrictions/path-access-restrictions/subject-access-restrictions/global-authorization-policies.md) — Enforces global authorization policies to control user permissions across all connected data sources. ([source](http://prestodb.io/docs/current/security/built-in-system-access-control.html)) - [Query Impersonation](https://awesome-repositories.com/f/security-cryptography/user-access-management/query-impersonation.md) — Enforces granular file system permissions by executing queries as the requesting user. ([source](http://prestodb.io/docs/current/connector/hive-security.html)) - [Cloud Authentication](https://awesome-repositories.com/f/security-cryptography/cloud-authentication.md) — Configures secure access to cloud resources using service account keys and machine roles. ([source](http://prestodb.io/docs/current/connector/bigquery.html)) - [Permission-Based Security](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/access-control-models/permission-based-security.md) — Assigns data manipulation permissions to users or roles and supports delegation of those permissions. ([source](http://prestodb.io/docs/current/sql/grant.html)) - [Execution Context Policies](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/access-control-models/permission-based-security/access-control-policies/execution-context-policies.md) — Manages data access security by defining whether views execute with creator or user permissions. ([source](http://prestodb.io/docs/current/admin/materialized-views.html)) - [Administrative Role Management](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/identity-role-management/administrative-role-management.md) — Enables delegated management of user roles and administrative privileges within data catalogs. ([source](http://prestodb.io/docs/current/sql/grant-roles.html)) - [Security Plugin Frameworks](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/security-plugin-frameworks.md) — Supports custom security plugins to manage user authentication and enforce fine-grained authorization policies. ([source](http://prestodb.io/docs/current/develop.html)) - [Identity Provider Role Mapping](https://awesome-repositories.com/f/security-cryptography/identity-provider-role-mapping.md) — Maps user identities to roles using regular expressions for flexible authorization. ([source](http://prestodb.io/docs/current/security/authorization.html)) - [Client Authentication](https://awesome-repositories.com/f/security-cryptography/kerberos-authentication/client-authentication.md) — Ensures only authorized users can submit queries via Kerberos-validated HTTPS connections. ([source](http://prestodb.io/docs/current/security/server.html)) - [OAuth2 Providers](https://awesome-repositories.com/f/security-cryptography/oauth2-providers.md) — Supports secure user authentication via OAuth2 and OpenID Connect for external identity provider integration. ([source](http://prestodb.io/docs/current/security/oauth2.html)) - [View Execution Security](https://awesome-repositories.com/f/security-cryptography/role-based-access-control/tab-access-restrictions/view-execution-security.md) — Controls data access by configuring the security context for view execution. ([source](http://prestodb.io/docs/current/sql/create-view.html)) - [User Access Revocation](https://awesome-repositories.com/f/security-cryptography/user-access-management/user-access-revocation.md) — Removes data access permissions from users or roles to enforce security policies across data sources. ([source](http://prestodb.io/docs/current/sql/revoke.html)) - [Application and System Security](https://awesome-repositories.com/f/security-cryptography/application-and-system-security.md) — Enforces comprehensive authentication and authorization protocols to protect cluster data and system integrity. ([source](http://prestodb.io/docs/current/)) - [Credential-Based Access Controls](https://awesome-repositories.com/f/security-cryptography/identity-based-access-control/credential-based-access-controls.md) — Validates client credentials against local flat files for secure engine access. ([source](http://prestodb.io/docs/current/security/password-file.html)) - [Certificate Trust Validation](https://awesome-repositories.com/f/security-cryptography/identity-servers/certificate-trust-validation.md) — Ensures secure connections by validating coordinator identities through certificate trust management. ([source](http://prestodb.io/docs/current/security/tls.html)) - [CLI Authentication](https://awesome-repositories.com/f/security-cryptography/kerberos-authentication/cli-authentication.md) — Enables secure command-line interface access using Kerberos protocols. ([source](http://prestodb.io/docs/current/security/cli.html)) - [Data Encryption](https://awesome-repositories.com/f/security-cryptography/privacy-data-protection/data-encryption.md) — Protects intermediate query results spilled to disk using per-file encryption keys. ([source](http://prestodb.io/docs/current/admin/spill.html)) - [Remote Access Security](https://awesome-repositories.com/f/security-cryptography/remote-access-security.md) — Configures encrypted communication and authentication methods for secure access to remote data sources. ([source](http://prestodb.io/docs/current/connector/elasticsearch.html)) - [Request Filter Integrations](https://awesome-repositories.com/f/security-cryptography/request-authentication/request-filter-integrations.md) — Implements custom request filters and authentication mechanisms to secure communication between clients and the engine. ([source](http://prestodb.io/docs/current/develop.html)) ### DevOps & Infrastructure - [Resource Allocation Policies](https://awesome-repositories.com/f/devops-infrastructure/infrastructure/configuration-policy-enforcement/resource-allocation-policies.md) — Groups incoming queries into defined pools to enforce limits on concurrency, memory usage, and execution time. ([source](http://prestodb.io/docs/current/admin.html)) - [Cluster Resource Viewers](https://awesome-repositories.com/f/devops-infrastructure/cluster-management/cluster-resource-viewers.md) — Aggregates cluster-wide data and provides a global view of the system to support distributed query coordination and execution. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Query Failure Recovery](https://awesome-repositories.com/f/devops-infrastructure/cicd-pipeline-automation/cicd-pipeline-management/ci-cd-workflows/pull-request-automation-tools/automated-fix-validators/pipeline-failure-recovery/query-failure-recovery.md) — Classifies and resolves known query failures caused by environment differences, non-deterministic behavior, or specific data types. ([source](http://prestodb.io/docs/current/admin/verifier.html)) - [Native Execution Offloading](https://awesome-repositories.com/f/devops-infrastructure/execution-node-managers/native-execution-offloading.md) — Integrates specialized worker nodes to offload function resolution, type management, and session property discovery directly to a native execution engine. ([source](http://prestodb.io/docs/current/plugin/native-sidecar-plugin.html)) - [Kubernetes Cluster Management](https://awesome-repositories.com/f/devops-infrastructure/kubernetes-cluster-management.md) — Manages the lifecycle and scaling of query engine nodes within Kubernetes environments using standardized templates. ([source](http://prestodb.io/docs/current/installation/deploy-helm.html)) - [Containerized Deployments](https://awesome-repositories.com/f/devops-infrastructure/containerized-deployments.md) — Packages the query engine and configuration into portable images for consistent execution across diverse environments. ([source](http://prestodb.io/docs/current/installation/deployment.html)) ### Scientific & Mathematical Computing - [Statistical Data Estimation](https://awesome-repositories.com/f/scientific-mathematical-computing/numerical-mathematical-foundations/statistics-probability/statistical-estimation/statistical-data-estimation.md) — Performs high-performance estimations of distinct counts and distribution percentiles using specialized data sketches. ([source](http://prestodb.io/docs/current/language/types.html)) - [Spatial Data Processing](https://awesome-repositories.com/f/scientific-mathematical-computing/data-modeling-processing/geospatial-and-location-services/spatial-data-processing.md) — Processes and analyzes complex spatial geometries and coordinate datasets. ([source](http://prestodb.io/docs/current/language/types.html)) - [Statistical Analysis Libraries](https://awesome-repositories.com/f/scientific-mathematical-computing/research-analysis-workflows/research-and-data-analysis-tools/statistical-analysis-libraries.md) — Provides functions for correlation, covariance, and linear regression analysis. ([source](http://prestodb.io/docs/current/functions/aggregate.html)) - [Arithmetic Operations](https://awesome-repositories.com/f/scientific-mathematical-computing/numerical-mathematical-foundations/arithmetic-number-types/arithmetic-operations.md) — Executes mathematical operations on decimal values with automatic precision and scale calculation. ([source](http://prestodb.io/docs/current/functions/decimal.html)) - [Geometric Operations](https://awesome-repositories.com/f/scientific-mathematical-computing/numerical-mathematical-foundations/computational-geometry/geometric-operations.md) — Calculates spatial relationships and geometric properties like unions and intersections for advanced data analysis. ([source](http://prestodb.io/docs/current/functions/geospatial.html)) - [Distribution Function Calculators](https://awesome-repositories.com/f/scientific-mathematical-computing/numerical-mathematical-foundations/statistics-probability/probability-distributions/distribution-function-calculators.md) — Calculates cumulative distribution functions to support advanced statistical analysis. ([source](http://prestodb.io/docs/current/functions/math.html)) ### System Administration & Monitoring - [Execution Resource Controls](https://awesome-repositories.com/f/system-administration-monitoring/monitoring-and-observability/observability-platforms/metric-performance-monitors/system-usage-monitoring/execution-resource-controls.md) — Controls query execution priority, memory usage, and disk spilling to maintain stability and performance under heavy concurrent workloads. ([source](http://prestodb.io/docs/current/)) - [Query Performance Monitoring](https://awesome-repositories.com/f/system-administration-monitoring/query-performance-monitoring.md) — Provides graphical visualizations and raw execution statistics to diagnose resource usage across query stages. ([source](http://prestodb.io/docs/current/admin/web-interface.html)) - [Query Terminators](https://awesome-repositories.com/f/system-administration-monitoring/query-performance-monitoring/query-terminators.md) — Allows administrators to cancel active queries directly from the management interface to free up system resources. ([source](http://prestodb.io/docs/current/admin/web-interface.html)) - [Resource Usage Restrictions](https://awesome-repositories.com/f/system-administration-monitoring/resource-usage-limiters/resource-usage-restrictions.md) — Enforces limits on CPU, memory, and concurrency to prevent resource monopolization in multi-tenant environments. ([source](http://prestodb.io/docs/current/admin/resource-groups.html)) - [Remote Server Connectivities](https://awesome-repositories.com/f/system-administration-monitoring/administrative-operations/linux-system-administration/networking/connection-lifecycle-management/remote-server-connectivities.md) — Establishes a connection to a specific server endpoint, catalog, and schema to enable remote data querying from a local terminal. ([source](http://prestodb.io/docs/current/clients/presto-cli.html)) - [Cluster Health Monitoring](https://awesome-repositories.com/f/system-administration-monitoring/cluster-health-monitoring.md) — Retrieves status information about nodes, tasks, and stages to track engine performance and availability. ([source](http://prestodb.io/docs/current/rest.html)) - [Catalog Management](https://awesome-repositories.com/f/system-administration-monitoring/cluster-management/catalog-management.md) — Configures multiple independent database catalogs to allow simultaneous querying across different cluster instances. ([source](http://prestodb.io/docs/current/connector/cassandra.html)) - [Cluster Monitoring Dashboards](https://awesome-repositories.com/f/system-administration-monitoring/cluster-monitoring-dashboards.md) — Visualizes real-time metrics and query execution statistics within a centralized dashboard. ([source](http://prestodb.io/docs/current/admin/grafana-cloud.html)) - [Query Routing Policies](https://awesome-repositories.com/f/system-administration-monitoring/query-logging/query-routing-policies.md) — Assigns incoming queries to specific resource groups based on user, source, or resource requirements. ([source](http://prestodb.io/docs/current/admin/resource-groups.html)) - [Query Admission Control](https://awesome-repositories.com/f/system-administration-monitoring/query-performance-monitoring/query-admission-control.md) — Limits the rate of incoming queries to prevent worker overload and ensure cluster stability. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Task Progress Monitors](https://awesome-repositories.com/f/system-administration-monitoring/activity-monitors/activity-progress-monitors/task-progress-monitors.md) — Allows real-time tracking and cancellation of running analytical workloads. ([source](http://prestodb.io/docs/current/rest.html)) - [Session Management](https://awesome-repositories.com/f/system-administration-monitoring/administrative-operations/configuration-control-utilities/administrative-controls/session-management.md) — Applies default configuration settings to query sessions to manage resource usage and workload behavior. ([source](http://prestodb.io/docs/current/admin/session-property-managers.html)) - [Query Retries](https://awesome-repositories.com/f/system-administration-monitoring/cluster-administration/query-retries.md) — Provides automated query retries to handle transient failures and improve system reliability. ([source](http://prestodb.io/docs/current/admin/properties.html)) - [Group Access Controls](https://awesome-repositories.com/f/system-administration-monitoring/group-access-controls.md) — Restricts system access by verifying user membership in directory groups. ([source](http://prestodb.io/docs/current/security/ldap.html)) - [Cluster Administration](https://awesome-repositories.com/f/system-administration-monitoring/cluster-administration.md) — Provides administrative tools for managing the health, performance, and lifecycle of distributed query engine clusters. - [System Event Monitors](https://awesome-repositories.com/f/system-administration-monitoring/system-event-monitors.md) — Supports event listeners to capture and process internal system events like query execution metrics and lineage information. ([source](http://prestodb.io/docs/current/develop.html)) ### Development Tools & Productivity - [Custom Task Functions](https://awesome-repositories.com/f/development-tools-productivity/custom-task-functions.md) — Develops user-defined functions, table functions, and procedures to extend the query language with domain-specific logic. ([source](http://prestodb.io/docs/current/develop.html)) - [Function Definitions](https://awesome-repositories.com/f/development-tools-productivity/custom-task-functions/sql-function-namespaces/function-definitions.md) — Creates reusable SQL functions with specified parameters to encapsulate complex logic. ([source](http://prestodb.io/docs/current/sql/create-function.html)) - [Administrative Procedure Executors](https://awesome-repositories.com/f/development-tools-productivity/cli-administration-tools/administrative-procedure-executors.md) — Invokes connector-defined routines to perform data manipulation or system management tasks by passing arguments either by name or by position. ([source](http://prestodb.io/docs/current/connector/hive.html)) - [SQL Function Namespaces](https://awesome-repositories.com/f/development-tools-productivity/custom-task-functions/sql-function-namespaces.md) — Organizes user-defined functions into namespaces to enable the creation, modification, and deletion of custom logic within the query engine. ([source](http://prestodb.io/docs/current/admin/function-namespace-managers.html)) - [Date Formatting Utilities](https://awesome-repositories.com/f/development-tools-productivity/date-formatting-utilities.md) — Converts date and time values to and from strings using standard ISO 8601 or custom format patterns. ([source](http://prestodb.io/docs/current/functions/datetime.html)) - [Duration Interval Calculators](https://awesome-repositories.com/f/development-tools-productivity/duration-formatters/duration-interval-calculators.md) — Computes the difference between two timestamps in specific units or parses duration strings into interval objects. ([source](http://prestodb.io/docs/current/functions/datetime.html)) ### Networking & Communication - [Database Session Configurations](https://awesome-repositories.com/f/networking-communication/network-reliability-diagnostics/connection-session-management/database-session-configurations.md) — Sets and resets session-level parameters to customize query behavior and environment settings for individual user connections. ([source](http://prestodb.io/docs/current/sql.html)) - [Stream-to-Table Mappings](https://awesome-repositories.com/f/networking-communication/messaging-api-integrations/topic-message-listeners/stream-to-table-mappings.md) — Exposes live data streams from messaging topics as queryable tables by mapping messages to structured relational schemas. ([source](http://prestodb.io/docs/current/connector/kafka-tutorial.html)) - [S3 Protocol Clients](https://awesome-repositories.com/f/networking-communication/remote-storage-protocols/s3-protocol-clients.md) — Reads and writes data stored in S3 buckets using native URI prefixes with support for server-side and client-side encryption. ([source](http://prestodb.io/docs/current/connector/hive.html)) ### Testing & Quality Assurance - [Query Result Consistency Validators](https://awesome-repositories.com/f/testing-quality-assurance/validation-verification/input-validation/compile-time-validators/sql-query-validators/query-result-consistency-validators.md) — Compares results between two query executions to detect regressions or semantic differences by validating output consistency. ([source](http://prestodb.io/docs/current/admin/verifier.html)) - [Query Performance Benchmarks](https://awesome-repositories.com/f/testing-quality-assurance/performance-testing-analysis/performance-diagnostics/performance-measurement/query-performance-benchmarks.md) — Tracks wall time and CPU usage to provide statistical analysis of query performance. ([source](http://prestodb.io/docs/current/admin/benchmark-driver.html)) ### Artificial Intelligence & ML - [External Tool Integration](https://awesome-repositories.com/f/artificial-intelligence-ml/external-tool-integration.md) — Integrates with external business intelligence platforms to perform interactive analysis of distributed datasets through a standardized database connection interface. ([source](http://prestodb.io/docs/current/clients/superset.html)) - [Window Ranking Functions](https://awesome-repositories.com/f/artificial-intelligence-ml/search-and-ranking-algorithms/window-ranking-functions.md) — Assigns ranks and percentile distributions to rows within partitions. ([source](http://prestodb.io/docs/current/functions/window.html)) ### Operating Systems & Systems Programming - [Memory Management](https://awesome-repositories.com/f/operating-systems-systems-programming/kernel-core-internals/process-and-memory-management/memory-management.md) — Sets maximum memory thresholds for queries and nodes to prevent system instability and manage resource usage. ([source](http://prestodb.io/docs/current/admin/properties.html)) ### Programming Languages & Runtimes - [String Manipulators](https://awesome-repositories.com/f/programming-languages-runtimes/programming-utilities/string-utilities/string-manipulators.md) — Provides standard functions for concatenating, trimming, and transforming text strings. ([source](http://prestodb.io/docs/current/functions/string.html)) - [Array Access and Modification](https://awesome-repositories.com/f/programming-languages-runtimes/programming-utilities/data-structure-type-helpers/data-type-utilities/array-element-finding/array-modification-utilities/array-access-and-modification.md) — Trino retrieves specific items from an array using a one-based index position. ([source](http://prestodb.io/docs/current/functions/array.html)) - [Extreme Value Finders](https://awesome-repositories.com/f/programming-languages-runtimes/programming-utilities/data-structure-type-helpers/data-type-utilities/array-element-finding/finite-value-masks/extreme-value-finders.md) — Returns the largest or smallest value from a provided set of inputs across various data types. ([source](http://prestodb.io/docs/current/functions/comparison.html)) - [String Similarity Metrics](https://awesome-repositories.com/f/programming-languages-runtimes/programming-utilities/string-utilities/string-manipulators/edit-distance-calculators/string-similarity-metrics.md) — Quantifies differences between strings using various similarity metrics. ([source](http://prestodb.io/docs/current/functions/string.html)) ### Web Development - [Database Connectivity Drivers](https://awesome-repositories.com/f/web-development/database-connectivity-drivers.md) — Provides a standard interface for Java applications to execute SQL queries against distributed data sources. ([source](http://prestodb.io/docs/current/clients/dbeaver.html)) - [Row Insertion](https://awesome-repositories.com/f/web-development/editor-insertion-commands/table-insertion/row-insertion.md) — Supports adding new rows to tables by mapping query results to specific columns. ([source](http://prestodb.io/docs/current/sql/insert.html)) ### User Interface & Experience - [Data Synchronization](https://awesome-repositories.com/f/user-interface-experience/data-tables/table-data-syncers/data-synchronization.md) — Maintains data consistency across systems by synchronizing rows between source and target tables. ([source](http://prestodb.io/docs/current/sql/merge.html)) - [Spatial Metric Calculators](https://awesome-repositories.com/f/user-interface-experience/measurement-tools/spatial-metric-calculators.md) — Computes spatial metrics like area, length, and distance for geometric data. ([source](http://prestodb.io/docs/current/functions/geospatial.html))