Skip to content

Latest commit

 

History

History
172 lines (140 loc) · 10 KB

README.md

File metadata and controls

172 lines (140 loc) · 10 KB
Raw

Run locally

  1. install flight sql cli
cargo install arrow_cli
  1. start scheduler & executor
BIND_PORT=50050 RUST_LOG=ballista_scheduler=debug cargo run --bin ballista-scheduler -r
BIND_PORT=50051 BIND_GRPC_PORT=50052 RUST_LOG=ballista_executor=debug cargo run --bin ballista-executor -r
BIND_PORT=50061 BIND_GRPC_PORT=50062 RUST_LOG=ballista_executor=debug cargo run --bin ballista-executor -r
  1. execute query
arrow_cli --host localhost --port 50050 --user admin --password password
> create external table lineitem stored as parquet location '<ProjectRoot>/testdata/small_lineitem';
> select count(1) from lineitem;
+-----------------+
| COUNT(Int64(1)) |
+-----------------+
| 3000            |
+-----------------+

> select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem where  l_shipdate <= date '1998-09-02' group by  l_returnflag, l_linestatus order by   l_returnflag,  l_linestatus;
+--------------+--------------+---------+--------------------+--------------------+--------------------+--------------------+-------------------+----------------------+-------------+
| l_returnflag | l_linestatus | sum_qty | sum_base_price     | sum_disc_price     | sum_charge         | avg_qty            | avg_price         | avg_disc             | count_order |
+--------------+--------------+---------+--------------------+--------------------+--------------------+--------------------+-------------------+----------------------+-------------+
| A            | F            | 20828.0 | 31357732.729999997 | 29735191.103699997 | 30918848.08145099  | 26.132998745294856 | 39344.70856963613 | 0.050250941028858145 | 797         |
| N            | F            | 558.0   | 814916.1599999999  | 781625.4935        | 811299.566748      | 26.571428571428573 | 38805.53142857143 | 0.04428571428571428  | 21          |
| N            | O            | 33583.0 | 49965083.68        | 47421219.980399996 | 49328388.16726002  | 25.15580524344569  | 37427.02897378277 | 0.050119850187265884 | 1335        |
| R            | F            | 20006.0 | 29919315.71000001  | 28383309.558999993 | 29550428.545111004 | 25.07017543859649  | 37492.87682957394 | 0.0504260651629072   | 798         |
+--------------+--------------+---------+--------------------+--------------------+--------------------+--------------------+-------------------+----------------------+-------------+

Chinese blog posts and videos

Ballista: Distributed SQL Query Engine, built on Apache Arrow

Ballista is a distributed SQL query engine powered by the Rust implementation of Apache Arrow and DataFusion.

If you are looking for documentation for a released version of Ballista, please refer to the Ballista User Guide.

Overview

Ballista implements a similar design to Apache Spark (particularly Spark SQL), but there are some key differences:

  • The choice of Rust as the main execution language avoids the overhead of GC pauses and results in deterministic processing times.
  • Ballista is designed from the ground up to use columnar data, enabling a number of efficiencies such as vectorized processing (SIMD) and efficient compression. Although Spark does have some columnar support, it is still largely row-based today.
  • The combination of Rust and Arrow provides excellent memory efficiency and memory usage can be 5x - 10x lower than Apache Spark in some cases, which means that more processing can fit on a single node, reducing the overhead of distributed compute.
  • The use of Apache Arrow as the memory model and network protocol means that data can be exchanged efficiently between executors using the Flight Protocol, and between clients and schedulers/executors using the Flight SQL Protocol

Features

  • Supports HDFS as well as cloud object stores. S3 is supported today and GCS and Azure support is planned.
  • DataFrame and SQL APIs available from Python and Rust.
  • Clients can connect to a Ballista cluster using Flight SQL.
  • JDBC support via Arrow Flight SQL JDBC Driver
  • Scheduler web interface and REST UI for monitoring query progress and viewing query plans and metrics.
  • Support for Docker, Docker Compose, and Kubernetes deployment, as well as manual deployment on bare metal.

Performance

We run some simple benchmarks comparing Ballista with Apache Spark to track progress with performance optimizations. These are benchmarks derived from TPC-H and not official TPC-H benchmarks. These results are from running individual queries at scale factor 10 (10 GB) on a single node with a single executor and 24 concurrent tasks.

The tracking issue for improving these results is #339.

benchmarks

Getting Started

The easiest way to get started is to run one of the standalone or distributed examples. After that, refer to the Getting Started Guide.

Project Status

Ballista supports a wide range of SQL, including CTEs, Joins, and Subqueries and can execute complex queries at scale.

Refer to the DataFusion SQL Reference for more information on supported SQL.

Ballista is maturing quickly and is now working towards being production ready. See the following roadmap for more details.

Roadmap

There is an excellent discussion in apache/datafusion-ballista#30 about the future of the project, and we encourage you to participate and add your feedback there if you are interested in using or contributing to Ballista.

The current focus is on the following items:

  • Make production ready
    • Shuffle file cleanup
      • Periodically (#185)
      • Add gRPC & REST interfaces for clients/UI to actively call the cleanup for a job or the whole system
    • Fill functional gaps between DataFusion and Ballista
    • Improve task scheduling and data exchange efficiency
    • Better error handling
      • Scheduler restart
    • Improve monitoring, logging, and metrics
    • Auto scaling support
    • Better configuration management
    • Support for multi-scheduler deployments. Initially for resiliency and fault tolerance but ultimately to support sharding for scalability and more efficient caching.
  • Shuffle improvement
    • Shuffle memory control (#320)
    • Improve shuffle IO to avoid producing too many files
    • Support sort-based shuffle
    • Support range partition
    • Support broadcast shuffle (#342)
  • Scheduler Improvements
    • All-at-once job task scheduling
    • Executor deployment grouping based on resource allocation
  • Cloud Support
    • Support Azure Blob Storage (#294)
    • Support Google Cloud Storage (#293)
  • Performance and scalability
    • Implement Adaptive Query Execution (#387)
    • Implement bubble execution (#408)
    • Improve benchmark results (#339)
  • Python Support
    • Support Python UDFs (#173)

Architecture Overview

There are currently no up-to-date architecture documents available. You can get a general overview of the architecture by watching the Ballista: Distributed Compute with Rust and Apache Arrow talk from the New York Open Statistical Programming Meetup (Feb 2021).

Contribution Guide

Please see the Contribution Guide for information about contributing to Ballista.