Uploaded image for project: 'HPCC'
  1. HPCC
  2. HPCC-8722

Add MAX(n) attribute to JOIN

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Timed Out
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Code Generator
    • Labels:

      Description

      Add a MAX option to a JOIN to indicate a hint of the maximum number of RIGHT rows that can ever match each LEFT row.

      MAX(1) could be used to trigger an optimization converting a left outer join to a project.

      If debug mode is selected it should remain, and the max() will be converted to a limit().

      (Also check optimization of no_denormalizegroup in hqlfold.cpp)

        Attachments

          Activity

            People

            • Assignee:
              anybody Available for anyone
              Reporter:
              ghalliday Gavin Halliday
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: