Index

Stages, functions, keywords, directives and topics, in alphabetical order.

# · A · B · C · D · E · F · G · H · I · J · K · L · M · N · O · P · Q · R · S · T · U · V · W

Symbols

• ; (semicolon) — stage separator: Lexical structure
• ; and line breaks — section: Lexical structure
• ?= (default) — let: Parameters, variables and explain
• | (pipe) — stage separator: Lexical structure

A

• A guided tour — chapter: A guided tour
• About this book — chapter: The OpenGlacier Modeling Language
• abs — function: Numeric functions
• aggregate (pivot) — directive: Aggregation and analytics
• Aggregation and analytics — chapter: Aggregation and analytics
• alias (as): Anatomy of a query
• Aliases — section: Anatomy of a query
• Anatomy of a query — chapter: Anatomy of a query
• Array and object functions — chapter: Array and object functions
• Arrays, deduplication and counting — chapter: Arrays, deduplication and counting
• as of — section: Past states and history
• at — function: Array and object functions
• avg — function: Numeric functions

B

• between — function: Logic, missing values and conversions
• between (operator) — operator: Expressions
• blocking stage: Execution model
• bucket — function: Logic, missing values and conversions
• bucket — stage: Aggregation and analytics
• by (group) — directive: Aggregation and analytics

C

• _cache — system collection: Materialized views and caches
• case — function: Logic, missing values and conversions
• ceil — function: Numeric functions
• Checklist — section: Modeling patterns
• Choosing a stage — section: Stages at a glance
• Choosing what to cache — section: Materialized views and caches
• chunk (load) — directive: Writes
• Clean the raw data once — section: Modeling patterns
• coalesce — function: Logic, missing values and conversions
• Collections — section: Anatomy of a query
• columns (pivot) — directive: Aggregation and analytics
• Combining collections — chapter: Combining collections
• Common rules — section: Functions at a glance
• Compact form — section: Aggregation and analytics
• Comparison rules — section: Values and types
• Compound form — section: Aggregation and analytics
• Compound stages and end — section: Anatomy of a query
• concat — function: Text functions
• Constant folding — section: Expressions
• constant folding: Expressions
• contains — function: Text functions
• Cookbook — chapter: Cookbook
• count — stage: Arrays, deduplication and counting
• cumsum (window) — directive: Aggregation and analytics

D

• Date and fiscal functions — chapter: Date and fiscal functions
• Date recipes — section: Date and fiscal functions
• date_add — function: Date and fiscal functions
• date_diff — function: Date and fiscal functions
• date_format — function: Date and fiscal functions
• date_part — function: Date and fiscal functions
• date_trunc — function: Date and fiscal functions
• Dates — section: Values and types
• days_in — function: Date and fiscal functions
• define view — section: Views
• delete — stage: Writes
• derive — stage: Filtering and shaping
• Design principles — section: Introduction
• _distance — field: Vector search
• distinct — stage: Arrays, deduplication and counting
• div — function: Numeric functions
• drop — stage: Filtering and shaping

E

• end — keyword: Anatomy of a query
• ends_with — function: Text functions
• Engine state (virtual) — section: System collections
• Entry layout — section: Stages at a glance
• Error layers — section: Results, statistics and errors
• exec — view clause: Views
• Execution model — chapter: Execution model
• Execution shapes — section: Execution model
• exists — function: Logic, missing values and conversions
• exp — function: Numeric functions
• explain — section: Parameters, variables and explain
• Expressions — chapter: Expressions
• Expressions per stage — section: Expressions

F

• fill — stage: Aggregation and analytics
• filter pushdown: Execution model
• Filtering and shaping — chapter: Filtering and shaping
• Filters move toward the source — section: Execution model
• first — stage: Ordering, paging and sampling
• fiscal year: Date and fiscal functions
• Fiscal years — section: Date and fiscal functions
• fiscal_end — function: Date and fiscal functions
• fiscal_month — function: Date and fiscal functions
• fiscal_start — function: Date and fiscal functions
• fiscal_year — function: Date and fiscal functions
• flatten — function: Array and object functions
• floor — function: Numeric functions
• Forms — section: Expressions
• From a terminal — section: The query request
• From text to rows — section: Execution model
• Function calls — section: Expressions
• Functions at a glance — chapter: Functions at a glance

G

• get — function: Array and object functions
• Grammar — chapter: Grammar
• group — stage: Aggregation and analytics
• Grouping at scale — section: Execution model

H

• has — function: Array and object functions
• history — section: Past states and history
• How a query reaches the engine — section: Introduction

I

• _id — field: Values and types
• Identifiers — section: Lexical structure
• if — function: Logic, missing values and conversions
• in, not in — operator: Expressions
• index_of — function: Text functions
• insert — stage: Writes
• into — stage: Writes
• into (lookup) — directive: Combining collections
• Introduction — chapter: Introduction
• Introspection operations — section: The query request

J

• Joins at scale — section: Execution model

K

• keys — function: Array and object functions
• Keywords — section: Lexical structure

L

• lag, lead (window) — directive: Aggregation and analytics
• Layers — section: Modeling patterns
• Layout — section: Lexical structure
• Lazy evaluation — section: Expressions
• len — function: Text functions
• let — statement: Parameters, variables and explain
• Lexical structure — chapter: Lexical structure
• limit — stage: Ordering, paging and sampling
• Limits — chapter: Limits
• line breaks — stage separator: Lexical structure
• list (group) — measure: Aggregation and analytics
• Listing caches — section: Materialized views and caches
• Listing views — section: Views
• Literal rows: values — section: Anatomy of a query
• Literals — section: Lexical structure
• ln — function: Numeric functions
• load — stage: Writes
• log — function: Numeric functions
• log10 — function: Numeric functions
• Logic, missing values and conversions — chapter: Logic, missing values and conversions
• lookup — stage: Combining collections
• lookup view: Views
• lower — function: Text functions
• ltrim — function: Text functions

