[jira] [Resolved] (SPARK-13297) [SQL] Backticks cannot be escaped in column names

["Hyukjin Kwon (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-13297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyukjin Kwon resolved SPARK-13297.
----------------------------------
    Resolution: Cannot Reproduce

I am resolving this as {{Cannot Reproduce}} as it "can’t be reproduced against master as reported" and the reporter confirmed it was fixed in the current master. If we can find the PR, we should backport this into 1.6.x I think.

> [SQL] Backticks cannot be escaped in column names
> -------------------------------------------------
>
>                 Key: SPARK-13297
>                 URL: https://issues.apache.org/jira/browse/SPARK-13297
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.6.0
>            Reporter: Grzegorz Chilkiewicz
>            Priority: Minor
>
> We want to use backticks to escape spaces & minus signs in column names.
> Are we unable to escape backticks when a column name is surrounded by backticks?
> It is not documented in: http://spark.apache.org/docs/latest/sql-programming-guide.html
> In MySQL there is a way: double the backticks, but this trick doesn't work in Spark-SQL.
> Am I correct or just missing something? Is there a way to escape backticks inside a column name when it is surrounded by backticks?
> Code to reproduce the problem:
> https://github.com/grzegorz-chilkiewicz/SparkSqlEscapeBacktick



--
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