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

["Rene Treffer (JIRA)" <ji...@apache.org>]

Rene Treffer created SPARK-8004:
-----------------------------------

             Summary: 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
            Reporter: Rene Treffer


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