Every article about ORC says the same thing. "Columnar storage, built-in indexes, predicate pushdown...
Every article about ORC says the same thing.
"Columnar storage, built-in indexes, predicate pushdown - so it's fast."
That's not an explanation. That's a slogan.
So I wrote a small ORC parser from scratch, generated 5 million rows, and opened the file with my hands.
The question I actually wanted answered:
I rebuilt the core ideas behind Parquet — encodings, compression, row groups, projection & predicate pushdown — in ~3,000 lines…
For a decade, the file format layer was the most settled real estate in data. Apache Parquet held the...
How database indexes actually work: B-trees, selectivity, composite indexes, covering indexes, and...
A slow query lands in your lap. You run EXPLAIN ANALYZE and get back a wall of indented text that...
Model projection, filtering, updates, object-store requests, and recovery before selecting a fashionable analytics file format.
Jump Tables, TLV Footers, and the Real Cost of Reading What You Don't Need You're paying...
