[jira] [Assigned] (CALCITE-6956) Support HyperLogLog for redis adapter

["Chuxin Chen (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-6956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chuxin Chen reassigned CALCITE-6956:
------------------------------------

    Assignee: Chuxin Chen

> Support HyperLogLog for redis adapter
> -------------------------------------
>
>                 Key: CALCITE-6956
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6956
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Chuxin Chen
>            Assignee: Chuxin Chen
>            Priority: Major
>
> Hello, I want to support HyperLogLog for redis adapter.
> HyperLogLog is a data type in Redis designed for efficient cardinality estimation. After adding multiple elements to a key using `PFADD`, you can calculate the cardinality using `PFCOUNT`.  
> I plan to implement it as follows:  
> ```json
> {
>   "name": "uv_stats",
>   "factory": "org.apache.calcite.adapter.redis.RedisTableFactory",
>   "operand": {
>     "dataFormat": "hyperloglog",
>     "keyPattern": "uv:*",
>     "fields": [
>       {
>         "name": "key",
>         "type": "varchar"
>       },
>       {
>         "name": "CARDINAL_NUMBER",
>         "type": "long"
>       }
>     ]
>   }
> }
> ```
> This configuration will:  
> 1. Use wildcard matching (`uv:*`) to scan all HyperLogLog keys  
> 2. Calculate the cardinality of each key via `PFCOUNT`  
> 3. Display results in the format:  
> ```
> | -- key --|--CARDINAL_NUMBER--|
> | uv:20250411 | 4 |
> | uv:20250410 | 3 |
> ```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)