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

Optimizer: Rewrite Constant BETWEEN col1 and col2 for PPD

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Logical Optimizer

    Description

      CURRENT_DATE between start_date and end_date

      is not pushed down to the predicate layer, while the inclusive comparison ops

      start_date <= CURRENT_DATE and end_date >= CURRENT_DATE

      are evaluated at the row-index level.

      Attachments

        Activity

          People

            Unassigned Unassigned
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: