[jira] [Resolved] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources

["Reynold Xin (JIRA)" <ji...@apache.org>]

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

Reynold Xin resolved SPARK-8004.
--------------------------------
       Resolution: Fixed
    Fix Version/s: 1.5.0
                   1.4.1
         Assignee: Liang-Chi Hsieh

> Spark does not enclose column names when fetchting from jdbc sources
> --------------------------------------------------------------------
>
>                 Key: SPARK-8004
>                 URL: https://issues.apache.org/jira/browse/SPARK-8004
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Rene Treffer
>            Assignee: Liang-Chi Hsieh
>             Fix For: 1.4.1, 1.5.0
>
>
> Spark failes to load tables that have a keyword as column names
> Sample error:
> {code}
> org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 157.0 failed 1 times, most recent failure: Lost task 0.0 in stage 157.0 (TID 4322, localhost): com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key,value FROM [XXXXXX]'
> {code}
> A correct query would have been
> {code}
> SELECT `key`.`value` FROM ....
> {code}



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