Details
-
Wish
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.15.0
-
None
-
None
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 | +---------------------------+---+
- ...