[jira] [Resolved] (DRILL-7821) Treat Empty String as NULL in JSON Reader

["Cong Luo (Jira)" <ji...@apache.org>]

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

Cong Luo resolved DRILL-7821.
-----------------------------
      Reviewer: Charles Givre
    Resolution: Fixed

> Treat Empty String as NULL in JSON Reader
> -----------------------------------------
>
>                 Key: DRILL-7821
>                 URL: https://issues.apache.org/jira/browse/DRILL-7821
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>    Affects Versions: 1.17.0
>            Reporter: Charles Givre
>            Priority: Major
>             Fix For: 1.19.0
>
>         Attachments: servicenow.json
>
>
> In the JSON below the field `resolved_by` first appears as a map but in records when it is not defined, is empty strings.  This causes SchemaChangeExceptions. 
> I'm wondering if Drill could either ignore or interpret the empty strings as null so that the query will complete.
>  
> {{{
>  ....
>    "skills": "",
>        "number": "INC0000001",
>        *"resolved_by": {*
>          *"link": "https://empmgill4.service-now.com/api/now/table/sys_user/6816f79cc0a8016401c5a33be04be441",*
>          *"value": "6816f79cc0a8016401c5a33be04be441"*
>        *},*
>        "sys_updated_by": "admin"
>  ...
>  },
> {       ...       "number": "INC0000002",       *"resolved_by": "",*       "sys_updated_by": "admin", ... }}
> }



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