Column medicare.admissions.bene

Overview of column bene in table medicare.admissions

Table	medicare.admissions
Qualified name	medicare.admissions.bene
Datatype	HLL_HASHVAL
Column type	generated
Reference	https://github.com/citusdata/postgresql-hll/blob/master/REFERENCE.md#basic-operational-functions

HLL hash (see https://en.wikipedia.org/wiki/HyperLogLog). Can be used to calculate number of beneficiaries satisfying a certain given condition Use #(hll_add_agg(bene)) or hll_cardinality(hll_add_agg(bene)) aggregator

Expressions

SELECT GENERATED ALWAYS AS (hll_hash_text(bene_id)) STORED

Data lineage for column medicare.admissions.bene