igor-suhorukov opened a new pull request, #14134:
URL: https://github.com/apache/arrow/pull/14134

   I want to convert into Apache Arrow IPC data format in Java existing data 
from PostgreSQL database.
   
   
[JdbcToArrowUtils.jdbcToArrowSchema](https://github.com/apache/arrow/blob/50a7d15dfb4cbc4dd449ff2bb3ba2b1cde62a3ab/java/adapter/jdbc/src/main/java/org/apache/arrow/adapter/jdbc/JdbcToArrowUtils.java#L111)
 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](https://github.com/apache/arrow/blob/50a7d15dfb4cbc4dd449ff2bb3ba2b1cde62a3ab/java/adapter/jdbc/src/main/java/org/apache/arrow/adapter/jdbc/JdbcToArrowUtils.java#L266)
 with no support of Map type mapping in code.
   
   This pull request allows support of mapping for map type (hstore translated 
by jdbc driver to java.util.Map or json text/varchar). Mapping for MapConsumer 
should be manually expressed in new 
JdbcToArrowConfigBuilder(...).setJdbcToArrowTypeConverter(USER_CUSTOM_jdbcToArrowTypeConverter(calendar,
 rsmd)). Now it possible as part of 
[ARROW-17630](https://issues.apache.org/jira/browse/ARROW-17630) that allow 
user to distinguish columns by number and related external metadata.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to