morrySnow commented on code in PR #1864: URL: https://github.com/apache/doris-website/pull/1864#discussion_r1924820508
########## docs/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md: ########## @@ -24,36 +24,50 @@ specific language governing permissions and limitations under the License. --> -## array_exists +## Description +Use an optional lambda expression as an input parameter to perform corresponding expression calculations on the internal data of other input ARRAY parameters. Returns 1 when the calculation returns something other than 0; otherwise returns 0. +There are one or more parameters input in the lambda expression, which must be consistent with the number of input array columns later. Legal scalar functions can be executed in lambda, aggregate functions, etc. are not supported. -array_exists(lambda,array1,array2....) -array_exists(array1) +When lambda expression is not used as a parameter, array1 is used as the calculation result. -### description -#### Syntax +## Syntax ```sql -BOOLEAN array_exists(lambda, ARRAY<T> arr1, ARRAY<T> arr2, ... ) -BOOLEAN array_exists(ARRAY<T> arr) +ARRAY_EXISTS([ <lambda>, ] <arr1> [, <arr2> , ...] ) ``` +## Parameters +| Parameter | Description | +|---|---| +| `lambda` | A lambda expression that can execute valid scalar functions but does not support aggregate functions. | Review Comment: ```suggestion | `<lambda>` | A lambda expression that can execute valid scalar functions but does not support aggregate functions. | ``` -- 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
