[FLINK-10216] Add REGEXP_MATCH in TableAPI and SQL

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: Juho Autio
• Created: 25/Aug/18 14:22
• Updated: 23/Apr/21 13:57

Description

Here's a naive implementation:

public class RegexpMatchFunction extends ScalarFunction {
    // NOTE! Flink calls eval() by reflection
    public boolean eval(String value, String pattern) {
        return value != null && pattern != null && value.matches(pattern);
    }
}

I wonder if there would be a way to optimize this to use Pattern.compile(value) and use the compiled Pattern for multiple calls (possibly different values, but same pattern).

Naming

Should regex functions be prefixed with regexp_ or regex_? See also: https://github.com/apache/flink/pull/6448#issuecomment-415972833

Issue Links

• relates to: FLINK-9990 Add regexp_extract supported in TableAPI and SQL
• relates to: FLINK-9991 Add regexp_replace supported in TableAPI and SQL