[SPARK-30724] Support 'like any' and 'like all' operators

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Yuming Wang
• Reporter: Yuming Wang
• Created: 04/Feb/20 08:33
• Updated: 16/Nov/20 06:00
• Resolved: 24/Apr/20 13:22

Description

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:

--like any
select 'foo' LIKE ANY ('%foo%','%bar%');

--like all
select 'foo' LIKE ALL ('%foo%','%bar%');

PostgreSQL:

-- like any
select 'foo' LIKE ANY (array['%foo%','%bar%']);

-- like all
select 'foo' LIKE ALL (array['%foo%','%bar%']);

Issue Links

• relates to: HIVE-15229 'like any' and 'like all' operators in hive
• relates to: SPARK-33045 Implement built-in LIKE ANY and LIKE ALL UDF
• links to: GitHub Pull Request #27477