[DRILL-3407] CTAS Auto Partition : The plan for count(*) should show the list of files scanned

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Component/s: Query Planning & Optimization
• Assignee: Arina Ielchiieva
• Reporter: Rahul Kumar Challapalli
• Created: 26/Jun/15 21:54
• Updated: 20/Sep/17 22:26
• Resolved: 15/Aug/17 15:08

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
  } ]
} |

Issue Links

• Is contained by: DRILL-4735 Count(dir0) on parquet returns 0 result