Ticket #1848 (closed enhancement: fixed)

Opened 8 years ago

Last modified 6 years ago

extend partitioner to handle Ref*Match tables

Reported by: jbecla Owned by: smm
Priority: normal Milestone: qserv-usr2013
Component: qserv Keywords:
Cc: danielw, jbecla Blocked By:
Blocking: #1933, #2056, #2533 Project: LSST
Version Number:
How to repeat:

not applicable

Description (last modified by jbecla) (diff)

Discussed at DataAcc telecon dec 15, 2011. Need to be able to partition Ref*Match tables similarly to how the corresponding objects and simRefObjects are partitioned (provided there is sufficient overlap to capture fast moving objects)

Also, please provide input how the parser and query rewriter should handle the Ref*Match related joins.

Change History

comment:1 Changed 8 years ago by DefaultCC Plugin

  • Cc danielw added

comment:2 Changed 8 years ago by jbecla

  • Description modified (diff)

As

comment:3 Changed 8 years ago by DefaultCC Plugin

  • Blocked By 1933 added

comment:4 Changed 8 years ago by jbecla

  • Milestone set to S2012

comment:5 Changed 8 years ago by jbecla

  • Blocking 2056 added

comment:6 Changed 7 years ago by jbecla

  • Milestone changed from S2012 to qserv-beta1

comment:7 Changed 7 years ago by jbecla

  • Blocking 2533 added

comment:8 Changed 6 years ago by smm

  • Blocking 1933 added
  • Blocked By 1933 removed

comment:9 Changed 6 years ago by smm

  • Cc jbecla added
  • Status changed from new to closed
  • Resolution set to fixed

The new partitioner (implemented as part of #2458) supports Ref*Match tables. See db/Qserv/Partitioning for details on what was implemented and how a 3-way join involving a match table should be rewritten.

Note: See TracTickets for help on using tickets.