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