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

Implement non-equi mapjoin

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Patch Available
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 0.10.0
    • Fix Version/s: None
    • Component/s: Query Processor, SQL
    • Labels:
      None

      Description

      Currently, hive supports only equi-join which means all joining columns should be related only with equal operator(= or <=>).
      It seemed to be not easy to provide non-equi join in general manner but if one of table is small enough to be fit in memory, it might be possible to be implemented rather easily by exploiting current implementation of MapJoin.

        Attachments

          Activity

            People

            • Assignee:
              navis Navis Ryu
              Reporter:
              navis Navis Ryu
            • Votes:
              4 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

              • Created:
                Updated: