[GitHub] [arrow-adbc] CurtHagenlocher commented on issue #1020: go/adbc/driver/snowflake: Snowflake driver cannot handle mixed large and small values for the NUMBER type

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

CurtHagenlocher commented on issue #1020:
URL: https://github.com/apache/arrow-adbc/issues/1020#issuecomment-1710589538

   Without a change to the ADBC spec or a way to get bounds information from the server, it sounds like the only correct choice for a Snowflake ADBC driver would be to transform the columns in question into decimal128-based arrays. It might be nice to be able to influence this from outside by specifying a particular type binding so you don't end up converting everything to decimal128 and then again to int64. Other database client specifications have some provision for this by letting the caller say "give me the value in column 1 as an int64" -- but that feels more appropriate to OLTP/LOB database usage than it does for an API aimed at analytics.


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

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