M

• materialized — view clause: Materialized views and caches
• Materialized views — section: Materialized views and caches
• Materialized views and caches — chapter: Materialized views and caches
• max — function: Numeric functions
• median — function: Numeric functions
• Memory — section: Execution model
• memory classes: Execution model
• merge — function: Array and object functions
• min — function: Numeric functions
• missing field: Values and types
• Missing fields — section: Values and types
• Modeling — section: System collections
• Modeling patterns — chapter: Modeling patterns
• month_end — function: Date and fiscal functions

N

• near — stage: Vector search
• now — function: Date and fiscal functions
• nullif — function: Logic, missing values and conversions
• Numbers — section: Values and types
• Numeric functions — chapter: Numeric functions

O

• on view — source: Views
• One style per query — section: Lexical structure
• Operators and punctuation — section: Lexical structure
• optional — function: Logic, missing values and conversions
• ? (optional path) — operator: Values and types
• order by, partition by (window) — directive: Aggregation and analytics
• Ordering, paging and sampling — chapter: Ordering, paging and sampling

P

• pad_left — function: Text functions
• pad_right — function: Text functions
• Parameters — section: Views
• parameters ($name): Parameters, variables and explain
• Parameters, variables and explain — chapter: Parameters, variables and explain
• Parameters: $name — section: Parameters, variables and explain
• parse_date — function: Date and fiscal functions
• Past states and history — chapter: Past states and history
• percentile — function: Numeric functions
• pivot — stage: Aggregation and analytics
• Place — scope: Anatomy of a query
• _place, _app_instance — fields: System collections
• Placement rules — section: Anatomy of a query
• Platform — section: System collections
• pow — function: Numeric functions
• Precedence — section: Expressions
• precedence: Expressions
• primary-key lookup: Values and types

Q

• Query variables — section: Parameters, variables and explain
• query variables: Parameters, variables and explain
• query.execute — operation: The query request
• Quick reference — chapter: Quick reference

R

• range — function: Array and object functions
• Read and write queries — section: Anatomy of a query
• Reading a view — section: Views
• Reading an execution error — section: Results, statistics and errors
• Reference data and classification — section: Modeling patterns
• refresh of materialized views: Materialized views and caches
• rename — stage: Filtering and shaping
• replace — function: Text functions
• Report views with parameters — section: Modeling patterns
• result cache: Materialized views and caches
• Results, statistics and errors — chapter: Results, statistics and errors
• reverse — function: Array and object functions
• reverse — function: Text functions
• root — stage: Filtering and shaping
• round — function: Numeric functions
• row_number (window) — directive: Aggregation and analytics
• rows (pivot) — directive: Aggregation and analytics
• rtrim — function: Text functions
• Rules for both — section: Past states and history

S

• sample — stage: Ordering, paging and sampling
• scope: Anatomy of a query
• Scope fields — section: System collections
• Scope: Places and App instances — section: Anatomy of a query
• select — stage: Filtering and shaping
• Semantics — section: Expressions
• set — stage: Writes
• Settings read by a view — section: Modeling patterns
• sign — function: Numeric functions
• Signs — section: Lexical structure
• Simple stages — section: Anatomy of a query
• single — stage: Ordering, paging and sampling
• skip — stage: Ordering, paging and sampling
• slice — function: Array and object functions
• sort — stage: Ordering, paging and sampling
• sort_array — function: Array and object functions
• Sources — section: Anatomy of a query
• spill to disk: Execution model
• split — function: Text functions
• sqrt — function: Numeric functions
• Stacking sources — section: Modeling patterns
• Stage separators — section: Lexical structure
• Stages — section: Anatomy of a query
• Stages at a glance — chapter: Stages at a glance
• standard view: Views
• Standard views — section: Views
• starts_with — function: Text functions
• stddev — function: Numeric functions
• streaming: Execution model
• substr — function: Text functions
• sum — function: Numeric functions
• System collections — chapter: System collections

T

• Text — section: Values and types
• Text functions — chapter: Text functions
• The mental model — section: Introduction
• The pipe — section: Lexical structure
• The query request — chapter: The query request
• The response — section: Results, statistics and errors
• The result cache — section: Materialized views and caches
• The value model — section: Values and types
• Time series — section: Modeling patterns
• Tips — section: Execution model
• to_bool — function: Logic, missing values and conversions
• to_float — function: Logic, missing values and conversions
• to_int — function: Logic, missing values and conversions
• to_string — function: Logic, missing values and conversions
• Top-N: Ordering, paging and sampling
• transaction: Writes
• trim — function: Text functions
• trunc — function: Numeric functions
• type — function: Logic, missing values and conversions

U

• undefine view — section: Views
• union — stage: Combining collections
• unique — function: Array and object functions
• unwind — stage: Arrays, deduplication and counting
• upper — function: Text functions

V

• _values — constant collections: Anatomy of a query
• values — function: Array and object functions
• values (pivot) — directive: Aggregation and analytics
• values (source) — source: Anatomy of a query
• Values and types — chapter: Values and types
• Variables: let — section: Parameters, variables and explain
• Vector search — chapter: Vector search
• version (view) — view clause: Views
• Views — chapter: Views
• _views — system collection: Views
• Views and Places — section: Views

W

• What OGML is — section: Introduction
• What the language is not — section: Introduction
• When to materialize — section: Materialized views and caches
• where — stage: Filtering and shaping
• window — stage: Aggregation and analytics
• wire numbers (2^32, 2^53): Values and types
• with (load) — directive: Writes
• with index, keep empty (unwind) — option: Arrays, deduplication and counting
• Writes — chapter: Writes