davidradl commented on code in PR #24526: URL: https://github.com/apache/flink/pull/24526#discussion_r1611982523
########## docs/data/sql_functions.yml: ########## @@ -688,6 +688,9 @@ collection: - sql: ARRAY_EXCEPT(array1, array2) table: arrayOne.arrayExcept(arrayTwo) description: Returns an ARRAY that contains the elements from array1 that are not in array2. If no elements remain after excluding the elements in array2 from array1, the function returns an empty ARRAY. If one or both arguments are NULL, the function returns NULL. The order of the elements from array1 is kept. + - sql: ARRAY_INTERSECT(array1, array2) + table: array1.arrayIntersect(array2) + description: Returns an ARRAY that contains the elements from array1 that are also in array2. If no elements that are both in array1 and array2, the function returns an empty ARRAY. If any of the array is null, the function will return null. The order of the elements from array1 is kept. Review Comment: we should mention that the result does not contain duplicates here, as per the agreement I see in the pr conversation -- 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: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org