[jira] [Updated] (DRILL-1933) Update JSON reader to include recommendation to use all_text_mode with casts if numeric values are too large

["Steven Phillips (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Phillips updated DRILL-1933:
-----------------------------------
    Fix Version/s:     (was: 0.9.0)
                   1.0.0

> Update JSON reader to include recommendation to use all_text_mode with casts if numeric values are too large
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1933
>                 URL: https://issues.apache.org/jira/browse/DRILL-1933
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Steven Phillips
>            Priority: Minor
>             Fix For: 1.0.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)