Yuming Wang created SPARK-30724:
-----------------------------------
Summary: 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.0.0
Reporter: Yuming Wang
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: [email protected]
For additional commands, e-mail: [email protected]
