[jira] [Updated] (SPARK-28076) String Functions: SUBSTRING support regular expression

2019-12-28 Thread Takeshi Yamamuro (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-28076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Takeshi Yamamuro updated SPARK-28076:
-
Parent Issue: SPARK-30375  (was: SPARK-27764)

> String Functions: SUBSTRING support regular expression
> --
>
> Key: SPARK-28076
> URL: https://issues.apache.org/jira/browse/SPARK-28076
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Yuming Wang
>Priority: Major
>
> ||Function||Return Type||Description||Example||Result||
> |{{substring(_string_}} from _{{pattern}}_)|{{text}}|Extract substring 
> matching POSIX regular expression. See [Section 
> 9.7|https://www.postgresql.org/docs/11/functions-matching.html] for more 
> information on pattern matching.|{{substring('Thomas' from '...$')}}|{{mas}}|
> |{{substring(_string_}} from _{{pattern}}_ for _{{escape}}_)|{{text}}|Extract 
> substring matching SQL regular expression. See [Section 
> 9.7|https://www.postgresql.org/docs/11/functions-matching.html] for more 
> information on pattern matching.|{{substring('Thomas' from '%#"o_a#"_' for 
> '#')}}|{{oma}}|
> For example:
> {code:sql}
> -- T581 regular expression substring (with SQL's bizarre regexp syntax)
> SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd";
> {code}
> https://www.postgresql.org/docs/11/functions-string.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Updated] (SPARK-28076) String Functions: SUBSTRING support regular expression

2019-06-17 Thread Yuming Wang (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SPARK-28076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuming Wang updated SPARK-28076:

Summary: String Functions: SUBSTRING support regular expression  (was: 
String Functions: Support regular expression substring)

> String Functions: SUBSTRING support regular expression
> --
>
> Key: SPARK-28076
> URL: https://issues.apache.org/jira/browse/SPARK-28076
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Yuming Wang
>Priority: Major
>
> ||Function||Return Type||Description||Example||Result||
> |{{substring(_string_}} from _{{pattern}}_)|{{text}}|Extract substring 
> matching POSIX regular expression. See [Section 
> 9.7|https://www.postgresql.org/docs/11/functions-matching.html] for more 
> information on pattern matching.|{{substring('Thomas' from '...$')}}|{{mas}}|
> |{{substring(_string_}} from _{{pattern}}_ for _{{escape}}_)|{{text}}|Extract 
> substring matching SQL regular expression. See [Section 
> 9.7|https://www.postgresql.org/docs/11/functions-matching.html] for more 
> information on pattern matching.|{{substring('Thomas' from '%#"o_a#"_' for 
> '#')}}|{{oma}}|
> For example:
> {code:sql}
> -- T581 regular expression substring (with SQL's bizarre regexp syntax)
> SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd";
> {code}
> https://www.postgresql.org/docs/11/functions-string.html



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

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org