hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20704) Extend HivePreFilteringRule to support other functions
Date Mon, 08 Oct 2018 10:34:00 GMT

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

Zoltan Haindrich commented on HIVE-20704:
-----------------------------------------

[~jcamachorodriguez] it seems to me that this patch goes back to using =-s operators in q53
for i_category for the second batch - is that expected?

{code}
--- a/ql/src/test/results/clientpositive/perf/spark/query53.q.out
+++ b/ql/src/test/results/clientpositive/perf/spark/query53.q.out
@@ -126,10 +126,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: item
-                  filterExpr: ((((i_category) IN ('Books', 'Children', 'Electronics') and
(i_class) IN ('personal', 'portable', 'reference', 'self-help') and (i_brand) IN ('scholaramalgamalg
#14', 'scholaramalgamalg #7', 'exportiunivamalg #9', 'scholaramalgamalg #9')) or ((i_category)
IN ('Women', 'Music', 'Men') and (i_class) IN ('accessories', 'classical', 'fragrances', 'pants')
and (i_brand) IN ('amalgimporto #1', 'edu packscholar #1', 'exportiimporto #1', 'importoamalg
#1'))) and i_item_sk is not null) (type: boolean)
+                  filterExpr: ((i_class) IN ('personal', 'portable', 'reference', 'self-help',
'accessories', 'classical', 'fragrances', 'pants') and (i_brand) IN ('scholaramalgamalg #14',
'scholaramalgamalg #7', 'exportiunivamalg #9', 'scholaramalgamalg #9', 'amalgimporto #1',
'edu packscholar #1', 'exportiimporto #1', 'importoamalg #1') and (i_category) IN ('Books',
'Children', 'Electronics', 'Women', 'Music', 'Men') and ((((i_category = 'Books') or (i_category
= 'Children') or (i_category = 'Electronics')) and ((i_class = 'personal') or (i_class = 'portable')
or (i_class = 'reference') or (i_class = 'self-help')) and ((i_brand = 'scholaramalgamalg
#14') or (i_brand = 'scholaramalgamalg #7') or (i_brand = 'exportiunivamalg #9') or (i_brand
= 'scholaramalgamalg #9'))) or (((i_category = 'Women') or (i_category = 'Music') or (i_category
= 'Men')) and ((i_class = 'accessories') or (i_class = 'classical') or (i_class = 'fragrances')
or (i_class = 'pants')) and ((i_brand = 'amalgimporto #1') or (i_brand = 'edu packscholar
#1') or (i_brand = 'exportiimporto #1') or (i_brand = 'importoamalg #1')))) and i_item_sk
is not null) (type: boolean)
                   Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE
Column stats: NONE
{code}

> Extend HivePreFilteringRule to support other functions
> ------------------------------------------------------
>
>                 Key: HIVE-20704
>                 URL: https://issues.apache.org/jira/browse/HIVE-20704
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: HIVE-20704.01.patch, HIVE-20704.01.patch, HIVE-20704.patch
>
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message