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

Qserv joins between director tables using match tables

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None

      Description

      As reported on https://community.lsst.org/t/qserv-using-neighbour-tables-to-perform-joins/3498.

      select blah from dbs.source as s, dbd.detection as d, dbm.neighbour as n
      where s.sourceID=n.sourceID and d.detectionID=n.detectionIDI getERROR 4110 
       
      (Proxy): Query processing error: QI=?: Failed to instantiate
      query: AnalysisError:Query involves partitioned table joins that Qserv does
      not know how to evaluate using only partition-local data 

        Attachments

          Issue Links

            Activity

            vaikunth Vaikunth Thukral created issue -
            vaikunth Vaikunth Thukral made changes -
            Field Original Value New Value
            Epic Link DM-16792 [ 236150 ]
            fritzm Fritz Mueller made changes -
            Epic Link DM-16792 [ 236150 ] DM-20061 [ 315688 ]
            gpdf Gregory Dubois-Felsmann made changes -
            Link This issue relates to DM-20837 [ DM-20837 ]
            npease Nate Pease made changes -
            Epic Link DM-20061 [ 315688 ] DM-22397 [ 427072 ]
            fritzm Fritz Mueller made changes -
            Epic Link DM-22397 [ 427072 ] DM-25261 [ 435605 ]

              People

              • Assignee:
                fritzm Fritz Mueller
                Reporter:
                vaikunth Vaikunth Thukral
                Watchers:
                Fritz Mueller, Gregory Dubois-Felsmann, Nate Pease, Vaikunth Thukral
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Summary Panel