Jason Dere created HIVE-16022:
---------------------------------
Summary: BloomFilter check not showing up in MERGE statement
queries
Key: HIVE-16022
URL: https://issues.apache.org/jira/browse/HIVE-16022
Project: Hive
Issue Type: Bug
Components: Query Planning
Reporter: Jason Dere
Assignee: Jason Dere
Running explain on a MERGE statement with runtime filtering enabled, I see the
min/max being applied on the large table, but not the bloom filter check:
{noformat}
explain merge into acidTbl as t using nonAcidOrcTbl s ON t.a = s.a
WHEN MATCHED AND s.a > 8 THEN DELETE
WHEN MATCHED THEN UPDATE SET b = 7
WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b)
...
Map 1
Map Operator Tree:
TableScan
alias: t
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
Filter Operator
predicate: a BETWEEN DynamicValue(RS_3_s_a_min) AND
DynamicValue(RS_3_s_a_max) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)