Rahul Challapalli created DRILL-3407: ----------------------------------------
Summary: CTAS Auto Partition : The plan for count(*) should show the list of files scanned Key: DRILL-3407 URL: https://issues.apache.org/jira/browse/DRILL-3407 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Reporter: Rahul Challapalli Assignee: Jinfeng Ni Priority: Minor Fix For: 1.2.0 #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 {code} 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 } ] } | {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)