davidradl commented on code in PR #26806:
URL: https://github.com/apache/flink/pull/26806#discussion_r2213650836
##########
docs/data/sql_functions.yml:
##########
@@ -1219,6 +1219,35 @@ valueconstruction:
- table: NUMERIC.rows
description: Creates a NUMERIC interval of rows (commonly used in window
creation).
+valuemodification:
+ - sql: OBJECT_UPDATE(object, key, value [, key, value , ...])
+ table: OBJECT.objectUpdate(key, value [, key, value , ...])
+ description: |
+ Updates existing fields in a structured object by providing key-value
pairs.
Review Comment:
I am curious:
- I assume that arrays are not included in this
- are there restrictions on the values, i.e. can they be maps, lists,
objects or arrays. If there are restrictions , we should document them. If
there are no restrictions we should include examples of more complex objects.
- in the example I assume "com.example.User" is a "path".
- could dots in the field name clash with the path?
- could you give an example or pointer to documentaiton around how to
construct these paths in the documentation - examples around nested objects
would be useful - including an array of objects where you want to update the
value of the 3rd object.
- can we set null values.
- if the field is defined as not nullable - do we error if an attempt to put
a null there occurs.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]