[ https://issues.apache.org/jira/browse/DRILL-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chun Chang closed DRILL-3407. ----------------------------- Part of DRILL-4735. > 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: Arina Ielchiieva > Priority: Minor > Fix For: 1.12.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.4.14#64029)