Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-16022

BloomFilter check not showing up in MERGE statement queries

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.0
    • Component/s: Query Planning
    • Labels:
      None

      Description

      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:

      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
      

        Attachments

        1. HIVE-16022.1.patch
          114 kB
          Jason Dere
        2. HIVE-16022.2.patch
          114 kB
          Jason Dere
        3. HIVE-16022.3.patch
          116 kB
          Jason Dere
        4. HIVE-16022.4.patch
          111 kB
          Jason Dere

          Issue Links

            Activity

              People

              • Assignee:
                jdere Jason Dere
                Reporter:
                jdere Jason Dere
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: