You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Reynold Xin (JIRA)" <ji...@apache.org> on 2015/05/10 10:33:00 UTC
[jira] [Resolved] (SPARK-7345) Spark cannot detect renamed columns
using JDBC connector
[ https://issues.apache.org/jira/browse/SPARK-7345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Reynold Xin resolved SPARK-7345.
--------------------------------
Resolution: Fixed
Fix Version/s: 1.4.0
1.3.2
Assignee: Oleg Sidorkin
> Spark cannot detect renamed columns using JDBC connector
> --------------------------------------------------------
>
> Key: SPARK-7345
> URL: https://issues.apache.org/jira/browse/SPARK-7345
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.3.1
> Reporter: Oleg Sidorkin
> Assignee: Oleg Sidorkin
> Fix For: 1.3.2, 1.4.0
>
>
> sqlContext.load("jdbc", Map("url" -> "some url", "dbtable" -> "(select column as column1, column as column2 from table)")) creates DataFrame with wrong schema which fails on action.
>
> Most likely JDBC SQL connector uses getColumnName instead of getColumnLabel to deduce DataFrame schema from ResultSetMetaData.
--
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