citusdata / citusdata/postgresql-hll

"could not identify an equality operator for type hll" in GROUP BY

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

Description

When I use a column with `hll` type as a field in `GROUP BY` clause, I get the error:
```
ERROR: could not identify an equality operator for type hll
```

Here's a small repro:
```
CREATE TABLE tmp (int num, set hll);
INSERT INTO tmp VALUES (1, hll_empty());
INSERT INTO tmp VALUES (2, hll_empty());
INSERT INTO tmp VALUES (3, hll_empty());
INSERT INTO tmp VALUES (4, hll_empty());
SELECT SUM(num), set FROM tmp GROUP BY set;
```
While I expect it to result in a row consisting of 10 and empty `hll` value, I get the error above.

**postgresql-hll Version**: master (77aa0fe)
**PostgreSQL Version:** 11.5
**OS Version:** Debian 10

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.