You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Reynold Xin (JIRA)" <ji...@apache.org> on 2016/11/02 06:18:00 UTC
[jira] [Updated] (SPARK-14878) Support Trim characters in the
string trim function
[ https://issues.apache.org/jira/browse/SPARK-14878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Reynold Xin updated SPARK-14878:
--------------------------------
Description:
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}
was:
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:
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>
> 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
>
> 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.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org