[DRILL-6968] pattern matching and regexp facilities and unnest

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.15.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: benj
• Created: 11/Jan/19 09:29
• Updated: 02/Sep/19 12:48

Description

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

  SELECT split_to_table('Drill,baby,drill',',') AS mywords, 1 AS x;
  +---------+---+
  | mywords | x |
  +---------+---+
  | Drill   | 1 |
  | baby    | 1 |
  | drill   | 1 |
  +---------+---+
  

• split_to_array

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

• ...