Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Prevent target_id to be matched with multiple catalogids #4

Open
albireox opened this issue May 28, 2020 · 0 comments
Open

Prevent target_id to be matched with multiple catalogids #4

albireox opened this issue May 28, 2020 · 0 comments
Assignees

Comments

@albireox
Copy link
Member

Currently, in phase 2, there is nothing preventing a target to be matched with multiple catalogids as long as they are all within valid distance in the radial query.

To prevent this we could add an initial window function to the cross-match query, partitioning by target_id and selecting only first_value with the closest distance to catalogid. That query would be treated as a subquery to which we then apply the usual partition to define best.

@albireox albireox self-assigned this May 28, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant