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

Missing chunks in Qserv during joins between director tables

    Details

    • Type: Bug
    • Status: To Do
    • Priority: Undefined
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Templates:
    • Story Points:
      6
    • Team:
      Data Access and Database

      Description

      As reported on https://community.lsst.org/t/problem-with-joining-directors-in-qserv/3496.

      SELECT … FROM DirectorA AS a, DirectorB AS b WHERE scisql_angSep(a.ra, a.decl, b.ra, b.decl) < 0.0167, 

      Such queries fail with 

      The query will likely fail, and the log suggests this is due to missing chunks. For example if DirectorA has chunks 400,444 and DirectorB has only 400, Qserv tries to find 444 for DirectorB anyway 

        Attachments

          Container Issues

            Activity

              People

              • Assignee:
                jgates John Gates
                Reporter:
                vaikunth Vaikunth Thukral
                Watchers:
                Fritz Mueller, Nate Pease, Vaikunth Thukral
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Summary Panel