citusdata / citusdata/postgresql-hll

Aggregate function not parallelizable ?

Open
#120 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.2k
Forks
115
PR merge metrics
No merged PRs in 30d

Description

Hello, I'm trying to use timescaledb continuous aggregation with HLL on my database in postgresql 12.7:
```
\dxe

Nom | Version | Schéma | Description
-------------+---------+------------+-------------------------------------------------------------------
hll | 2.15 | public | type for storing hyperloglog data
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
timescaledb | 2.3.0 | public | Enables scalable inserts and complex queries for time-series data
```

```sql
CREATE MATERIALIZED VIEW sentdata_summary_daily
WITH (timescaledb.continuous) AS
SELECT network,
time_bucket(INTERVAL '1 day', date) AS bucket,
HLL_ADD_AGG(HLL_HASH_BIGINT(userid)) as users_set
FROM dataselectvol
GROUP BY network,bucket;
ERROR: aggregates which are not parallelizable are not supported
```

But I thought from #73 that HLL functions were parallelisable.

Can you confirm that #73 is fixed in version 2.15 ? Do you think that the issue might be related to TimescaleDB ? Or am I misusing the hll_* functions ?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.