[jira] [Updated] (SPARK-27949) Support SUBSTRING(str FROM n1 [FOR n2]) syntax
[ https://issues.apache.org/jira/browse/SPARK-27949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27949: - Parent Issue: SPARK-30375 (was: SPARK-27764) > 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 > Fix For: 3.0.0 > > > 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 (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-27949) Support SUBSTRING(str FROM n1 [FOR n2]) syntax
[ 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
[jira] [Updated] (SPARK-27949) Support SUBSTRING(str FROM n1 [FOR n2]) syntax
[ https://issues.apache.org/jira/browse/SPARK-27949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dongjoon Hyun updated SPARK-27949: -- Summary: Support SUBSTRING(str FROM n1 [FOR n2]) syntax (was: Support ANSI SQL grammar `substring(string_expression from n1 [for n2])`) > 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 >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(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] -- 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