[jira] [Created] (DRILL-6968) pattern matching and regexp facilities

["benj (JIRA)" <ji...@apache.org>]

benj created DRILL-6968:
---------------------------

             Summary: pattern matching and regexp facilities
                 Key: DRILL-6968
                 URL: https://issues.apache.org/jira/browse/DRILL-6968
             Project: Apache Drill
          Issue Type: Wish
          Components: Functions - Drill
    Affects Versions: 1.15.0
            Reporter: benj


Although it is possible to do some of them self, adding some possibilities from pattern matching directly in DRILL
 * may be usefull,
 * would prevent (re)write them and check again and again,
 * would allow a quicker and more effective handling of Drill.

Some propositions :
 * adding possibilities to regexp_replace (ignoreCase, replaceAll(currently)/replaceOnlyFirst ...)
 * regexp_matches (lighter and more consistent than using regexp_replace trick)
 * split_to_table
{noformat}
SELECT split_to_table('Drill,baby,drill',',') AS mywords, 1 AS x;
+---------+---+
| mywords | x |
+---------+---+
| Drill   | 1 |
| baby    | 1 |
| drill   | 1 |
+---------+---+
{noformat}

 * split_to_array
{noformat}
SELECT split_to_array('Drill,baby,drill',',') AS mywords, 1 AS x;
+---------------------------+---+
| mywords                   | x |
+---------------------------+---+
| ["Drill","baby","drill"]  | 1 |
+---------------------------+---+
{noformat}

 * ...



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)