You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2017/08/15 15:09:00 UTC
[jira] [Resolved] (DRILL-3407) CTAS Auto Partition : The plan for
count(*) should show the list of files scanned
[ https://issues.apache.org/jira/browse/DRILL-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva resolved DRILL-3407.
-------------------------------------
Resolution: Fixed
Fix Version/s: (was: Future)
1.12.0
Fixed in the scope 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)