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
