Skip to content

Instantly share code, notes, and snippets.

@Osiyuks

Osiyuks/HyperLogLog++

Last active October 23, 2019 21:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Osiyuks/0da855ee71d101dd1c6e725d4ef84bf6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Osiyuks/0da855ee71d101dd1c6e725d4ef84bf6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
HyperLogLog++
SELECT
HLL_COUNT.MERGE(users_hll) Users
FROM
(SELECT
trafficSource.source,
HLL_COUNT.INIT(fullVisitorId, 14) as users_hll
FROM `your_ga_table`
group by 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment