[jira] [Commented] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources
[ https://issues.apache.org/jira/browse/SPARK-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14576121#comment-14576121 ] Apache Spark commented on SPARK-8004: - User 'rxin' has created a pull request for this issue: https://github.com/apache/spark/pull/6689 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 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 [XX]' {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources
[ https://issues.apache.org/jira/browse/SPARK-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568666#comment-14568666 ] Apache Spark commented on SPARK-8004: - User 'viirya' has created a pull request for this issue: https://github.com/apache/spark/pull/6577 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 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 [XX]' {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources
[ https://issues.apache.org/jira/browse/SPARK-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14567467#comment-14567467 ] Liang-Chi Hsieh commented on SPARK-8004: I think backticks are only working for MySQL? 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 [XX]' {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources
[ https://issues.apache.org/jira/browse/SPARK-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14567987#comment-14567987 ] Reynold Xin commented on SPARK-8004: Some other databases use double quotes, i.e. key. We'd need to set this in the dialect class. [~viirya] do you want to continue your streak of JDBC data source fixes and submit a patch for this? 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 [XX]' {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-8004) Spark does not enclose column names when fetchting from jdbc sources
[ https://issues.apache.org/jira/browse/SPARK-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568357#comment-14568357 ] Liang-Chi Hsieh commented on SPARK-8004: Yes. I will submit a patch later. 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 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 [XX]' {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org