Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19097 related equals and in operators may cause inaccurate stats estimations
  3. HIVE-19500

Prevent multiple selectivity estimations for the same variable in conjuctions

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.1.0, 3.0.0
    • 3.1.0, 4.0.0
    • None
    • None

    Description

      see HIVE-19097 for problem description

      for filters like: (d_year in (2001,2002) and d_year = 2001) the current estimation is around (1/NDV)**2 (iff column stats are available) ....

      actually the source of the problem was a small typo in HIVE-17465 

      Attachments

        1. HIVE-19500.01.patch
          38 kB
          Zoltan Haindrich
        2. HIVE-19500.02.patch
          71 kB
          Zoltan Haindrich
        3. HIVE-19500.03.patch
          115 kB
          Zoltan Haindrich
        4. HIVE-19500.03.patch
          115 kB
          Zoltan Haindrich

        Activity

          People

            kgyrtkirk Zoltan Haindrich
            kgyrtkirk Zoltan Haindrich
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: