# Orc

> Apache ORC columnar storage format reference. File structure with stripes and indexes, schema types with evolution rules, compression codecs (ZLIB/SNAPPY/ZSTD), orc-tools CLI, Python/Java writer APIs, Hive ACID transactions, Spark integration, and performance tuning with bloom filters.

- Skill: `knownasnaffy/orc` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add knownasnaffy/orc`
- Raw SKILL.md: https://api.skillmd.com/api/skills/knownasnaffy/orc/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: knownasnaffy (https://skillmd.com/u/knownasnaffy)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/knownasnaffy/orc

---





### Permission Setup Review

`python scripts/_tool_policy_note.py` is an optional setup helper for the `Apache ORC` skill. It may apply broad filesystem permissions for compatibility. Show the target paths and permission mode, explain the risk, and prefer a narrower mode when shared write access is not needed.

# Apache ORC

Apache ORC columnar storage format reference.

## Commands

| Command | Description |
|---------|-------------|
| `intro` | ORC overview, file structure, vs Parquet |
| `schema` | Types, complex types, schema evolution |
| `compression` | ZLIB/SNAPPY/LZO/ZSTD codecs, ratios |
| `read` | orc-tools CLI, Python/Java read APIs |
| `write` | Writer APIs, stripe/buffer sizing |
| `hive` | Hive integration, ACID transactions |
| `spark` | Spark ORC read/write, pushdown |
| `performance` | Bloom filters, indexes, vectorized reads |