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

Add ability to join different databases.

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      DB_S17_5
    • Team:
      Data Access and Database

      Description

      Joins between two databases are not working. On the PDAC, stripe82 cannot be joined with WISE, despite using identical partitioning methods. This is probably a result of an expectation that qserv would onlt access one database at time.

      An example of this would be an attempt to figure out all entries from the ForcedSource table of WISE catalog (database wise_00) which correspond to the rejected objects of the catalog (those objects live in a separate database wise_ext_00):

      SELECT COUNT(ForcedSource.source_id_mf)
        FROM
          wise_ext_00.Reject Reject,
          wise_00.ForcedSource ForcedSource
        WHERE
          Reject.source_id LIKE '0000m016_ac51-000002'
        AND ForcedSource.source_id_mf = Reject.source_id;
      ERROR 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
      

      The only relevant line in the CZAR's log file is:

      [2017-04-21T16:01:43.412-0500] [LWP:346] ERROR ccontrol.UserQueryFactory (core/modules/ccontrol/UserQueryFactory.cc:114)
      - Invalid 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:
              jgates John Gates
              Reporter:
              jgates John Gates
              Reviewers:
              Andy Salnikov, Igor Gaponenko
              Watchers:
              Andy Salnikov, Igor Gaponenko, John Gates, Serge Monkewitz
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: