Column medicare.qc_enrollments.NumDistinctBeneficaries Lineage SVG

medicare.qc_enrollments.NumDistinctBeneficaries medicare.qc_enrollments.NumDistinctBeneficaries (#(hll_add_agg(bene)))::BIGINT medicare.qc_enrl_bene.bene medicare.qc_enrl_bene.bene HLL hash (see https://en.wikipedia.org/w iki/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 GENERATED ALWAYS AS (hll_hash_text(bene_id)) STORED medicare.qc_enrl_bene.bene->medicare.qc_enrollments.NumDistinctBeneficaries  Transformed medicare.enrollments.bene_id medicare.enrollments.bene_id medicare.enrollments.bene_id->medicare.qc_enrl_bene.bene join natural medicare._enrollments.bene_id medicare._enrollments.bene_id medicare._enrollments.bene_id->medicare.enrollments.bene_id Copied medicare._ps.bene_id medicare._ps.bene_id medicare._ps.bene_id->medicare._enrollments.bene_id  Aggregated On bene_id, year, state medicare._beneficiaries.bene_id medicare._beneficiaries.bene_id medicare._ps.bene_id->medicare._beneficiaries.bene_id  Aggregated On bene_id medicare._ps.bene_id->medicare._beneficiaries.bene_id  Aggregated On bene_id medicare.ps.bene_id medicare.ps.bene_id medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id_parent 8 incoming links (columns) medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id->medicare.qc_enrl_bene.bene join natural medicare.beneficiaries.bene_id->medicare.enrollments.bene_id Copied medicare._beneficiaries.bene_id->medicare.beneficiaries.bene_id Copied medicare._beneficiaries.bene_id->medicare.beneficiaries.bene_id Copied