[SQOOP-1187] Support for PGpoint Data Type

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Henning Kropp
• Created: 03/Sep/13 08:04
• Updated: 15/Sep/13 22:22

Description

It would be nice if sqoop would support PGpoint data type.

http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/geometric/PGpoint.html

Currently an exception is thrown:
13/09/03 09:55:01 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column coordinates
13/09/03 09:55:01 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:912)
at org.apache.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:937)
at org.apache.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:1011)
at org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1342)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1153)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)

It should be easy to find a representation in Avro. For CSV a text form like "(x,y)" or "[x,y]" should be sufficient.

Issue Links

• duplicates: SQOOP-1149 Support Custom Postgres Types