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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org