[jira] [Created] (DRILL-1554) Assign NULL value for empty text fields in JSON data sources

["Andries Engelbrecht (JIRA)" <ji...@apache.org>]

Andries Engelbrecht created DRILL-1554:
------------------------------------------

             Summary: Assign NULL value for empty text fields in JSON data sources
                 Key: DRILL-1554
                 URL: https://issues.apache.org/jira/browse/DRILL-1554
             Project: Apache Drill
          Issue Type: Improvement
            Reporter: Andries Engelbrecht


Ability for Drill to assign a NULL value to empty text fields in JSON files.
Option to be set at session or system level to implement this assignment.

Avoids errors when casting to different data types without the need to check for empty fields first. Simplifies predicate filters and avoid potential mistakes, if empty text values need to be ignored. Allows for simplification of joins, if casting of data type is required, especially with columns from different data sources.




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