[ARROW-17629] [Java] Bind DB column to Arrow Map type in JdbcToArrowUtils

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 9.0.0
• Fix Version/s: 10.0.0
• Component/s: Java
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/32872
• Assignee: Igor Suhorukov
• Reporter: Igor Suhorukov
• Created: 06/Sep/22 13:57
• Updated: 11/Jan/23 11:52
• Resolved: 21/Sep/22 12:06

Description

I want to convert into Apache Arrow IPC data format in Java existing data from PostgreSQL database.

JdbcToArrowUtils.jdbcToArrowSchema allows do it for scalar types and arrays.

org.postgresql.jdbc.PgResultSetMetaData instance from PostgreSQL jdbc driver provide all required info related to column types pgResultSetMetaData.getColumnTypeName().

But looks like current implementation support only ArrowType.List with no support of Map type mapping in code

Issue Links

• is blocked by: ARROW-17630 [Java] Introduce column index in JdbcToArrowTypeConverter as JdbcFieldInfo.column
• links to: GitHub Pull Request #14134
• links to: How to get Arrow Schema for PostgreSQL column of hstore(map) and geometry types in JdbcToArrowUtils.jdbcToArrowSchema ?