[
https://issues.apache.org/jira/browse/SPARK-9506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15021499#comment-15021499
]
Wenchen Fan commented on SPARK-9506:
------------------------------------
I think it's not a workaround, but the right thing to do. We already have a
`PostgreDialect` and we can add more support for non-standard sql types.
> DataFrames Postgresql JDBC unable to support most of the Postgresql's Data
> Type
> -------------------------------------------------------------------------------
>
> Key: SPARK-9506
> URL: https://issues.apache.org/jira/browse/SPARK-9506
> Project: Spark
> Issue Type: Bug
> Components: Spark Core, SQL
> Reporter: Pangjiu
> Attachments: code.PNG, log.PNG, tables_structures.PNG
>
>
> Hi All,
> I have issue on using Postgresql JDBC with sqlContext for postgresql's data
> types: eg: abstime, character varying[], int2vector, json and etc.
> Exception are "Unsupported type 2003" and "Unsupported type 1111".
> Below is the code:
> Class.forName("org.postgresql.Driver").newInstance()
> val url = "jdbc:postgresql://localhost:5432/sample?user=posgres&password=xxx"
> val driver = "org.postgresql.Driver"
> val output = { sqlContext.load("jdbc", Map
> (
> "url" -> url,
> "driver" -> driver,
> "dbtable" -> "(SELECT `ID`, `NAME` FROM
> `agent`) AS tableA "
> )
> )
> }
> Hope SQL Context can support all the data types.
> Thanks.
--
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
