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

            No work has yet been logged on this issue.

              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