polars-avro 0.9.0

Polars io-plugin for reading and writing avro files

polars-avro

A polars io plugin for reading and writing Apache Avro files, built on arrow-avro. It provides scan support with predicate pushdown, map type reading, and continued avro support as polars deprecates its built-in implementation.

Python Usage

from polars_avro import scan_avro, read_avro, write_avro

lazy = scan_avro(path)
frame = read_avro(path)
write_avro([frame], path)

Rust Usage

There are two main exports: [Reader] for iterating DataFrames from avro sources, and [Writer] for writing DataFrames to an avro file.

use polars_avro::{Reader, Writer, ReadOptions};

// read
let reader = Reader::try_new(
    [File::open("data.avro")],
    ReadOptions::basic(),
).unwrap();
for batch in reader {
    let frame = batch.unwrap();
}

// write
let mut writer = Writer::try_new(file, frame.schema(), None).unwrap();
writer.write(&frame).unwrap();

ℹ️ Avro supports writing with file compression schemes. In rust these need to be enabled via feature flags: deflate, snappy, bzip2, xz, zstd. Decompression is handled automatically.

Idiosyncrasies

Avro and Arrow don't align fully, and polars only supports a subset of arrow. Some types require casting before writing, and some avro types map to different polars types than you might expect when reading.

Writing

The following polars types error when writing and must be cast first:

Polars Type	Cast To
large UInt64	Wrap to Int64
Categorical	Int32 or String
Enum	Int32 or String

Times will get truncated to micro seconds.

Compression is supported via feature flags: deflate, snappy, bzip2, xz, zstd.

Reading

utf8_view behavior — the utf8_view option (default false) changes how certain types are read:

Type	utf8_view=false (default)	utf8_view=true
UUID	binary (16 bytes)	formatted string
nullable strings	preserves nulls	replaces null with "" (lossy)

Since polars tends to work with string views internally, utf8_view=true is likely faster if you don't mind losing null string distinctions.

Type mappings of note:

Avro Type	Polars Type
Enum	Categorical (not Enum)
Map	List of Struct {key, value}
BigDecimal	Binary
Duration	unsupported (errors)
Date	Date (days since epoch)
TimeMillis, TimeMicros	Time (nanoseconds)
TimestampMillis/Micros/Nanos	Datetime with matching precision and UTC tz
LocalTimestampMillis/Micros/Nanos	Datetime with matching precision and no tz

Constraints: the root avro schema must be a Record, and all files in a multi-file read must share the same schema.

Benchmarks

Python reports median (file reads, in-memory writes). Rust reports mean. native = polars built-in avro. Ratio relative to native; bold = fastest. Complex rows use nested/struct types.

Benchmark	native	polars-avro	jetliner
python read 1K × 2	64 µs (1.00x)	99 µs (1.54x)	180 µs (2.79x)
python read 64K × 2	2.7 ms (1.00x)	2.1 ms (0.78x)	2.8 ms (1.04x)
python read 1K × 8	183 µs (1.00x)	242 µs (1.32x)	337 µs (1.84x)
python read 1M × 8	159 ms (1.00x)	114 ms (0.72x)	145 ms (0.91x)
python read 1M × 128	2.6 s (1.00x)	1.8 s (0.69x)	2.8 s (1.09x)
python read complex 1K × 8	—	449 µs	592 µs
python read complex 1M × 8	—	181 ms	260 ms
python read proj 1M × 128 → 8	1.6 s (1.00x)	1.2 s (0.75x)	1.2 s (0.77x)
python read proj 1K × 8 → 2	133 µs (1.00x)	297 µs (2.24x)	264 µs (1.99x)
python write 1K × 2	42 µs (1.00x)	30 µs (0.72x)	—
python write 64K × 2	1.5 ms (1.00x)	1.1 ms (0.71x)	—
python write 1K × 8	143 µs (1.00x)	114 µs (0.80x)	—
python write 1M × 8	87 ms (1.00x)	93 ms (1.07x)	—
python write 1M × 128	1.5 s (1.00x)	2.2 s (1.48x)	—
rust read 1K × 2	42 µs (1.00x)	34 µs (0.80x)	—
rust read 1M × 128	2.8 s (1.00x)	2.0 s (0.69x)	—
rust read proj 1M × 128 → 8	1.3 s (1.00x)	1.2 s (0.87x)	—
rust read proj 1K × 8 → 2	109 µs (1.00x)	116 µs (1.06x)	—
rust write 1K × 2	42 µs (1.00x)	22 µs (0.53x)	—
rust write 64K × 2	1.5 ms (1.00x)	1.0 ms (0.67x)	—
rust write 1K × 8	135 µs (1.00x)	93 µs (0.69x)	—
rust write 1M × 8	97 ms (1.00x)	89 ms (0.92x)	—
rust write 1M × 128	1.6 s (1.00x)	1.4 s (0.88x)	—

Development

Rust

Standard cargo commands will build and test the rust library.

Python

The python library is built with uv and maturin. The rust components should build once, ance otherwise allow usage and testing.

You may need to recompile the python bindings with uv run maturin develop.

Testing

cargo fmt --check
cargo clippy --all-features --tests
cargo test
uv run ruff format --check
uv run ruff check
uv run pyright
uv run pytest

Benchmarking

Python benchmarks are disabled by default. To run them:

cargo +nightly bench
uv run pytest --benchmark-only

Releasing

rm -rf dist
uv build --sdist
uv run maturin build -r -o dist --target aarch64-apple-darwin
uv run maturin build -r -o dist --target aarch64-unknown-linux-gnu --zig
uv publish --username __token__

To Do

• reimplement single column reader?
• reimplement better workarounds for types that don't exist, e.g. serialize polars cat/enum to arrow enum and vice versa