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

Give simple MJ bigger priority than bucketized ones

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • None
    • None
    • Statistics
    • None

    Description

      from the code it seems "standard" mapjoin is one of the last one tried; in case the table estimated to be bucketed in to 2 - but it's small ; Hive willl do a bucketmapjoin or dphj...even thru a simple mapjoin could have been an alternative...
      https://github.com/apache/hive/blob/154ca3e3b5eb78cd49a4b3650c750ca731fba7da/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConvertJoinMapJoin.java#L157

      Attachments

        1. HIVE-20504.01.patch
          3 kB
          Zoltan Haindrich
        2. HIVE-20504.01.patch
          3 kB
          Zoltan Haindrich
        3. HIVE-20504.01wip01.patch
          3 kB
          Zoltan Haindrich
        4. HIVE-20504.01wip01.patch
          3 kB
          Zoltan Haindrich

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: