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

CTAS Auto Partition : The plan for count(*) should show the list of files scanned

    Details

      Description

      #Generated by Git-Commit-Id-Plugin
      #Fri Jun 26 19:46:34 UTC 2015
      git.commit.id.abbrev=60bc945

      The below plan does not give information about the list of files scanned

      0: jdbc:drill:schema=dfs_eea> explain plan for select count(*) from `existing_partition_pruning/lineitempart` where dir0=1991;
      +---------------------------------------------------------------------------------------------------------------------------------------------+-------+
      |                                                                    text                                                                     | json  |
      +---------------------------------------------------------------------------------------------------------------------------------------------+-------+
      | 00-00    Screen
      00-01      Project(EXPR$0=[$0])
      00-02        Scan(groupscan=[org.apache.drill.exec.store.pojo.PojoRecordReader@17153c76])
       | {
        "head" : {
          "version" : 1,
          "generator" : {
            "type" : "ExplainHandler",
            "info" : ""
          },
          "type" : "APACHE_DRILL_PHYSICAL",
          "options" : [ {
            "name" : "drill.exec.storage.file.partition.column.label",
            "kind" : "STRING",
            "type" : "SESSION",
            "string_val" : "partition_string1"
          } ],
          "queue" : 0,
          "resultMode" : "EXEC"
        },
        "graph" : [ {
          "pop" : "DirectGroupScan",
          "@id" : 2,
          "cost" : 20.0
        }, {
          "pop" : "project",
          "@id" : 1,
          "exprs" : [ {
            "ref" : "`EXPR$0`",
            "expr" : "`count`"
          } ],
          "child" : 2,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "cost" : 20.0
        }, {
          "pop" : "screen",
          "@id" : 0,
          "child" : 1,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "cost" : 20.0
        } ]
      } |
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                rkins Rahul Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: