[
https://issues.apache.org/jira/browse/DRILL-5919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242040#comment-16242040
]
Volodymyr Tkach edited comment on DRILL-5919 at 11/7/17 2:36 PM:
-----------------------------------------------------------------
1. Added two session options `store.json.reader.non_numeric_numbers` and
`store.json.reader.non_numeric_numbers` that allow to read/write `NaN` and
`Infinity` as numbers. By default these options are set to false;
2. Extended signature of `convert_toJSON` and `convert_fromJSON` functions by
adding second optional parameter that enables read/write `NaN` and `Infinity`.
For example:
`select convert_fromJSON('\{"key": NaN\}') from (values(1));` will result with
JsonParseException, but
`select convert_fromJSON('\{"key": NaN\}', true) from (values(1));` will parse
`NaN` as a number.
was (Author: volodymyr.tkach):
Added two session options `store.json.reader.non_numeric_numbers` and
`store.json.reader.non_numeric_numbers` that allow to read/write `NaN` and
`Infinity` as numbers. By default these options are set to false;
Also extended signature of `convert_toJSON` and `convert_fromJSON` functions by
adding second optional parameter that enables read/write `NaN` and `Infinity`.
For example:
`select convert_fromJSON('\{"key": NaN\}') from (values(1));` will result with
JsonParseException, but
`select convert_fromJSON('\{"key": NaN\}', true) from (values(1));` will parse
`NaN` as a number.
> Add non-numeric support for JSON processing
> -------------------------------------------
>
> Key: DRILL-5919
> URL: https://issues.apache.org/jira/browse/DRILL-5919
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - JSON
> Affects Versions: 1.11.0
> Reporter: Volodymyr Tkach
> Assignee: Volodymyr Tkach
> Fix For: Future
>
>
> Add session options to allow drill working with non standard json strings
> number literals like: NaN, Infinity, -Infinity. By default these options will
> be switched off, the user will be able to toggle them during working session.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
