Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-17152

Fringe dataset does not easily fit the current Gen3 butler concept

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Invalid
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Team:
      Data Access and Database

      Description

      Only exposures with certain filters need to find fringe data. If the exposure under consideration is in one of those filters, the current Gen3 butler sql JOINs should find it correctly. However, for filters that do not need a fringe, the current JOINs will return an empty set, as there is no valid fringe for that filter. Doing this in pure SQL would suggest we want a LEFT JOIN to the fringe data, so we can either return the matching data or NULL, and deal with the consequences downstream, but my understanding is that we do not support that kind of JOIN.

        Attachments

          Issue Links

            Activity

            No builds found.
            czw Christopher Waters created issue -
            czw Christopher Waters made changes -
            Field Original Value New Value
            Link This issue FF-depends on DM-16467 [ DM-16467 ]
            swinbank John Swinbank made changes -
            Team Data Access and Database [ 10204 ]
            jbosch Jim Bosch made changes -
            Link This issue relates to DM-16805 [ DM-16805 ]
            czw Christopher Waters made changes -
            Link This issue duplicates DM-21739 [ DM-21739 ]
            czw Christopher Waters made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10001 ] Invalid [ 11005 ]

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              czw Christopher Waters
              Watchers:
              Christopher Waters
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  CI Builds

                  No builds found.