Skip to content

Latest commit

 

History

History
126 lines (84 loc) · 3.62 KB

hll.md

File metadata and controls

126 lines (84 loc) · 3.62 KB
description
Uses HyperLogLog to return an approximation of the distinct cardinality of the input.

HLL

Syntax

HLL(expression boolean) → varbinary

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

Examples

SELECT HLL(TRUE)
-- sample return

HLL(expression float) → varbinary

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

Examples

{% code title="HLL example" %}

SELECT HLL(67.90)
-- sample return

{% endcode %}

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

{% code title="HLL example" %}

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

{% endcode %}

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

{% code title="HLL example" %}

SELECT HLL(2021)
-- sample return

{% endcode %}

HLL(expression double) → varbinary

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

Examples

{% code title="HLL example" %}

SELECT HLL(45.7)
-- sample return

{% endcode %}

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

{% code title="HLL example" %}

SELECT HLL(2021)
-- sample return 1

{% endcode %}

HLL(expression varchar) → varbinary

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

Examples

{% code title="HLL example" %}

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

{% endcode %}

HLL(expression timestamp) → varbinary

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

Examples

{% code title="HLL example" %}

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

{% endcode %}