Table operations overview
For the concepts behind table operations — immutability, formulas, dependencies — see Understanding the Table API. This page is a quick-reference index of what's available; each guide linked below covers its operation in full, with examples.
Quick reference
| I want to... | Use this |
|---|---|
| Keep rows matching a condition | where("condition") |
| Get first/last N rows | head(n) / tail(n) |
| Add columns (stored) | update("NewColumn = formula") |
| Add columns (computed on demand) | updateView("NewColumn = formula") |
| Keep only specific columns | select("Column1", "Column2") |
| Compute specific columns on demand, dropping the rest | view("Column1", "NewColumn = formula") |
| Sort by column | sort("Column") |
| Sort in reverse order | sortDescending("Column") |
| Join lookup data | naturalJoin(other, "Key", "AddedColumn") |
| Join requiring exactly one match | exactJoin(other, "Key", "AddedColumn") |
| Cross or key-matched join | join(other, "Key") |
| Match on a timestamp/ordered key | aj(other, "Key") |
| Aggregate by groups | aggBy([AggSum(...)], "Key") |
Diving deeper: API references
When you need complete method signatures, parameter details, or edge case behavior:
- Javadoc — Table: The Table interface with all methods
- Javadoc — TableOperations: The operation contracts that define behavior
The reference documentation for each operation (e.g., where, update) also links to the relevant Javadoc.
A quick reference for table operations