🧠 Trino Flashcards
🔍 What is Trino?
Trino is a high-performance distributed SQL query engine for big data, capable of querying across multiple data sources.
🛠️ What is Trino used for?
It enables interactive analytics over large datasets stored in data lakes, databases, or other sources.
📦 Which data sources does Trino support?
Trino supports Hive, Iceberg, Delta Lake, MySQL, Postgres, Redshift, and many more via connectors.
⚡ What makes Trino fast?
It uses in-memory query execution, distributed processing, and pipelined architecture for low latency.
🎯 How is Trino different from Hive?
Trino executes queries without relying on MapReduce or Spark, providing much faster results for interactive workloads.
🧬 What is a Trino connector?
A connector enables Trino to query external data systems like S3, Kafka, JDBC-compatible DBs, etc.
🛡️ Does Trino support SQL standards?
Yes, Trino supports ANSI SQL, enabling users to write familiar queries across all data sources.
🏗️ What is Trino’s architecture?
Trino uses a coordinator and worker model, where the coordinator parses and plans queries and workers execute them.
💼 Is Trino used in production?
Yes, companies like Netflix, LinkedIn, and Lyft use Trino for federated and interactive querying at scale.
🔗 What is Starburst?
Starburst is an enterprise-grade platform built on Trino, offering extra features like security, caching, and monitoring.