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

add metadata for untyped null and simple type promotion

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Future
    • Component/s: Execution - Data Types
    • Labels:
      None

      Description

      Currently when a field has literal null values in JSON the type will be assigned as BIGINT by default for lack of better type.
      ```
      {
      "a": null
      }
      ```
      if later on a is assigned with a string value the query will fail with a schema change error,

      The idea is to capture the notion of "untyped null" and implement simple type promotion from untyped null to the actual type.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                julienledem Julien Le Dem
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: