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

BloomFilter check not showing up in MERGE statement queries

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment