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

Operators listed in Profiles Page doesn't always correspond with operator specified in Physical Plan

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

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.12.0
    • 1.13.0
    • Web Server

    Description

      A query's physical plan correctly shows

       00-00 Screen : rowType = RecordType(BIGINT EXPR$0): rowcount = 1.0, cumulative cost = { ...
         00-01 Project(EXPR$0=[$0]) : rowType = RecordType(BIGINT EXPR$0): rowcount = 1.0, cumulative cost = { ...
           00-02 StreamAgg(group=[{}], EXPR$0=[$SUM0($0)]) : rowType = RecordType(BIGINT EXPR$0): rowcount = 1.0, cumulative cost = { ...
             00-03 UnionExchange : rowType = RecordType(BIGINT EXPR$0): rowcount = 1.0, cumulative cost = { ...
               01-01 StreamAgg(group=[{}], EXPR$0=[COUNT()]) : rowType = RecordType(BIGINT EXPR$0): rowcount = 1.0, cumulative cost = { ...
                 01-02 Project($f0=[0]) : rowType = RecordType(INTEGER $f0): rowcount = 1.79279253E7, cumulative cost = ...
                   01-03 Flatten(flattenField=[$1]) : rowType = RecordType(ANY rfsSpecCode, ...
                     01-04 Project(rfsSpecCode=[$1], PUResultsArray=[$2]) : rowType = ...
                       01-05 SelectionVectorRemover : rowType = RecordType(ANY schemaName, ...
                         01-06 Filter(condition=[=($0, 'OnyxBlue')]) : rowType = ...
                           01-07 Project(schemaName=[$0], ITEM=[ITEM($1, 'rfsSpecCode')], ...
                             01-08 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [
      

      However, the profile page shows the operators as...

      Operator ID Type Metrics
      00-xx-00 SCREEN ...
      00-xx-01 PROJECT ...
      00-xx-02 STREAMING_AGGREGATE ...
      00-xx-03 UNORDERED_RECEIVER ...
      01-xx-00 SINGLE_SENDER ...
      01-xx-01 STREAMING_AGGREGATE ...
      01-xx-02 PROJECT ...
      01-xx-03 SINGLE_SENDER ...
      01-xx-04 PROJECT ...
      01-xx-05 SELECTION_VECTOR_REMOVER ...
      01-xx-06 FILTER ...
      01-xx-07 PROJECT ...
      01-xx-08 PARQUET_ROW_GROUP_SCAN ...

      As you can see ... FLATTEN operator appears as a SINGLE_SENDER making the profile hard to interpret.

      Attachments

        Issue Links

        Activity

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

          People

            kkhatua Kunal Khatua
            kkhatua Kunal Khatua
            Aman Sinha Aman Sinha
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment