[jira] [Comment Edited] (ARROW-7875) [Java] Decimal place getting shifted

["Larry Parker (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-7875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040168#comment-17040168 ] 

Larry Parker edited comment on ARROW-7875 at 2/19/20 3:34 PM:
--------------------------------------------------------------

Redshift:
     scale = 2
    precision = 38

MSSQL:
     scale = 0
    precision = 15

Denodo:
     scale = 20
    precision = 38

 


was (Author: lparker):
Redshift
--------

scale = 2
precision = 38


MSSQL
--------

scale = 0
precision = 15


Denodo
--------

scale = 20
precision = 38

 

> [Java] Decimal place getting shifted
> ------------------------------------
>
>                 Key: ARROW-7875
>                 URL: https://issues.apache.org/jira/browse/ARROW-7875
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: Java
>            Reporter: Larry Parker
>            Priority: Major
>         Attachments: test_file.arrow
>
>
> I used {{JdbcToArrow.sqlToArrow()}} to create an Arrow file from a SQL result set, and when I read the Arrow file back in PyArrow, the decimal numbers are very small. On the order of E-10.
> What's interesting is that the values are "correct", except the decimal places are shifted over.
> The Arrow file is enclosed.
> Please let me know if there's a bug around this.
> (using 0.14.1 of Arrow)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)