[
https://issues.apache.org/jira/browse/SPARK-27949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated SPARK-27949:
----------------------------------
Description:
Currently, function `substr/substring`'s usage is like
`substring(string_expression, n1 [,n2])`.
But, the ANSI SQL defined the pattern for substr/substring is like
`SUBSTRING(str FROM n1 [FOR n2])`. This gap makes some inconvenient when we
switch to the SparkSQL.
- ANSI SQL-92: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
Below are the mainly DB engines to support the ANSI standard for substring.
- PostgreSQL https://www.postgresql.org/docs/9.1/functions-string.html
- MySQL
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_substring
- Redshift https://docs.aws.amazon.com/redshift/latest/dg/r_SUBSTRING.html
- Teradata
https://docs.teradata.com/reader/756LNiPSFdY~4JcCCcR5Cw/XnePye0Cwexw6Pny_qnxVA
was:
Currently, function substr/substring's usage is like
substring(string_expression, n1 [,n2]).
But the ANSI SQL defined the pattern for substr/substring is like
substring(string_expression from n1 [for n2]). This gap make some inconvenient
when we switch to the SparkSQL.
Can we support the ANSI pattern like substring(string_expression from n1 [for
n2])?
[http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt]
> Support SUBSTRING(str FROM n1 [FOR n2]) syntax
> ----------------------------------------------
>
> Key: SPARK-27949
> URL: https://issues.apache.org/jira/browse/SPARK-27949
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Zhu, Lipeng
> Assignee: Zhu, Lipeng
> Priority: Minor
>
> Currently, function `substr/substring`'s usage is like
> `substring(string_expression, n1 [,n2])`.
> But, the ANSI SQL defined the pattern for substr/substring is like
> `SUBSTRING(str FROM n1 [FOR n2])`. This gap makes some inconvenient when we
> switch to the SparkSQL.
> - ANSI SQL-92: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
> Below are the mainly DB engines to support the ANSI standard for substring.
> - PostgreSQL https://www.postgresql.org/docs/9.1/functions-string.html
> - MySQL
> https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_substring
> - Redshift https://docs.aws.amazon.com/redshift/latest/dg/r_SUBSTRING.html
> - Teradata
> https://docs.teradata.com/reader/756LNiPSFdY~4JcCCcR5Cw/XnePye0Cwexw6Pny_qnxVA
--
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
