Charles Givre created DRILL-7821:
------------------------------------
Summary: Treat Empty String as NULL
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
Fix For: 1.19.0
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)
