Blog Twitter Discord Telegram Signup/Login

Getting Started
Features
Building Blocks
- Data Connectors
- Model Providers
API
Portal
Use-Cases
SDKs
Integrations
REFERENCE
Pricing
- Paid Plans
- Community Plan
Support
- Support
Security
- Security at Spice AI
- Report a vulnerability
Legal

Powered by GitBook

On this page

Was this helpful?

Last updated 2 years ago

Was this helpful?

Syntax

HLL(expression boolean) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression float) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression varbinary) → varbinary

expression: Expression for which you want to know the number of distinct values.

HLL(expression date) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression interval_year) → varbinary

expression: Expression for which you want to know the number of distinct values.

HLL(expression interval_day) → varbinary

expression: Expression for which you want to know the number of distinct values.

HLL(expression int64) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression double) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression time) → varbinary

expression: Expression for which you want to know the number of distinct values.

HLL(expression int32) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression varchar) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

HLL(expression timestamp) → varbinary

expression: Expression for which you want to know the number of distinct values.

Examples

REFERENCE

SQL Reference

SQL Functions

Aggregate

HLL

Uses HyperLogLog to return an approximation of the distinct cardinality of the input.

HLL example

SELECT HLL(TRUE)
-- sample return

HLL example

SELECT HLL(67.90)
-- sample return

HLL example

SELECT HLL('2021-06-15')
-- sample return

HLL example

SELECT HLL(2021)
-- sample return

HLL example

SELECT HLL(45.7)
-- sample return

HLL example

SELECT HLL(2021)
-- sample return 1

HLL example

SELECT HLL('spice')
-- sample return 1

HLL example

SELECT HLL('2021-06-17 11:50:59')
-- sample return 1