[ https://issues.apache.org/jira/browse/SPARK-14878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16174316#comment-16174316 ]
Apache Spark commented on SPARK-14878: -------------------------------------- User 'kevinyu98' has created a pull request for this issue: https://github.com/apache/spark/pull/19302 > 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org