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

Implement a LOOKUP-TABLE JOIN function

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Timed Out
    • None
    • None
    • Code Generator

    Description

      There are many situations (e.g., scoring, tagging with percentiles), when you have a table of values with an ascending/descending key sequence (e.g., score), and you want to annotate records with the first match that satisfies a condition.

      You can do it at the moment with a filtered project. E.g.,

      myLookupDataset(score > myThreshold)[1].....

      but that isn't efficient for large datasets, and we should be able to generate a more efficient implementation.

      Triggered by a discussion of the new QUANTILE function.

      Attachments

        Activity

          People

            ghalliday Gavin Halliday
            ghalliday Gavin Halliday
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: