[DRILL-1757] Add support for wildcards within REPEATED_CONTAINS

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: Future
• Component/s: Functions - Drill

Environment

0.7.0 on MacOSX, embedded mode

• Assignee: Mehant Baid
• Reporter: Bob Rumsby
• Created: 20/Nov/14 02:59
• Updated: 19/Mar/15 02:51
• Resolved: 19/Mar/15 02:51

Description

REPEATED_CONTAINS does not seem to support the % or * wildcard. If this is expected behavior (I assume not), it needs to be documented.

0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doctors') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1;
----------------------+

name

EXPR$1

----------------------+

Eric Goldberg, MD

true

----------------------+
1 row selected (0.087 seconds)
0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doc%') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1;
----------------------+

name

EXPR$1

----------------------+

Eric Goldberg, MD

false

----------------------+
1 row selected (0.093 seconds)
0: jdbc:drill:zk=local> select name, repeated_contains(categories, 'Doc*') from dfs.yelp.`yelp_academic_dataset_business.json` limit 1;
----------------------+

name

EXPR$1

----------------------+

Eric Goldberg, MD

false

----------------------+
1 row selected (0.09 seconds)