Skip to content
This repository has been archived by the owner on Mar 2, 2021. It is now read-only.

Looker: some page view IDs are lost due to deduplication logic in web_page_context #43

Open
tomekzbrozek opened this issue Nov 19, 2019 · 0 comments

Comments

@tomekzbrozek
Copy link

There's a deduplication logic in this line

SELECT * FROM prep WHERE root_id NOT IN (SELECT root_id FROM prep GROUP BY 1 HAVING COUNT(*) > 1) -- exclude all root ID with more than one page view ID

that makes root IDs associated to multiple rows filtered out from the events that are processed further. What's the rationale behind this? Shouldn't the model drop only duplicate values, but keep at least one event per root ID / page view ID?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant