🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa181)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa089.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap\')), getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap","crawl_time":1774795980,"first_indexed_time":1740603828,"http_code":200,"src_unparsed":"com,clickhouse!\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"groupBitmap | ClickHouse Docs","meta_descriptions":["Bitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object"],"attrs_boilerpipe_text":"groupBitmap\n\nIntroduced in: v20.1.0\nCreates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap.\nBy appending the\n-State\ncombinator suffix, instead of returning the count, it returns the actual\nbitmap object\n.\nSyntax\ngroupBitmap\n(\nexpr\n)\ngroupBitmapState\n(\nexpr\n)\nArguments\nexpr\n— Expression that results in a\nUInt*\ntype.\nUInt*\nReturned value\nReturns the count of type UInt64 type, or a bitmap object when using\n-State\n.\nUInt64\nExamples\nUsage example\nQuery\nCREATE\nTABLE\nt\n(\nUserID UInt32\n)\nENGINE\n=\nMemory\n;\nINSERT\nINTO\nt\nVALUES\n(\n1\n)\n,\n(\n1\n)\n,\n(\n2\n)\n,\n(\n3\n)\n;\nSELECT\ngroupBitmap\n(\nUserID\n)\nAS\nnum\nFROM\nt\n;\nResponse\n┌─num─┐\n│   3 │\n└─────┘","attrs_markdown":"[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap#__docusaurus_skipToContent_fallback)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\n- [Products](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n  \n  [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n- [Use cases](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Machine Learning & Generative AI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [Business Intelligence](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Logs, Events, Traces](https:\/\/clickhouse.com\/use-cases\/observability)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases](https:\/\/clickhouse.com\/use-cases)\n- [Documentation](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparison](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.6k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982)\n\n[Get started](https:\/\/clickhouse.com\/docs\/introduction-clickhouse)\n\n[Cloud](https:\/\/clickhouse.com\/docs\/cloud\/overview)\n\n[Manage data](https:\/\/clickhouse.com\/docs\/updating-data)\n\n[Server admin](https:\/\/clickhouse.com\/docs\/guides\/manage-and-deploy-index)\n\n[Reference](https:\/\/clickhouse.com\/docs\/sql-reference)\n\n[Integrations](https:\/\/clickhouse.com\/docs\/integrations)\n\n[ClickStack](https:\/\/clickhouse.com\/docs\/use-cases\/observability\/clickstack\/overview)\n\n[chDB](https:\/\/clickhouse.com\/docs\/chdb)\n\n[About](https:\/\/clickhouse.com\/docs\/about)\n\n[Knowledge Base](https:\/\/clickhouse.com\/docs\/knowledgebase)\n\n[English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n\n[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap#__docusaurus_skipToContent_fallback)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\n- [Products](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n  \n  [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n- [Use cases](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Machine Learning & Generative AI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [Business Intelligence](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Logs, Events, Traces](https:\/\/clickhouse.com\/use-cases\/observability)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases](https:\/\/clickhouse.com\/use-cases)\n- [Documentation](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparison](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.6k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982)\n\n[Get started](https:\/\/clickhouse.com\/docs\/introduction-clickhouse)\n\n[Cloud](https:\/\/clickhouse.com\/docs\/cloud\/overview)\n\n[Manage data](https:\/\/clickhouse.com\/docs\/updating-data)\n\n[Server admin](https:\/\/clickhouse.com\/docs\/guides\/manage-and-deploy-index)\n\n[Reference](https:\/\/clickhouse.com\/docs\/sql-reference)\n\n[Integrations](https:\/\/clickhouse.com\/docs\/integrations)\n\n[ClickStack](https:\/\/clickhouse.com\/docs\/use-cases\/observability\/clickstack\/overview)\n\n[chDB](https:\/\/clickhouse.com\/docs\/chdb)\n\n[About](https:\/\/clickhouse.com\/docs\/about)\n\n[Knowledge Base](https:\/\/clickhouse.com\/docs\/knowledgebase)\n\n[English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n- [Introduction](https:\/\/clickhouse.com\/docs\/sql-reference)\n  - [Syntax](https:\/\/clickhouse.com\/docs\/sql-reference\/syntax)\n  - [Input and Output Formats](https:\/\/clickhouse.com\/docs\/sql-reference\/formats)\n  - [Data types](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types)\n  - [Statements](https:\/\/clickhouse.com\/docs\/sql-reference\/statements)\n  - [Operators](https:\/\/clickhouse.com\/docs\/sql-reference\/operators)\n- [Engines](https:\/\/clickhouse.com\/docs\/engines)\n  - [Database Engines](https:\/\/clickhouse.com\/docs\/engines\/database-engines)\n  - [Table Engines](https:\/\/clickhouse.com\/docs\/engines\/table-engines)\n- [Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions)\n  - [Regular functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions\/regular-functions)\n  - [Aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions)\n    - [Aggregate Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n      - [aggThrow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/aggthrow)\n      - [analysisOfVariance](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/analysis_of_variance)\n      - [any](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any)\n      - [anyHeavy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anyheavy)\n      - [anyLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anylast)\n      - [approx\\_top\\_k](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopk)\n      - [approx\\_top\\_sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopsum)\n      - [argAndMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmax)\n      - [argAndMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmin)\n      - [argMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax)\n      - [argMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmin)\n      - [avg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avg)\n      - [avgWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avgweighted)\n      - [boundingRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/boundingRatio)\n      - [categoricalInformationValue](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/categoricalinformationvalue)\n      - [contingency](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/contingency)\n      - [corr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corr)\n      - [corrMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrmatrix)\n      - [corrStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrstable)\n      - [count](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/count)\n      - [covarPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpop)\n      - [covarPopMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopmatrix)\n      - [covarPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopstable)\n      - [covarSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsamp)\n      - [covarSampMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampmatrix)\n      - [covarSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampstable)\n      - [cramersV](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersv)\n      - [cramersVBiasCorrected](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersvbiascorrected)\n      - [deltaSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasum)\n      - [deltaSumTimestamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasumtimestamp)\n      - [distinctDynamicTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctdynamictypes)\n      - [distinctJSONPaths](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctjsonpaths)\n      - [distinctJSONPathsAndTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctJSONPathsAndTypes)\n      - [entropy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/entropy)\n      - [estimateCompressionRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/estimateCompressionRatio)\n      - [exponentialMovingAverage](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialMovingAverage)\n      - [exponentialTimeDecayedAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedAvg)\n      - [exponentialTimeDecayedCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedCount)\n      - [exponentialTimeDecayedMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedMax)\n      - [exponentialTimeDecayedSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedSum)\n      - [first\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value)\n      - [flameGraph](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/flame_graph)\n      - [groupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparray)\n      - [groupArrayArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayarray)\n      - [groupArrayInsertAt](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayinsertat)\n      - [groupArrayIntersect](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayintersect)\n      - [groupArrayLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraylast)\n      - [groupArrayMovingAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingavg)\n      - [groupArrayMovingSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingsum)\n      - [groupArraySample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysample)\n      - [groupArraySorted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysorted)\n      - [groupBitAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitand)\n      - [groupBitOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitor)\n      - [groupBitXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitxor)\n      - [groupBitmap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n      - [groupBitmapAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapand)\n      - [groupBitmapOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapor)\n      - [groupBitmapXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapxor)\n      - [groupConcat](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupconcat)\n      - [groupUniqArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupuniqarray)\n      - [intervalLengthSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/intervalLengthSum)\n      - [kolmogorovSmirnovTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kolmogorovsmirnovtest)\n      - [kurtPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtpop)\n      - [kurtSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtsamp)\n      - [largestTriangleThreeBuckets](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/largestTriangleThreeBuckets)\n      - [last\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/last_value)\n      - [mannWhitneyUTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/mannwhitneyutest)\n      - [max](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/max)\n      - [maxIntersections](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersections)\n      - [maxIntersectionsPosition](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersectionsposition)\n      - [maxMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxmap)\n      - [meanZTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/meanztest)\n      - [median](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/median)\n      - [min](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/min)\n      - [minMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/minmap)\n      - [quantile](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantile)\n      - [quantileBFloat16](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilebfloat16)\n      - [quantileDD](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileddsketch)\n      - [quantileDeterministic](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiledeterministic)\n      - [quantileExact Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexact)\n      - [quantileExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactExclusive)\n      - [quantileExactHigh](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactHigh)\n      - [quantileExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactInclusive)\n      - [quantileExactLow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactLow)\n      - [quantileExactWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexactweighted)\n      - [quantileExactWeightedInterpolated](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactWeightedInterpolated)\n      - [quantileGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileGK)\n      - [quantileInterpolatedWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileInterpolatedWeighted)\n      - [quantilePrometheusHistogram](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilePrometheusHistogram)\n      - [quantileTDigest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigest)\n      - [quantileTDigestWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigestweighted)\n      - [quantileTiming](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletiming)\n      - [quantileTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletimingweighted)\n      - [quantiles Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiles)\n      - [quantilesExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactExclusive)\n      - [quantilesExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactInclusive)\n      - [quantilesGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesGK)\n      - [quantilesTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilestimingweighted)\n      - [rankCorr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/rankCorr)\n      - [simpleLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/simplelinearregression)\n      - [singleValueOrNull](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/singlevalueornull)\n      - [skewPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewpop)\n      - [skewSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewsamp)\n      - [sparkbar](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sparkbar)\n      - [stddevPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpop)\n      - [stddevPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpopstable)\n      - [stddevSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsamp)\n      - [stddevSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsampstable)\n      - [stochasticLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlinearregression)\n      - [stochasticLogisticRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlogisticregression)\n      - [studentTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttest)\n      - [studentTTestOneSample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttestonesample)\n      - [sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sum)\n      - [sumCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumcount)\n      - [sumKahan](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumkahan)\n      - [sumMapWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summapwithoverflow)\n      - [sumMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summap)\n      - [sumWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumwithoverflow)\n      - [theilsU](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/theilsu)\n      - [timeSeriesChangesToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesChangesToGrid)\n      - [timeSeriesDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDeltaToGrid)\n      - [timeSeriesDerivToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDerivToGrid)\n      - [timeSeriesGroupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesGroupArray)\n      - [timeSeriesInstantDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantDeltaToGrid)\n      - [timeSeriesInstantRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantRateToGrid)\n      - [timeSeriesLastTwoSamples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesLastTwoSamples)\n      - [timeSeriesPredictLinearToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesPredictLinearToGrid)\n      - [timeSeriesRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesRateToGrid)\n      - [timeSeriesResampleToGridWithStaleness](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResampleToGridWithStaleness)\n      - [timeSeriesResetsToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResetsToGrid)\n      - [topK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topk)\n      - [topKWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topkweighted)\n      - [uniq](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniq)\n      - [uniqCombined](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined)\n      - [uniqCombined64](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined64)\n      - [uniqExact](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqexact)\n      - [uniqHLL12](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqhll12)\n      - [uniqTheta](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqthetasketch)\n      - [varPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varPop)\n      - [varPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varpopstable)\n      - [varSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varSamp)\n      - [varSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varsampstable)\n      - [welchTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/welchttest)\n    - [Combinators](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/combinators)\n    - [Parametric](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/parametric-functions)\n    - [GROUPING](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/grouping_function)\n    - [Combinator examples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n  - [Table functions](https:\/\/clickhouse.com\/docs\/sql-reference\/table-functions)\n  - [Window functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions)\n- [Formats](https:\/\/clickhouse.com\/docs\/interfaces\/formats)\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)\n\n- [Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions)\n- [Aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions)\n- [Aggregate Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n- groupBitmap\n\n[Edit this page](https:\/\/github.com\/ClickHouse\/ClickHouse\/tree\/master\/docs\/en\/sql-reference\/aggregate-functions\/reference\/groupBitmap.md)\n\n# groupBitmap\n## groupBitmap[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap#groupBitmap \"Direct link to groupBitmap\")\nIntroduced in: v20.1.0\n\nCreates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap. By appending the `-State` combinator suffix, instead of returning the count, it returns the actual [bitmap object](https:\/\/clickhouse.com\/docs\/sql-reference\/functions\/bitmap-functions).\n\n**Syntax**\n```\ngroupBitmap(expr)\ngroupBitmapState(expr)\n```\n**Arguments**\n\n- `expr` — Expression that results in a `UInt*` type. [`UInt*`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint)\n\n**Returned value**\n\nReturns the count of type UInt64 type, or a bitmap object when using `-State`. [`UInt64`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint)\n\n**Examples**\n\n**Usage example**\n\nQuery\n```\nCREATE TABLE t (UserID UInt32) ENGINE = Memory;\nINSERT INTO t VALUES (1), (1), (2), (3);\n\nSELECT groupBitmap(UserID) AS num FROM t;\n```\n\nResponse\n```\n┌─num─┐\n│   3 │\n└─────┘\n```\n\n[Previous groupBitXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitxor)\n\n[Next groupBitmapAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapand)\n\n- [groupBitmap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap#groupBitmap)\n\nWas this page helpful?\n\n###### Try ClickHouse Cloud for FREE\nSeparation of storage and compute, automatic scaling, built-in SQL console, and lots more. \\$300 in free credits when signing up.\n\n[Try it for Free](https:\/\/console.clickhouse.cloud\/signUp?loc=doc-card-banner&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982)\n\n© 2016–2026 ClickHouse, Inc.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)·[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)·[Security](https:\/\/trust.clickhouse.com\/)·[Terms of Service](https:\/\/clickhouse.com\/legal\/agreements\/terms-of-service)\n\n![](https:\/\/static.scarf.sh\/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91)\n\n© 2016–2026 ClickHouse, Inc.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)·[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)·[Security](https:\/\/trust.clickhouse.com\/)·[Terms of Service](https:\/\/clickhouse.com\/legal\/agreements\/terms-of-service)\n\n![](https:\/\/static.scarf.sh\/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\nEN\n\n- Get started▼\n- Cloud▼\n- Manage data▼\n- Server admin▼\n- Reference▼\n- Integrations▼\n- ClickStack▼\n- chDB▼\n- About▼\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\nEN\n\nmain-menu\n\n- Introduction▼\n  - [Syntax](https:\/\/clickhouse.com\/docs\/sql-reference\/syntax)\n  - [Input and Output Formats](https:\/\/clickhouse.com\/docs\/sql-reference\/formats)\n  - Data types▼\n  - Statements▼\n  - Operators▼\n- Engines▼\n- Functions▼\n  - Regular functions▼\n  - Aggregate functions▼\n    - Aggregate Functions▼\n      - [aggThrow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/aggthrow)\n      - [analysisOfVariance](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/analysis_of_variance)\n      - [any](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any)\n      - [anyHeavy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anyheavy)\n      - [anyLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anylast)\n      - [approx\\_top\\_k](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopk)\n      - [approx\\_top\\_sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopsum)\n      - [argAndMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmax)\n      - [argAndMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmin)\n      - [argMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax)\n      - [argMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmin)\n      - [avg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avg)\n      - [avgWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avgweighted)\n      - [boundingRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/boundingRatio)\n      - [categoricalInformationValue](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/categoricalinformationvalue)\n      - [contingency](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/contingency)\n      - [corr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corr)\n      - [corrMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrmatrix)\n      - [corrStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrstable)\n      - [count](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/count)\n      - [covarPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpop)\n      - [covarPopMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopmatrix)\n      - [covarPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopstable)\n      - [covarSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsamp)\n      - [covarSampMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampmatrix)\n      - [covarSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampstable)\n      - [cramersV](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersv)\n      - [cramersVBiasCorrected](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersvbiascorrected)\n      - [deltaSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasum)\n      - [deltaSumTimestamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasumtimestamp)\n      - [distinctDynamicTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctdynamictypes)\n      - [distinctJSONPaths](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctjsonpaths)\n      - [distinctJSONPathsAndTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctJSONPathsAndTypes)\n      - [entropy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/entropy)\n      - [estimateCompressionRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/estimateCompressionRatio)\n      - [exponentialMovingAverage](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialMovingAverage)\n      - [exponentialTimeDecayedAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedAvg)\n      - [exponentialTimeDecayedCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedCount)\n      - [exponentialTimeDecayedMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedMax)\n      - [exponentialTimeDecayedSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedSum)\n      - [first\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value)\n      - [flameGraph](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/flame_graph)\n      - [groupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparray)\n      - [groupArrayArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayarray)\n      - [groupArrayInsertAt](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayinsertat)\n      - [groupArrayIntersect](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayintersect)\n      - [groupArrayLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraylast)\n      - [groupArrayMovingAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingavg)\n      - [groupArrayMovingSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingsum)\n      - [groupArraySample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysample)\n      - [groupArraySorted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysorted)\n      - [groupBitAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitand)\n      - [groupBitOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitor)\n      - [groupBitXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitxor)\n      - [groupBitmap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n      - [groupBitmapAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapand)\n      - [groupBitmapOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapor)\n      - [groupBitmapXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapxor)\n      - [groupConcat](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupconcat)\n      - [groupUniqArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupuniqarray)\n      - [intervalLengthSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/intervalLengthSum)\n      - [kolmogorovSmirnovTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kolmogorovsmirnovtest)\n      - [kurtPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtpop)\n      - [kurtSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtsamp)\n      - [largestTriangleThreeBuckets](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/largestTriangleThreeBuckets)\n      - [last\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/last_value)\n      - [mannWhitneyUTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/mannwhitneyutest)\n      - [max](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/max)\n      - [maxIntersections](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersections)\n      - [maxIntersectionsPosition](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersectionsposition)\n      - [maxMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxmap)\n      - [meanZTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/meanztest)\n      - [median](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/median)\n      - [min](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/min)\n      - [minMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/minmap)\n      - [quantile](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantile)\n      - [quantileBFloat16](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilebfloat16)\n      - [quantileDD](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileddsketch)\n      - [quantileDeterministic](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiledeterministic)\n      - [quantileExact Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexact)\n      - [quantileExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactExclusive)\n      - [quantileExactHigh](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactHigh)\n      - [quantileExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactInclusive)\n      - [quantileExactLow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactLow)\n      - [quantileExactWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexactweighted)\n      - [quantileExactWeightedInterpolated](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactWeightedInterpolated)\n      - [quantileGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileGK)\n      - [quantileInterpolatedWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileInterpolatedWeighted)\n      - [quantilePrometheusHistogram](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilePrometheusHistogram)\n      - [quantileTDigest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigest)\n      - [quantileTDigestWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigestweighted)\n      - [quantileTiming](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletiming)\n      - [quantileTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletimingweighted)\n      - [quantiles Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiles)\n      - [quantilesExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactExclusive)\n      - [quantilesExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactInclusive)\n      - [quantilesGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesGK)\n      - [quantilesTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilestimingweighted)\n      - [rankCorr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/rankCorr)\n      - [simpleLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/simplelinearregression)\n      - [singleValueOrNull](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/singlevalueornull)\n      - [skewPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewpop)\n      - [skewSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewsamp)\n      - [sparkbar](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sparkbar)\n      - [stddevPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpop)\n      - [stddevPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpopstable)\n      - [stddevSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsamp)\n      - [stddevSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsampstable)\n      - [stochasticLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlinearregression)\n      - [stochasticLogisticRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlogisticregression)\n      - [studentTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttest)\n      - [studentTTestOneSample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttestonesample)\n      - [sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sum)\n      - [sumCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumcount)\n      - [sumKahan](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumkahan)\n      - [sumMapWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summapwithoverflow)\n      - [sumMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summap)\n      - [sumWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumwithoverflow)\n      - [theilsU](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/theilsu)\n      - [timeSeriesChangesToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesChangesToGrid)\n      - [timeSeriesDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDeltaToGrid)\n      - [timeSeriesDerivToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDerivToGrid)\n      - [timeSeriesGroupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesGroupArray)\n      - [timeSeriesInstantDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantDeltaToGrid)\n      - [timeSeriesInstantRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantRateToGrid)\n      - [timeSeriesLastTwoSamples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesLastTwoSamples)\n      - [timeSeriesPredictLinearToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesPredictLinearToGrid)\n      - [timeSeriesRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesRateToGrid)\n      - [timeSeriesResampleToGridWithStaleness](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResampleToGridWithStaleness)\n      - [timeSeriesResetsToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResetsToGrid)\n      - [topK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topk)\n      - [topKWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topkweighted)\n      - [uniq](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniq)\n      - [uniqCombined](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined)\n      - [uniqCombined64](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined64)\n      - [uniqExact](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqexact)\n      - [uniqHLL12](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqhll12)\n      - [uniqTheta](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqthetasketch)\n      - [varPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varPop)\n      - [varPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varpopstable)\n      - [varSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varSamp)\n      - [varSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varsampstable)\n      - [welchTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/welchttest)\n    - [Combinators](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/combinators)\n    - [Parametric](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/parametric-functions)\n    - [GROUPING](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/grouping_function)\n    - Combinator examples▼\n  - Table functions▼\n  - Window functions▼\n- Formats▼\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)","attrs_readable_markdown":"## groupBitmap[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap#groupBitmap \"Direct link to groupBitmap\")\nIntroduced in: v20.1.0\n\nCreates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap. By appending the `-State` combinator suffix, instead of returning the count, it returns the actual [bitmap object](https:\/\/clickhouse.com\/docs\/sql-reference\/functions\/bitmap-functions).\n\n**Syntax**\n```\ngroupBitmap(expr)\ngroupBitmapState(expr)\n```\n**Arguments**\n\n- `expr` — Expression that results in a `UInt*` type. [`UInt*`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint)\n\n**Returned value**\n\nReturns the count of type UInt64 type, or a bitmap object when using `-State`. [`UInt64`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint)\n\n**Examples**\n\n**Usage example**\n\nQuery\n```\nCREATE TABLE t (UserID UInt32) ENGINE = Memory;\nINSERT INTO t VALUES (1), (1), (2), (3);\n\nSELECT groupBitmap(UserID) AS num FROM t;\n```\n\nResponse\n```\n┌─num─┐\n│   3 │\n└─────┘\n```","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

