Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1553

Assign NULL value for empty fields in CSV data sources

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • Execution - Data Types
    • None

    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.

      Attachments

        Activity

          People

            paul-rogers Paul Rogers
            aengelbrecht Andries Engelbrecht
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: