A bug need to fix in hll webpage

[Haven Ganesh]

i am a developer in a corporate company,

and i want to learn about the hyperloglog, so i went through your webpage and i try those queries in postgresql, and there i stuck with a problem that was 

"INSERT INTO github_events_rollup_minute( created_at, event_type, distinct_user_id_count ) SELECT date_trunc('minute', created_at) AS created_at, event_type, sum(hll_hash_bigint(user_id)) FROM github_events GROUP BY 1, 2;"

in this query the sum() method doesn't work, cause the sum method wont work for the hll_hash_bigint datatype, so  i replace the sum() method by  hll_add_agg() and this will done the job as by mention the website.

the webpage link : https://www.citusdata.com/blog/2017/06/30/efficient-rollup-with-hyperloglog-on-postgres/

the OS I used : Ubuntu 20.04.5 LTS 64bit

postgres version: 15

system properties: Intel® Core™ i3-8109U CPU 

[Burak Yucesoy]

Hi Haven,

(cc @Claire Giordano for visibility)

Thanks for letting us know. I opened a PR to fix the blog content. It will be deployed soon.

Thanks,

Burak

---

From: citus...@googlegroups.com <citus...@googlegroups.com> on behalf of Haven Ganesh <ganeshma...@gmail.com>
Sent: Friday, November 18, 2022 08:38
To: citus-users <citus...@googlegroups.com>
Subject: [EXTERNAL] A bug need to fix in hll webpage

 

Some people who received this message don't often get email from ganeshma...@gmail.com. Learn why this is important

--
You received this message because you are subscribed to the Google Groups "citus-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to citus-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/citus-users/31073bc7-1a5c-44de-b75b-2aeafc75be17n%40googlegroups.com.

[Claire Giordano]

Hi Haven,

 

Thanks again for reporting the issue (and to Burak for fixing it.) We’ve updated the website, it’s now fixed. In the meantime, there are a few ways for you to stay connected to our team:

 

• In addition to googlegroups, you can always reach us on the Citus Slack.

 

• If you are using the Citus database extension, you can always file issues (or star the project ❤) on our citusdata/citus GitHub repo.

 

• Our Citus and Postgres team at Microsoft are hosting a free and virtual developer event called Citus Con: An Event for Postgres 2023, which will happen in April. The Call for Proposals is open NOW if you or any of your friends/teammates want to submit a talk proposal about Postgres, or Citus, or other open source Postgres extensions.

 

Thanks again for the feedback!

Claire

@clairegiordano on Twitter
@clairegiordano/@hachyderm.io on Mastodon