Pangjiu created SPARK-9506:
------------------------------
Summary: 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
Priority: Blocker
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: [email protected]
For additional commands, e-mail: [email protected]
