Dear Qserv devs,
We’ve been trying to do joint queries between equally partitioned director tables. A problem was found possibly due to missing chunks.
For example, if I do:
SELECT … FROM DirectorA AS a, DirectorB AS b WHERE scisql_angSep(a.ra, a.decl, b.ra, b.decl) < 0.0167,
where DirectorA and DirectorB are equally partitioned director tables (I’ve also unified their partition identifiers in CSS).
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.
And similar error is also found when we do joint queries between director and child which belongs to another director table.
Currently to make things work, I’m doing some sort of tricks by adding dummy empty chunks for all directors and modifying the qservw_worker.Chunks tables in the data servers. But this is not an ideal. Do you have plans to fix this in future releases? The last test I’ve done was in qserv_12.1-186.