Hive
  1. Hive
  2. HIVE-1750

Remove Partition Filtering Conditions when Possible

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      For some simple queries, partition filtering constraints take 8% of CPU time (now 16% since we filter twice) even if the result is always true. When possible, we should remove these constraints to save CPU times.

      1. HIVE-1750.4.patch
        1.33 MB
        Siying Dong
      2. HIVE-1750.3.patch
        1.24 MB
        Siying Dong
      3. HIVE-1750.2.patch
        1.09 MB
        Siying Dong
      4. HIVE-1750.1.patch
        1.10 MB
        Siying Dong

        Issue Links

          Activity

          Siying Dong created issue -
          Siying Dong made changes -
          Field Original Value New Value
          Assignee Siying Dong [ sdong ]
          Siying Dong made changes -
          Attachment HIVE-1750.1.patch [ 12458592 ]
          Siying Dong made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Siying Dong made changes -
          Attachment HIVE-1750.2.patch [ 12458602 ]
          Siying Dong made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Siying Dong made changes -
          Attachment HIVE-1750.3.patch [ 12458702 ]
          Siying Dong made changes -
          Attachment HIVE-1750.4.patch [ 12458776 ]
          Siying Dong made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Fix Version/s 0.7.0 [ 12315150 ]
          Resolution Fixed [ 1 ]
          Namit Jain made changes -
          Link This issue is related to HIVE-1769 [ HIVE-1769 ]
          Namit Jain made changes -
          Link This issue is related to HIVE-1770 [ HIVE-1770 ]
          Namit Jain made changes -
          Link This issue relates to HIVE-1770 [ HIVE-1770 ]
          Namit Jain made changes -
          Link This issue relates to HIVE-1769 [ HIVE-1769 ]
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Siying Dong
              Reporter:
              Siying Dong
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development