[SPARK-12747] Postgres JDBC ArrayType(DoubleType) 'Unable to find server array type'

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.6.1, 2.0.0
• Component/s: SQL
• Labels: JDBC
• Assignee: L. C. Hsieh
• Reporter: Brandon Bradley
• Created: 11/Jan/16 05:38
• Updated: 22/Jan/16 16:52
• Resolved: 22/Jan/16 16:52

Description

Hello,

I'm getting this exception when trying to use DataFrame.jdbc.write on a DataFrame with column ArrayType(DoubleType).

org.postgresql.util.PSQLException: Unable to find server array type for provided name double precision

Driver is definitely on the driver and executor classpath as I have other code that works without ArrayType. I'm not sure how to proceed in debugging.

Issue Links

• links to: [Github] Pull Request #10695 (viirya)