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

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

              Dates

              • Created:
                Updated:
                Resolved: