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

Strange results with near neighbor queries.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Team:
      Data Access and Database

      Description

      Queries similar to following give strange results.

      • SELECT COUNT  FROM Object o1, Object o2 WHERE qserv_areaspec_box(...) AND scisql_angSep(o1.ra, o1.decl, o2.ra, o2.decl) < 0.015; returns about 76 million
      • SELECT COUNT  FROM Object o1, Object o2 WHERE scisql_angSep(o1.ra, o1.decl, o2.ra, o2.decl) < 0.015; returns about 52 million

      The second query should return many more results than the first as it should not be limited to a particular region of the sky, so something is not right. Also, it is important that distinct works properly with these queries.

        Attachments

          Issue Links

            Activity

            Hide
            gcomoretto Gabriele Comoretto [X] (Inactive) added a comment -

            This issue has been escalated to the DMCCB since it seems no work has been done for a long time.

            Is it still a valid issue?

            Please address with a comment or a change of status.

            Show
            gcomoretto Gabriele Comoretto [X] (Inactive) added a comment - This issue has been escalated to the DMCCB since it seems no work has been done for a long time. Is it still a valid issue? Please address with a comment or a change of status.
            Hide
            fritzm Fritz Mueller added a comment -

            John Gates: do we know if this is still an issue?  From 2016 – probably KPM10 or KPM20 dataset?  We might try this form of query again against Stripe82 on the NCSA cluster?

            Show
            fritzm Fritz Mueller added a comment - John Gates : do we know if this is still an issue?  From 2016 – probably KPM10 or KPM20 dataset?  We might try this form of query again against Stripe82 on the NCSA cluster?

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jgates John Gates
              Watchers:
              Fritz Mueller, Gabriele Comoretto [X] (Inactive), John Gates
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.