postgresql-hll | PostgreSQL extension adding HyperLogLog data structures

 by   citusdata C Version: v2.17 License: Apache-2.0

kandi X-RAY | postgresql-hll Summary

kandi X-RAY | postgresql-hll Summary

postgresql-hll is a C library. postgresql-hll has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

This Postgres module introduces a new data type hll which is a [HyperLogLog] data structure. HyperLogLog is a fixed-size, set-like structure used for distinct value counting with tunable precision. For example, in 1280 bytes hll can estimate the count of tens of billions of distinct values with only a few percent error. In addition to the algorithm proposed in the [original paper] this implementation is augmented to improve its accuracy and memory use without sacrificing much speed. See below for more details. This postgresql-hll extension was originally developed by the Science team from Aggregate Knowledge, now a part of [Neustar] Please see the [acknowledgements] #acknowledgements) section below for details about its contributors.

            kandi-support Support

              postgresql-hll has a medium active ecosystem.
              It has 1003 star(s) with 110 fork(s). There are 62 watchers for this library.
              It had no major release in the last 12 months.
              There are 44 open issues and 37 have been closed. On average issues are closed in 301 days. There are 3 open pull requests and 0 closed requests.
              It has a neutral sentiment in the developer community.
              The latest version of postgresql-hll is v2.17

            kandi-Quality Quality

              postgresql-hll has 0 bugs and 0 code smells.

            kandi-Security Security

              postgresql-hll has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              postgresql-hll code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              postgresql-hll is licensed under the Apache-2.0 License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              postgresql-hll releases are available to install and integrate.
              Installation instructions, examples and code snippets are available.

            Top functions reviewed by kandi - BETA

            kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
            Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of postgresql-hll
            Get all kandi verified functions for this library.

            postgresql-hll Key Features

            No Key Features are available at this moment for postgresql-hll.

            postgresql-hll Examples and Code Snippets

            No Code Snippets are available at this moment for postgresql-hll.

            Community Discussions


            Django culmulative sum of HyperLogLog (HLL) Postgres field
            Asked 2020-May-26 at 07:55

            I'm using the HyperLogLog (hll) field to represent unique users, using the Django django-pg-hll package. What I'd like to do is get a cumulative total of unique users over a specific time period, but I'm having trouble doing this.

            Given a model like:



            Answered 2020-May-26 at 07:55

            This bug occurs because the django-pg-hll pacakage uses the hll_cardinalityfunction instead of the # operator for window functions. Moving to a raw sql solution fixed the issue.


            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install postgresql-hll

            After you’ve built and installed the artifacts, fire up psql:.


            For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • HTTPS


          • CLI

            gh repo clone citusdata/postgresql-hll

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link