9 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.3 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap
Last Crawled	2026-03-29 14:53:00 (9 days ago)
First Indexed	2025-02-26 21:03:48 (1 year ago)
HTTP Status Code	200
Meta Title	groupBitmap \| ClickHouse Docs
Meta Description	Bitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object
Meta Canonical	null
Boilerpipe Text	groupBitmap Introduced in: v20.1.0 Creates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap. By appending the -State combinator suffix, instead of returning the count, it returns the actual bitmap object . Syntax groupBitmap ( expr ) groupBitmapState ( expr ) Arguments expr — Expression that results in a UInt* type. UInt* Returned value Returns the count of type UInt64 type, or a bitmap object when using -State . UInt64 Examples Usage example Query CREATE TABLE t ( UserID UInt32 ) ENGINE = Memory ; INSERT INTO t VALUES ( 1 ) , ( 1 ) , ( 2 ) , ( 3 ) ; SELECT groupBitmap ( UserID ) AS num FROM t ; Response ┌─num─┐ │ 3 │ └─────┘
Markdown	[Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https://clickhouse.com/clickhouse) - [Discover more than 100 integrations.](https://clickhouse.com/integrations) [Discover more than 100 integrations.](https://clickhouse.com/integrations) - [Use cases](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Machine Learning & Generative AI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [Business Intelligence](https://clickhouse.com/use-cases/data-warehousing) - [Logs, Events, Traces](https://clickhouse.com/use-cases/observability) - [All use cases](https://clickhouse.com/use-cases) [All use cases](https://clickhouse.com/use-cases) - [Documentation](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [Learning and certification](https://clickhouse.com/learn) - [Comparison](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.6k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982) [Get started](https://clickhouse.com/docs/introduction-clickhouse) [Cloud](https://clickhouse.com/docs/cloud/overview) [Manage data](https://clickhouse.com/docs/updating-data) [Server admin](https://clickhouse.com/docs/guides/manage-and-deploy-index) [Reference](https://clickhouse.com/docs/sql-reference) [Integrations](https://clickhouse.com/docs/integrations) [ClickStack](https://clickhouse.com/docs/use-cases/observability/clickstack/overview) [chDB](https://clickhouse.com/docs/chdb) [About](https://clickhouse.com/docs/about) [Knowledge Base](https://clickhouse.com/docs/knowledgebase) [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/groupbitmap) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/groupbitmap) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/groupbitmap) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/groupbitmap) [Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https://clickhouse.com/clickhouse) - [Discover more than 100 integrations.](https://clickhouse.com/integrations) [Discover more than 100 integrations.](https://clickhouse.com/integrations) - [Use cases](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Machine Learning & Generative AI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [Business Intelligence](https://clickhouse.com/use-cases/data-warehousing) - [Logs, Events, Traces](https://clickhouse.com/use-cases/observability) - [All use cases](https://clickhouse.com/use-cases) [All use cases](https://clickhouse.com/use-cases) - [Documentation](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [Learning and certification](https://clickhouse.com/learn) - [Comparison](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.6k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982) [Get started](https://clickhouse.com/docs/introduction-clickhouse) [Cloud](https://clickhouse.com/docs/cloud/overview) [Manage data](https://clickhouse.com/docs/updating-data) [Server admin](https://clickhouse.com/docs/guides/manage-and-deploy-index) [Reference](https://clickhouse.com/docs/sql-reference) [Integrations](https://clickhouse.com/docs/integrations) [ClickStack](https://clickhouse.com/docs/use-cases/observability/clickstack/overview) [chDB](https://clickhouse.com/docs/chdb) [About](https://clickhouse.com/docs/about) [Knowledge Base](https://clickhouse.com/docs/knowledgebase) [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/groupbitmap) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/groupbitmap) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/groupbitmap) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/groupbitmap) [Search`Ctrl``K`](https://clickhouse.com/docs/search) - [Introduction](https://clickhouse.com/docs/sql-reference) - [Syntax](https://clickhouse.com/docs/sql-reference/syntax) - [Input and Output Formats](https://clickhouse.com/docs/sql-reference/formats) - [Data types](https://clickhouse.com/docs/sql-reference/data-types) - [Statements](https://clickhouse.com/docs/sql-reference/statements) - [Operators](https://clickhouse.com/docs/sql-reference/operators) - [Engines](https://clickhouse.com/docs/engines) - [Database Engines](https://clickhouse.com/docs/engines/database-engines) - [Table Engines](https://clickhouse.com/docs/engines/table-engines) - [Functions](https://clickhouse.com/docs/sql-reference/functions) - [Regular functions](https://clickhouse.com/docs/sql-reference/functions/regular-functions) - [Aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions) - [Aggregate Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [aggThrow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/aggthrow) - [analysisOfVariance](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/analysis_of_variance) - [any](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) - [anyHeavy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anyheavy) - [anyLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anylast) - [approx\_top\_k](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopk) - [approx\_top\_sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopsum) - [argAndMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmax) - [argAndMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmin) - [argMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) - [argMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmin) - [avg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avg) - [avgWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avgweighted) - [boundingRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/boundingRatio) - [categoricalInformationValue](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/categoricalinformationvalue) - [contingency](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/contingency) - [corr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corr) - [corrMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrmatrix) - [corrStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrstable) - [count](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/count) - [covarPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpop) - [covarPopMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopmatrix) - [covarPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopstable) - [covarSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsamp) - [covarSampMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampmatrix) - [covarSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampstable) - [cramersV](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersv) - [cramersVBiasCorrected](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersvbiascorrected) - [deltaSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasum) - [deltaSumTimestamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasumtimestamp) - [distinctDynamicTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctdynamictypes) - [distinctJSONPaths](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctjsonpaths) - [distinctJSONPathsAndTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctJSONPathsAndTypes) - [entropy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/entropy) - [estimateCompressionRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/estimateCompressionRatio) - [exponentialMovingAverage](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialMovingAverage) - [exponentialTimeDecayedAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedAvg) - [exponentialTimeDecayedCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedCount) - [exponentialTimeDecayedMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedMax) - [exponentialTimeDecayedSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedSum) - [first\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) - [flameGraph](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/flame_graph) - [groupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparray) - [groupArrayArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayarray) - [groupArrayInsertAt](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayinsertat) - [groupArrayIntersect](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayintersect) - [groupArrayLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraylast) - [groupArrayMovingAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingavg) - [groupArrayMovingSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingsum) - [groupArraySample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysample) - [groupArraySorted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysorted) - [groupBitAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitand) - [groupBitOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitor) - [groupBitXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitxor) - [groupBitmap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [groupBitmapAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapand) - [groupBitmapOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapor) - [groupBitmapXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapxor) - [groupConcat](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupconcat) - [groupUniqArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupuniqarray) - [intervalLengthSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/intervalLengthSum) - [kolmogorovSmirnovTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kolmogorovsmirnovtest) - [kurtPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtpop) - [kurtSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtsamp) - [largestTriangleThreeBuckets](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/largestTriangleThreeBuckets) - [last\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/last_value) - [mannWhitneyUTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/mannwhitneyutest) - [max](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/max) - [maxIntersections](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersections) - [maxIntersectionsPosition](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersectionsposition) - [maxMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxmap) - [meanZTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/meanztest) - [median](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/median) - [min](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/min) - [minMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/minmap) - [quantile](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantile) - [quantileBFloat16](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilebfloat16) - [quantileDD](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileddsketch) - [quantileDeterministic](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiledeterministic) - [quantileExact Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexact) - [quantileExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactExclusive) - [quantileExactHigh](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactHigh) - [quantileExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactInclusive) - [quantileExactLow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactLow) - [quantileExactWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexactweighted) - [quantileExactWeightedInterpolated](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactWeightedInterpolated) - [quantileGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileGK) - [quantileInterpolatedWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileInterpolatedWeighted) - [quantilePrometheusHistogram](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilePrometheusHistogram) - [quantileTDigest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigest) - [quantileTDigestWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigestweighted) - [quantileTiming](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletiming) - [quantileTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletimingweighted) - [quantiles Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiles) - [quantilesExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactExclusive) - [quantilesExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactInclusive) - [quantilesGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesGK) - [quantilesTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilestimingweighted) - [rankCorr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/rankCorr) - [simpleLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/simplelinearregression) - [singleValueOrNull](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/singlevalueornull) - [skewPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewpop) - [skewSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewsamp) - [sparkbar](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sparkbar) - [stddevPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpop) - [stddevPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpopstable) - [stddevSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsamp) - [stddevSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsampstable) - [stochasticLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlinearregression) - [stochasticLogisticRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlogisticregression) - [studentTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttest) - [studentTTestOneSample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttestonesample) - [sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sum) - [sumCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumcount) - [sumKahan](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumkahan) - [sumMapWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summapwithoverflow) - [sumMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summap) - [sumWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumwithoverflow) - [theilsU](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/theilsu) - [timeSeriesChangesToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesChangesToGrid) - [timeSeriesDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDeltaToGrid) - [timeSeriesDerivToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDerivToGrid) - [timeSeriesGroupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesGroupArray) - [timeSeriesInstantDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantDeltaToGrid) - [timeSeriesInstantRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantRateToGrid) - [timeSeriesLastTwoSamples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesLastTwoSamples) - [timeSeriesPredictLinearToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesPredictLinearToGrid) - [timeSeriesRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesRateToGrid) - [timeSeriesResampleToGridWithStaleness](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResampleToGridWithStaleness) - [timeSeriesResetsToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResetsToGrid) - [topK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topk) - [topKWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topkweighted) - [uniq](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniq) - [uniqCombined](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined) - [uniqCombined64](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined64) - [uniqExact](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqexact) - [uniqHLL12](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqhll12) - [uniqTheta](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqthetasketch) - [varPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varPop) - [varPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varpopstable) - [varSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varSamp) - [varSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varsampstable) - [welchTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/welchttest) - [Combinators](https://clickhouse.com/docs/sql-reference/aggregate-functions/combinators) - [Parametric](https://clickhouse.com/docs/sql-reference/aggregate-functions/parametric-functions) - [GROUPING](https://clickhouse.com/docs/sql-reference/aggregate-functions/grouping_function) - [Combinator examples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [Table functions](https://clickhouse.com/docs/sql-reference/table-functions) - [Window functions](https://clickhouse.com/docs/sql-reference/window-functions) - [Formats](https://clickhouse.com/docs/interfaces/formats) - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes) - [Functions](https://clickhouse.com/docs/sql-reference/functions) - [Aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions) - [Aggregate Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - groupBitmap [Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/sql-reference/aggregate-functions/reference/groupBitmap.md) # groupBitmap ## groupBitmap[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap#groupBitmap "Direct link to groupBitmap") Introduced in: v20.1.0 Creates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap. By appending the `-State` combinator suffix, instead of returning the count, it returns the actual [bitmap object](https://clickhouse.com/docs/sql-reference/functions/bitmap-functions). Syntax ``` groupBitmap(expr) groupBitmapState(expr) ``` Arguments - `expr` — Expression that results in a `UInt` type. [`UInt`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) Returned value Returns the count of type UInt64 type, or a bitmap object when using `-State`. [`UInt64`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) Examples Usage example Query ``` CREATE TABLE t (UserID UInt32) ENGINE = Memory; INSERT INTO t VALUES (1), (1), (2), (3); SELECT groupBitmap(UserID) AS num FROM t; ``` Response ``` ┌─num─┐ │ 3 │ └─────┘ ``` [Previous groupBitXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitxor) [Next groupBitmapAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapand) - [groupBitmap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap#groupBitmap) Was this page helpful? ###### Try ClickHouse Cloud for FREE Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. \$300 in free credits when signing up. [Try it for Free](https://console.clickhouse.cloud/signUp?loc=doc-card-banner&glxid=555ee6d2-a191-4aec-83b1-04274d65ecbc&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fgroupbitmap&utm_ga=GA1.1.1512782381.1774795982) © 2016–2026 ClickHouse, Inc. [Trademark](https://clickhouse.com/legal/trademark-policy)·[Privacy](https://clickhouse.com/legal/privacy-policy)·[Security](https://trust.clickhouse.com/)·[Terms of Service](https://clickhouse.com/legal/agreements/terms-of-service) ![](https://static.scarf.sh/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91) © 2016–2026 ClickHouse, Inc. [Trademark](https://clickhouse.com/legal/trademark-policy)·[Privacy](https://clickhouse.com/legal/privacy-policy)·[Security](https://trust.clickhouse.com/)·[Terms of Service](https://clickhouse.com/legal/agreements/terms-of-service) ![](https://static.scarf.sh/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) EN - Get started▼ - Cloud▼ - Manage data▼ - Server admin▼ - Reference▼ - Integrations▼ - ClickStack▼ - chDB▼ - About▼ [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) EN main-menu - Introduction▼ - [Syntax](https://clickhouse.com/docs/sql-reference/syntax) - [Input and Output Formats](https://clickhouse.com/docs/sql-reference/formats) - Data types▼ - Statements▼ - Operators▼ - Engines▼ - Functions▼ - Regular functions▼ - Aggregate functions▼ - Aggregate Functions▼ - [aggThrow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/aggthrow) - [analysisOfVariance](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/analysis_of_variance) - [any](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) - [anyHeavy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anyheavy) - [anyLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anylast) - [approx\_top\_k](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopk) - [approx\_top\_sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopsum) - [argAndMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmax) - [argAndMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmin) - [argMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) - [argMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmin) - [avg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avg) - [avgWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avgweighted) - [boundingRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/boundingRatio) - [categoricalInformationValue](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/categoricalinformationvalue) - [contingency](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/contingency) - [corr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corr) - [corrMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrmatrix) - [corrStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrstable) - [count](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/count) - [covarPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpop) - [covarPopMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopmatrix) - [covarPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopstable) - [covarSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsamp) - [covarSampMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampmatrix) - [covarSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampstable) - [cramersV](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersv) - [cramersVBiasCorrected](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersvbiascorrected) - [deltaSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasum) - [deltaSumTimestamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasumtimestamp) - [distinctDynamicTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctdynamictypes) - [distinctJSONPaths](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctjsonpaths) - [distinctJSONPathsAndTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctJSONPathsAndTypes) - [entropy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/entropy) - [estimateCompressionRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/estimateCompressionRatio) - [exponentialMovingAverage](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialMovingAverage) - [exponentialTimeDecayedAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedAvg) - [exponentialTimeDecayedCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedCount) - [exponentialTimeDecayedMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedMax) - [exponentialTimeDecayedSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedSum) - [first\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) - [flameGraph](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/flame_graph) - [groupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparray) - [groupArrayArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayarray) - [groupArrayInsertAt](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayinsertat) - [groupArrayIntersect](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayintersect) - [groupArrayLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraylast) - [groupArrayMovingAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingavg) - [groupArrayMovingSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingsum) - [groupArraySample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysample) - [groupArraySorted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysorted) - [groupBitAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitand) - [groupBitOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitor) - [groupBitXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitxor) - [groupBitmap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [groupBitmapAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapand) - [groupBitmapOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapor) - [groupBitmapXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapxor) - [groupConcat](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupconcat) - [groupUniqArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupuniqarray) - [intervalLengthSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/intervalLengthSum) - [kolmogorovSmirnovTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kolmogorovsmirnovtest) - [kurtPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtpop) - [kurtSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtsamp) - [largestTriangleThreeBuckets](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/largestTriangleThreeBuckets) - [last\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/last_value) - [mannWhitneyUTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/mannwhitneyutest) - [max](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/max) - [maxIntersections](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersections) - [maxIntersectionsPosition](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersectionsposition) - [maxMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxmap) - [meanZTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/meanztest) - [median](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/median) - [min](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/min) - [minMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/minmap) - [quantile](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantile) - [quantileBFloat16](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilebfloat16) - [quantileDD](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileddsketch) - [quantileDeterministic](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiledeterministic) - [quantileExact Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexact) - [quantileExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactExclusive) - [quantileExactHigh](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactHigh) - [quantileExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactInclusive) - [quantileExactLow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactLow) - [quantileExactWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexactweighted) - [quantileExactWeightedInterpolated](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactWeightedInterpolated) - [quantileGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileGK) - [quantileInterpolatedWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileInterpolatedWeighted) - [quantilePrometheusHistogram](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilePrometheusHistogram) - [quantileTDigest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigest) - [quantileTDigestWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigestweighted) - [quantileTiming](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletiming) - [quantileTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletimingweighted) - [quantiles Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiles) - [quantilesExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactExclusive) - [quantilesExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactInclusive) - [quantilesGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesGK) - [quantilesTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilestimingweighted) - [rankCorr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/rankCorr) - [simpleLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/simplelinearregression) - [singleValueOrNull](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/singlevalueornull) - [skewPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewpop) - [skewSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewsamp) - [sparkbar](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sparkbar) - [stddevPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpop) - [stddevPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpopstable) - [stddevSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsamp) - [stddevSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsampstable) - [stochasticLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlinearregression) - [stochasticLogisticRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlogisticregression) - [studentTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttest) - [studentTTestOneSample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttestonesample) - [sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sum) - [sumCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumcount) - [sumKahan](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumkahan) - [sumMapWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summapwithoverflow) - [sumMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summap) - [sumWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumwithoverflow) - [theilsU](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/theilsu) - [timeSeriesChangesToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesChangesToGrid) - [timeSeriesDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDeltaToGrid) - [timeSeriesDerivToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDerivToGrid) - [timeSeriesGroupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesGroupArray) - [timeSeriesInstantDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantDeltaToGrid) - [timeSeriesInstantRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantRateToGrid) - [timeSeriesLastTwoSamples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesLastTwoSamples) - [timeSeriesPredictLinearToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesPredictLinearToGrid) - [timeSeriesRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesRateToGrid) - [timeSeriesResampleToGridWithStaleness](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResampleToGridWithStaleness) - [timeSeriesResetsToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResetsToGrid) - [topK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topk) - [topKWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topkweighted) - [uniq](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniq) - [uniqCombined](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined) - [uniqCombined64](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined64) - [uniqExact](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqexact) - [uniqHLL12](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqhll12) - [uniqTheta](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqthetasketch) - [varPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varPop) - [varPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varpopstable) - [varSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varSamp) - [varSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varsampstable) - [welchTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/welchttest) - [Combinators](https://clickhouse.com/docs/sql-reference/aggregate-functions/combinators) - [Parametric](https://clickhouse.com/docs/sql-reference/aggregate-functions/parametric-functions) - [GROUPING](https://clickhouse.com/docs/sql-reference/aggregate-functions/grouping_function) - Combinator examples▼ - Table functions▼ - Window functions▼ - Formats▼ - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes)
Readable Markdown	## groupBitmap[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap#groupBitmap "Direct link to groupBitmap") Introduced in: v20.1.0 Creates a bitmap (bit array) from a column of unsigned integers, then returns the count of unique values (cardinality) in that bitmap. By appending the `-State` combinator suffix, instead of returning the count, it returns the actual [bitmap object](https://clickhouse.com/docs/sql-reference/functions/bitmap-functions). Syntax ``` groupBitmap(expr) groupBitmapState(expr) ``` Arguments - `expr` — Expression that results in a `UInt` type. [`UInt`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) Returned value Returns the count of type UInt64 type, or a bitmap object when using `-State`. [`UInt64`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) Examples Usage example Query ``` CREATE TABLE t (UserID UInt32) ENGINE = Memory; INSERT INTO t VALUES (1), (1), (2), (3); SELECT groupBitmap(UserID) AS num FROM t; ``` Response ``` ┌─num─┐ │ 3 │ └─────┘ ```
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/docs/sql-reference/aggregate-functions/reference/groupbitmap s443