drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-3407) CTAS Auto Partition : The plan for count(*) should show the list of files scanned
Date Wed, 20 Sep 2017 22:27:00 GMT

     [ 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)

Mime
View raw message