Zhu, Lipeng created SPARK-27949: ----------------------------------- Summary: Support ANSI SQL grammar `substring(string_expression from n1 [for n2])` Key: SPARK-27949 URL: https://issues.apache.org/jira/browse/SPARK-27949 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.1.0 Reporter: Zhu, Lipeng
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