[SPARK-5753] add basic support to JDBCRDD for postgresql types: uuid, hstore, and array

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.3.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Ricky Nguyen
• Created: 12/Feb/15 02:21
• Updated: 24/Dec/15 09:56
• Resolved: 24/Dec/15 09:56

Description

I recently saw the new JDBCRDD merged into master. Thanks for that, it works pretty well and is really convenient.

It would be nice if it could have basic support for a few more types.

• uuid (as StringType)
• hstore (as MapType). keys and values are both strings.
• array (as ArrayType)

I have a patch that gets started in this direction. Not sure where or how to write/run tests, but I ran manual tests in spark-shell against my postgres db.

Issue Links

• duplicates: SPARK-10186 Add support for more postgres column types
• links to: [Github] Pull Request #4549 (lepfhty)
• links to: [Github] Pull Request #4700 (hotou)