[
https://issues.apache.org/jira/browse/SPARK-18018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon updated SPARK-18018:
---------------------------------
Labels: bulk-closed (was: )
> Specify alternate escape character in 'LIKE' expression
> -------------------------------------------------------
>
> Key: SPARK-18018
> URL: https://issues.apache.org/jira/browse/SPARK-18018
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Reporter: Jakob Odersky
> Priority: Major
> Labels: bulk-closed
>
> Spark currently uses the backslash character (\) to escape patterns in
> 'LIKE' expressions.
> Other RDBMS ([MS|https://msdn.microsoft.com/en-us/library/ms179859.aspx],
> [Oracle|https://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions016.htm],
>
> [DB2|http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_likepredicate.html],
>
> [MySQL|http://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html],
>
> [PostgreSQL|https://www.postgresql.org/docs/9.0/static/functions-matching.html],
> [Hive|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF])
> support specifying an alternate escape character with an extended syntax of
> the `LIKE` operator.
> The syntax is the same in all above mentioned systems and is described as
> follows:
> {code}
> expression LIKE pattern [ESCAPE escapeChar]
> {code}
> where {{escapeChar}} is a single-character expression that will replace the
> backslash as escape character.
> Adding this extended to Spark SQL would be a usability improvement for users
> coming from other systems.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
