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

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)