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

Incorrect results reading complex data with schema change

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.1.0
    • 1.2.0
    • Execution - Data Types
    • None

    Description

      Given the data :

      {"some":"yes","others":{"other":"true","all":"false","sometimes":"yes"}}
      {"some":"yes","others":{"other":"true","all":"false","sometimes":"yes","additional":"last entries only"}}

      The query

      select `some`, t.others, t.others.additional from `test.json` t;

      produces incorrect results -

      yes {"additional":"last entries only"} last entries only

      instead of

      yes {"other":"true","all":"false","sometimes":"yes","additional":"last entries only"} last entries only

      Attachments

        Issue Links

        Activity

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

          People

            cchang@maprtech.com Chun Chang
            parthc Parth Chandra
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment