soda-sql icon indicating copy to clipboard operation
soda-sql copied to clipboard

Published 20 hours ago • verified publisher icon sodadata

BigDecimal bug

Open tombaeyens opened this issue 3 years ago • 1 comments

https://soda-community.slack.com/archives/C01HYL8V64C/p1617466230095000?thread_ts=1615811570.096300&cid=C01HYL8V64C

@Tom Baeyens i have an update on this now. Have used jaydebeapi for the custom JDBC and I am able to run the measurements and checks successfully . Facing issues when i convert the result of the scan to json format. using the .to_json() function. This is because the datatype returned by jaydebeapi is java.math.BigDecimal which does not get inferred as decimal when inside this function. What route should i be taking so that i can convert the java types to python types. (edited)

sodasql/common/json_helper.py:17 def to_jsonnable(o):

tombaeyens avatar Apr 03 '21 21:04 tombaeyens

Asked UT about the missing Python type support. As Decimal seems to be handled.

https://soda-community.slack.com/archives/C01HYL8V64C/p1617709550103700?thread_ts=1615811570.096300&cid=C01HYL8V64C

tombaeyens avatar Apr 06 '21 11:04 tombaeyens