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

add metadata for untyped null and simple type promotion

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • Execution - Data Types
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            julienledem Julien Le Dem

            Dates

              Created:
              Updated:

              Issue deployment