Ramin Gharib created FLINK-41339:
------------------------------------
Summary: Add VARIANT_SET, VARIANT_INSERT and their TRY_ forms
Key: FLINK-41339
URL: https://issues.apache.org/jira/browse/FLINK-41339
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API, Table SQL / Runtime
Reporter: Ramin Gharib
{code:sql}
VARIANT_SET(variant, path, value [, create_if_missing]) -- VARIANT
VARIANT_INSERT(variant, path, value) -- VARIANT
VARIANT_SET(v, '$.user.name', 'Ada L.')
--
{"coupon":null,"items":[{"qty":2,"sku":"A1"}],"order_id":17,"user":{"email":"[email protected]","name":"Ada
L."}}
VARIANT_INSERT(v, '$.gift', TRUE)
--
{"coupon":null,"gift":true,"items":[{"qty":2,"sku":"A1"}],"order_id":17,"user":{"email":"[email protected]","name":"ada"}}
{code}
Scope:
* VARIANT_SET replaces the target or creates it with any missing parents. With
create_if_missing = FALSE, it only replaces.
* VARIANT_INSERT never replaces. In an array, later elements shift right. An
existing object field fails.
* Both pad an index past the end with variant nulls and reject the root path $.
* A path through a scalar, such as $.order_id.x, fails. TRY_VARIANT_SET and
TRY_VARIANT_INSERT return NULL instead.
* A value can be any type that CAST(x AS VARIANT) accepts. A SQL NULL argument
gives NULL.
* Table API and PyFlink expressions, SQL and Table API tests, docs.
Depends on FLINK-41338
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
