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

Improve Hive/Calcite Transitive Predicate inference

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0, 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: CBO
    • Labels:
      None
    • Target Version/s:

      Description

      HiveJoinPushTransitivePredicatesRule does not pull up predicates for transitive inference if they contain more than one column.

      EXPLAIN select * from srcpart join (select ds as ds, ds as `date` from srcpart where  (ds = '2008-04-08' and value=1)) s on (srcpart.ds = s.ds);
      

        Attachments

        1. HIVE-12478.patch
          25 kB
          Jesus Camacho Rodriguez
        2. HIVE-12478.01.patch
          42 kB
          Jesus Camacho Rodriguez
        3. HIVE-12478.02.patch
          44 kB
          Jesus Camacho Rodriguez
        4. HIVE-12478.03.patch
          241 kB
          Jesus Camacho Rodriguez
        5. HIVE-12478.04.patch
          237 kB
          Jesus Camacho Rodriguez
        6. HIVE-12478.05.patch
          1.05 MB
          Jesus Camacho Rodriguez
        7. HIVE-12478.06.patch
          1.02 MB
          Jesus Camacho Rodriguez
        8. HIVE-12478.07.patch
          27 kB
          Jesus Camacho Rodriguez
        9. HIVE-12478.08.patch
          1.08 MB
          Jesus Camacho Rodriguez
        10. HIVE-12478.09.patch
          1.09 MB
          Jesus Camacho Rodriguez
        11. HIVE-12478.10.patch
          1.51 MB
          Jesus Camacho Rodriguez
        12. HIVE-12478.11.patch
          1.20 MB
          Jesus Camacho Rodriguez
        13. HIVE-12478.12.patch
          1.24 MB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jpullokkaran Laljo John Pullokkaran
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: