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

Flatten operator reports incorrect results when the repeated map has around 100 records or more

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=60aa446
      I ran the below test against the private branch of Jason which has some patches for bugs related to flatten which are not yet merged into the master.

      When we run the flatten operator on a record which contains 100 maps in a repeated type, the output is only showing 41 records. However everything works fine when repeated type contains only 50 records.

      Below is the query that I used

      select id, flatten(evnts) from `json_kvgenflatten/array-length-100.json`;
      ...
      ...
      40 rows selected (0.2 seconds)
      

      I attached the dataset. Let me know if you have any questions.

      Attachments

        1. array-length-100.json
          9 kB
          Rahul Kumar Challapalli

        Activity

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: