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

Fringe dataset does not easily fit the current Gen3 butler concept

    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

            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
                Reporter:
                czw Christopher Waters
                Watchers:
                Christopher Waters
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Summary Panel