[jira] [Commented] (DRILL-1933) JsonReader fails to read bigint values

["Jason Altekruse (JIRA)" <ji...@apache.org>]

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

Jason Altekruse commented on DRILL-1933:
----------------------------------------

This can currently be achieved by setting `store.json.all_text_mode` to TRUE before doing the cast. We might need to discuss if this should be handled more gracefully in the future. The issue is that we currently read numbers without decimal point as Long/BigInt values by default, the limits it gives in the error message are the min/max values of the long type in java.

> JsonReader fails to read bigint values
> --------------------------------------
>
>                 Key: DRILL-1933
>                 URL: https://issues.apache.org/jira/browse/DRILL-1933
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Hanifi Gunes
>            Priority: Minor
>             Fix For: 0.8.0
>
>         Attachments: error.log
>
>
> git.commit.id.abbrev=b491cdb
> Data Set :
> {code}
> {
>     "col1" : 14994882832830675451
> }
> {code}
> Query :
> {code}
> select * from `bigint.json`;
> Query failed: Query stopped., Numeric value (14994882832830675451) out of range of long (-9223372036854775808 - 9223372036854775807)
>  at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@23543f97; line: 1, column: 34] [ 8716695b-0438-43b7-a645-77a29213a4b2 on qa-node191.qa.lab:31010 ]
> {code}
> Explicitly trying to cast also yielded the same result.
> I attached the log file. Let me know if you need anything



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)