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

BloomFilter check not showing up in MERGE statement queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • Query Planning
    • 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.4.patch
          111 kB
          Jason Dere
        2. HIVE-16022.3.patch
          116 kB
          Jason Dere
        3. HIVE-16022.2.patch
          114 kB
          Jason Dere
        4. HIVE-16022.1.patch
          114 kB
          Jason Dere

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: