You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Oleg Sidorkin (JIRA)" <ji...@apache.org> on 2015/05/04 22:27:06 UTC

[jira] [Created] (SPARK-7345) Spark cannot detect renamed columns using JDBC connector

Oleg Sidorkin created SPARK-7345:
------------------------------------

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


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