[
https://issues.apache.org/jira/browse/SPARK-14878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiao Li resolved SPARK-14878.
-----------------------------
Resolution: Fixed
Assignee: kevin yu
> Support Trim characters in the string trim function
> ---------------------------------------------------
>
> Key: SPARK-14878
> URL: https://issues.apache.org/jira/browse/SPARK-14878
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: kevin yu
> Assignee: kevin yu
> Fix For: 2.3.0
>
>
> The current Spark SQL does not support the trim characters in the string trim
> function, which is part of ANSI SQL2003’s standard. For example, IBM DB2
> fully supports it as shown in the
> https://www.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0023198.html.
> We propose to implement it in this JIRA..
> The ANSI SQL2003's trim Syntax:
> {noformat}
> SQL
> <trim function> ::= TRIM <left paren> <trim operands> <right paren>
> <trim operands> ::= [ [ <trim specification> ] [ <trim character> ] FROM ]
> <trim source>
> <trim source> ::= <character value expression>
> <trim specification> ::=
> LEADING
> | TRAILING
> | BOTH
> <trim character> ::= <character value expression>
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
