[ 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