You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
fail_on_error - boolean when true function must fail when json path is invalid. When json field contains incorrect json or there is error execution jsonpath, the function can throw CairoException when fail_on_error is true. Otherwise function must return NULL in the correct datatype
Is your feature request related to a problem?
We need SQL function, to create JSON projections from VARCHAR column type.
Lets assume we store JSON in the following tables:
I would like to be able to create projection as follows:
json
- varchar fieldjson_path
- examples of json path can be taken from https://www.postgresqltutorial.com/postgresql-json-functions/postgresql-json-path/cast_as_type
- our type to CAST json value asfail_on_error
- boolean whentrue
function must fail when json path is invalid. Whenjson
field contains incorrect json or there is error execution jsonpath, the function can throwCairoException
whenfail_on_error
is true. Otherwise function must returnNULL
in the correct datatypehttps://github.com/simdjson/simdjson is a library that alrady supports JSONPath and type casts. We should attempt to integrate with those.
Describe the solution you'd like.
No response
Describe alternatives you've considered.
No response
Full Name:
Vlad Ilyushchenko
Affiliation:
QuestDB
Additional context
No response
The text was updated successfully, but these errors were encountered: