[ https://issues.apache.org/jira/browse/SPARK-37508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17451183#comment-17451183 ]
angerszhu commented on SPARK-37508: ----------------------------------- Raise a pr soon > Add CONTAINS() function > ----------------------- > > Key: SPARK-37508 > URL: https://issues.apache.org/jira/browse/SPARK-37508 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.3.0 > Reporter: Max Gekk > Priority: Major > > {{contains()}} is a common convenient function supported by a number of > database systems: > # > [https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#contains_substr] > # [https://docs.snowflake.com/en/_static/apple-touch-icon.png!CONTAINS — > Snowflake > Documentation|https://docs.snowflake.com/en/sql-reference/functions/contains.html] > Proposed syntax: > {code:java} > contains(haystack, needle) > return type: boolean {code} > It is semantically equivalent to {{haystack like '%needle%'}} -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org