Toolkit hyperloglog error : deserialization error invalid collation "pg_catalog"."en_US.UTF-8"

[hardikm10]

Relevant system information:
timescaledb : 2.6.0
timescaledb_toolkit : 1.6.0
PostgreSQL 14.2
Platform : MST

Describe the bug
when hyperloglog is used on a varchar type column ,the error comes as :

sqlalchemy.exc.InternalError: (psycopg2.errors.InternalError_) deserialization error invalid collation "pg_catalog"."en_US.UTF-8"
CONTEXT: extension/src/[hyperloglog.rs](https://hyperloglog.rs/):126:31

To Reproduce

drop table sensor_data;

create table sensor_data( 
time timestamptz not null, 
sensor_id integer not null, 
cpu double precision null,
temperature double precision null,
operation_tag varchar(64) not null );

select from create_hypertable('sensor_data','time');

INSERT INTO sensor_data
SELECT
time + (INTERVAL '1 minute' * random()) AS time,
sensor_id,
random() AS cpu,
random()* 100 AS temperature,
concat('Operation ', sensor_id)
FROM
generate_series(now() - INTERVAL '1 months', now() - INTERVAL '1 week', INTERVAL '10 minute') AS g1(time),
generate_series(1, 100, 1 ) AS g2(sensor_id)
ORDER BY
time;


SELECT distinct_count(hyperloglog(64,operation_tag)) FROM sensor_data;
-- ERROR:  deserialization error invalid collation "pg_catalog"."en_US.UTF-8"
-- CONTEXT:  extension/src/hyperloglog.rs:126:31

Collation debug info :

Expected behavior
It should not error out, and the query should run just fine.

Actual behavior
Like mentioned, error is causing query to fail.

[jerryxwu]

@hardikm10 If you haven't noticed, we've just included the fix for this issue in the latest 1.8.0 release. We'd love to hear from our customers and users about whether it's working for them.