You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "benj (JIRA)" <ji...@apache.org> on 2019/07/29 14:53:00 UTC
[jira] [Updated] (DRILL-6968) pattern matching and regexp
facilities and unnest
[ https://issues.apache.org/jira/browse/DRILL-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
benj updated DRILL-6968:
------------------------
Summary: pattern matching and regexp facilities and unnest (was: pattern matching and regexp facilities)
> pattern matching and regexp facilities and unnest
> -------------------------------------------------
>
> 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
> Priority: Major
>
> 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.14#76016)