Aerospike Connect for TrinoAerospike
Aerospike Connect for Trino enables data analysts to use ANSI SQL to query data stored in Aerospike via Trino (formerly PrestoSQL). Trino is a highly parallel and distributed SQL query engine. Further, it is multi-tenant and capable of concurrently running hundreds of memory, I/O, and CPU-intensive queries, and scaling to thousands of workers.
Vendor
Aerospike
Company Website
Product details
Aerospike Connect for Trino
With Aerospike Connect for Trino (also referred to as the Trino connector), you can:
- Run ANSI SQL queries to perform in-place, on-demand analytics on massive amounts of data in Aerospike databases.
- Federate queries across multiple Aerospike clusters.
- Integrate Aerospike into an ecosystem of multiple data-storage technologies.
- Query Aerospike by using business-intelligence (BI) tools, such as Tableau.
- Query records with different schemas within the same set in Aerospike.
- Accelerate queries by using Aerospike’s massive parallelism, predicate pushdown, and secondary indexes.
- Leverage Trino’s Cost-Based Optimization using row count for query optimization.
- Deploy in a cloud or Kubernetes environment if you want to leverage Managed Trino Services offered by cloud providers.
Aerospike Connect for Trino supports the Trino (formerly PrestoSQL) SQL query engine.
Features
- SQL Query Support: Run ANSI SQL queries directly on Aerospike data using Trino’s distributed engine.
- BI Tool Integration: Connects with Tableau, Jupyter, and other tools for real-time data exploration.
- Secondary Index Support: Accelerates queries using Aerospike’s high-cardinality secondary indexes.
- Predicate Pushdown: Optimizes performance by filtering data at the source before query execution.
- Federated Querying: Query across multiple Aerospike clusters or integrate with other data sources.