Trino

Apache DataFusion is an extensible, high-performance query engine written in Rust that utilizes Apache Arrow as its in-memory format. Designed for developers building data-centric systems such as databases, data frames, machine learning, and streaming applications, DataFusion offers SQL and DataFrame APIs, a vectorized, multi-threaded, streaming execution engine, and support for partitioned data sources. It natively supports formats like CSV, Parquet, JSON, and Avro, and allows for seamless integration with object stores including AWS S3, Azure Blob Storage, and Google Cloud Storage. The engine features a comprehensive query planner, a state-of-the-art optimizer with capabilities like expression coercion and simplification, projection and filter pushdown, sort and distribution-aware optimizations, and automatic join reordering. DataFusion is highly customizable, enabling the addition of user-defined scalar, aggregate, and window functions, custom data sources, query languages, etc.

Databend is a modern, cloud-native data warehouse built to deliver high-performance, cost-efficient analytics for large-scale data processing. It is designed with an elastic architecture that scales dynamically to meet the demands of different workloads, ensuring efficient resource utilization and lower operational costs. Written in Rust, Databend offers exceptional performance through features like vectorized query execution and columnar storage, which optimize data retrieval and processing speeds. Its cloud-first design enables seamless integration with cloud platforms, and it emphasizes reliability, data consistency, and fault tolerance. Databend is an open source solution, making it a flexible and accessible choice for data teams looking to handle big data analytics in the cloud.