[ https://issues.apache.org/jira/browse/SPARK-30724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-30724: ------------------------------- Comment: was deleted (was: I will investigate this feature.) > Support 'like any' and 'like all' operators > ------------------------------------------- > > Key: SPARK-30724 > URL: https://issues.apache.org/jira/browse/SPARK-30724 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.1.0 > Reporter: Yuming Wang > Priority: Major > > In Teradata/Hive and PostgreSQL 'like any' and 'like all' operators are > mostly used when we are matching a text field with numbers of patterns. For > example: > Teradata / Hive 3.0: > {code:sql} > --like any > select 'foo' LIKE ANY ('%foo%','%bar%'); > --like all > select 'foo' LIKE ALL ('%foo%','%bar%'); > {code} > PostgreSQL: > {code:sql} > -- like any > select 'foo' LIKE ANY (array['%foo%','%bar%']); > -- like all > select 'foo' LIKE ALL (array['%foo%','%bar%']); > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org