Expand description
JSON table-valued functions (array/object expansion) JSON table-valued functions (F-SCHEMA-012).
Implements PostgreSQL-compatible JSON TVFs as DataFusion table functions:
jsonb_array_elements(jsonb)→ set of JSONB valuesjsonb_array_elements_text(jsonb)→ set of text valuesjsonb_each(jsonb)→ set of (key, value) pairsjsonb_each_text(jsonb)→ set of (key, text_value) pairsjsonb_object_keys(jsonb)→ set of text keys
Each TVF implements TableFunctionImpl, producing a MemTable-backed
TableProvider that holds the expanded rows.
Structs§
- Jsonb
Array Elements Text Tvf jsonb_array_elements_text(jsonb) → setof text- Jsonb
Array Elements Tvf jsonb_array_elements(jsonb) → setof jsonb- Jsonb
Each Text Tvf jsonb_each_text(jsonb) → setof (key text, value text)- Jsonb
Each Tvf jsonb_each(jsonb) → setof (key text, value jsonb)- Jsonb
Object Keys Tvf jsonb_object_keys(jsonb) → setof text
Functions§
- register_
json_ table_ functions - Registers all JSON table-valued functions with the
SessionContext.