[GitHub] [arrow] lidavidm opened a new issue, #35916: [Java] JdbcFieldInfo is insufficient for proper type inference

["lidavidm (via GitHub)" <gi...@apache.org>]

lidavidm opened a new issue, #35916:
URL: https://github.com/apache/arrow/issues/35916

   ### Describe the enhancement requested
   
   The APIs only let us infer the type based on the data type, precision, and scale, effectively. But in the wild, there are always exceptions; for example, the [JDBC driver for PostgreSQL maps both `TIMESTAMP WITHOUT TIME ZONE` and `TIMESTAMP WITH TIME ZONE` to just `Types.TIMESTAMP`](https://github.com/pgjdbc/pgjdbc/issues/996), so arrow-jdbc dutifully maps them both to naïve timestamps (wrong!). 
   
   JdbcFieldInfo should expose all the available information it gets. For convenience, it should also work with `DatabaseMetaData#getColumns`.
   
   ### Component(s)
   
   Java


-- 
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: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow] lidavidm closed issue #35916: [Java] JdbcFieldInfo is insufficient for proper type inference

["lidavidm (via GitHub)" <gi...@apache.org>]

lidavidm closed issue #35916: [Java] JdbcFieldInfo is insufficient for proper type inference
URL: https://github.com/apache/arrow/issues/35916


-- 
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: issues-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org