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)

Reply via email to