[
https://issues.apache.org/jira/browse/DRILL-1553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andries Engelbrecht updated DRILL-1553:
---------------------------------------
Description:
Ability for Drill to assign a NULL value to empty fields in CSV 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. Allows for simplification of joins, especially with columns from
different data sources.
was:
Ability for Drill to assign a NULL value to empty fields in CSV files.
Option to 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. Allows for simplification of joins, especially with columns from
different data sources.
> Assign NULL value for empty fields in CSV data sources
> ------------------------------------------------------
>
> Key: DRILL-1553
> URL: https://issues.apache.org/jira/browse/DRILL-1553
> Project: Apache Drill
> Issue Type: Improvement
> Components: Execution - Data Types
> Reporter: Andries Engelbrecht
>
> Ability for Drill to assign a NULL value to empty fields in CSV 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. Allows for simplification of joins, especially with columns from
> different data sources.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
