Crates.io | datafusion-functions-json |
lib.rs | datafusion-functions-json |
version | 0.2.0 |
source | src |
created_at | 2024-05-02 01:18:48.737359 |
updated_at | 2024-06-12 16:18:03.364776 |
description | JSON functions for DataFusion |
homepage | |
repository | https://github.com/datafusion-contrib/datafusion-functions-json/ |
max_upload_size | |
id | 1227379 |
size | 79,788 |
Note: This is not an official Apache Software Foundation release, see datafusion-contrib/datafusion-functions-json#5.
This crate provides a set of functions for querying JSON strings in DataFusion. The functions are implemented as scalar functions that can be used in SQL queries.
To use these functions, you'll just need to call:
datafusion_functions_json::register_all(&mut ctx)?;
To register the below JSON functions in your SessionContext
.
json_contains(json: str, *keys: str | int) -> bool
- true if a JSON object has a specific keyjson_get(json: str, *keys: str | int) -> JsonUnion
- Get a value from a JSON object by its "path"json_get_str(json: str, *keys: str | int) -> str
- Get a string value from a JSON object by its "path"json_get_int(json: str, *keys: str | int) -> int
- Get an integer value from a JSON object by its "path"json_get_float(json: str, *keys: str | int) -> float
- Get a float value from a JSON object by its "path"json_get_bool(json: str, *keys: str | int) -> bool
- Get a boolean value from a JSON object by its "path"json_get_json(json: str, *keys: str | int) -> str
- Get any value from a JSON object by its "path", represented as a stringjson_length(json: str, *keys: str | int) -> int
- get the length of a JSON object or arrayCast expressions with json_get
are rewritten to the appropriate method, e.g.
select * from foo where json_get(attributes, 'bar')::string='ham'
Will be rewritten to:
select * from foo where json_get_str(attributes, 'bar')='ham'
json_keys(json: str, *keys: str | int) -> list[str]
- get the keys of a JSON objectjson_is_obj(json: str, *keys: str | int) -> bool
- true if the JSON is an objectjson_is_array(json: str, *keys: str | int) -> bool
- true if the JSON is an arrayjson_valid(json: str) -> bool
- true if the JSON is valid