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

Convert and cast are too sensitive/strict when dealing with empty string values

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.1.0
    • Future
    • Functions - Drill
    • None

    Description

      Working with slightly imperfect data is a hassle in drill unless one gives up and stores all data as strings.

      CONVERT_TO and CAST both throw exception if one is trying to convert empty string into numbers. These functions should return null value if the input is essentially a null value (or a pure string representation there off).

      Attachments

        Activity

          People

            Unassigned Unassigned
            acmeguy Stefán Baxter
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: