hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Remus Rusanu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13811) Constant not removed in index_auto_unused.q.out
Date Sun, 30 Apr 2017 18:44:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-13811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15990336#comment-15990336
] 

Remus Rusanu commented on HIVE-13811:
-------------------------------------

Original plant (before HIVE-13608):
{noformat}
   Stage: Stage-0
     Fetch Operator
       limit: -1
       Processor Tree:
-        TableScan
-          alias: srcpart
-          filterExpr: (UDFToDouble(key) < 10.0) (type: boolean)
-          Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-          Filter Operator
-            predicate: (UDFToDouble(key) < 10.0) (type: boolean)
-            Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats:
NONE
-            Select Operator
-              expressions: key (type: string), value (type: string), '2008-04-09' (type:
string), hr (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3
-              Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats:
NONE
-              ListSink
{noformat}

> Constant not removed in index_auto_unused.q.out
> -----------------------------------------------
>
>                 Key: HIVE-13811
>                 URL: https://issues.apache.org/jira/browse/HIVE-13811
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Remus Rusanu
>
> Follow-up on HIVE-13068.
> In test file ql/src/test/results/clientpositive/index_auto_unused.q.out.
> After HIVE-13068 goes in, the following filter is not folded after PartitionPruning is
done:
> {{filterExpr: ((ds = '2008-04-09') and (12.0 = 12.0) and (UDFToDouble(key) < 10.0))
(type: boolean)}}
> Further, SimpleFetchOptimizer got disabled.
> All this needs further investigation.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message