Skip to main content

Module json_tvf

Module json_tvf 

Source
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 values
  • jsonb_array_elements_text(jsonb) → set of text values
  • jsonb_each(jsonb) → set of (key, value) pairs
  • jsonb_each_text(jsonb) → set of (key, text_value) pairs
  • jsonb_object_keys(jsonb) → set of text keys

Each TVF implements TableFunctionImpl, producing a MemTable-backed TableProvider that holds the expanded rows.

Structs§

JsonbArrayElementsTextTvf
jsonb_array_elements_text(jsonb) → setof text
JsonbArrayElementsTvf
jsonb_array_elements(jsonb) → setof jsonb
JsonbEachTextTvf
jsonb_each_text(jsonb) → setof (key text, value text)
JsonbEachTvf
jsonb_each(jsonb) → setof (key text, value jsonb)
JsonbObjectKeysTvf
jsonb_object_keys(jsonb) → setof text

Functions§

register_json_table_functions
Registers all JSON table-valued functions with the SessionContext.