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.

Sign up for GitHub

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

Jump to bottom

Redacted joined spatial aggregate returns empty table #1747

Closed
jc-harrison opened this issue Jan 3, 2020 · 0 comments · Fixed by #1748
Closed

Redacted joined spatial aggregate returns empty table #1747

jc-harrison opened this issue Jan 3, 2020 · 0 comments · Fixed by #1748
Labels
bug Something isn't working FlowMachine Issues related to FlowMachine

Comments

@jc-harrison
Copy link
Member

RedactedJoinedSpatialAggregate redacts all rows, not just those with fewer than 15 subscribers.

This is because both the JoinedSpatialAggregate query and the RedactedSpatialAggregate query used for redaction have a value column, so the NATURAL JOIN uses this column to join, but the value columns contain different values.

The join to the RedactedSpatialAggregate should instead explicitly use the location ID columns.
@jc-harrison jc-harrison added bug Something isn't working FlowMachine Issues related to FlowMachine labels Jan 3, 2020
@jc-harrison jc-harrison mentioned this issue Jan 3, 2020
Merged
8 tasks
@mergify mergify bot closed this as completed in #1748 Jan 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working FlowMachine Issues related to FlowMachine
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix redacted joined spatial aggregate Flowminder/FlowKit
1 participant
@jc-harrison