[ 
https://issues.apache.org/jira/browse/IGNITE-27817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18058321#comment-18058321
 ] 

Aleksey Plekhanov commented on IGNITE-27817:
--------------------------------------------

REGEXP_SUBSTR/REGEXP_EXTRACT it's not a standard functions, there is no any 
word in SQL standard about these function. Moreover, it's not a common 
functions for other databases, as you can see in Apache Calcite these method 
are marked as related to BigQuery dialect. Not sure we should add to Ignite 
every function from every dialect that supports Apache Calcite. At least we 
don't need both of these functions with dublicated functionality.

> Add REGEXP_SUBSTR/REGEXP_EXTRACT function for Calcite engine
> ------------------------------------------------------------
>
>                 Key: IGNITE-27817
>                 URL: https://issues.apache.org/jira/browse/IGNITE-27817
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Vladislav Pyatkov
>            Assignee: Vladislav Pyatkov
>            Priority: Major
>              Labels: ignite-2, ise
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> h3. Motivation
> REGEXP_SUBSTR is a standard function for SQL. Moreover, Apache Calcite has 
> methods to support this function.
> To work conveniently with SQL, we have to support the common function, 
> especially since it is already implemented.
> h3. Definition of done
> Add the REGEXP_SUBSTR/REGEXP_EXTRACT function and tests.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to