groupUniqArray() result true or false

[jack-reso]

Describe the bug

Steps to reproduce

1.i use groupUniqArray(toHour(gettime)) to find out unique hour in gettime ,but in metabase it result [false,false]. However when i use dbeaver,it't show [12,14] ,which mean gettime's unique hour is 12 and 14.

Expected behaviour

true result show in dbeaver [12,14] error result show in metabase [false,false].

Error log

Configuration

Environment

• metabase-clickhouse-driver version:1.2.1
• metabase-clickhouse-driver configuration:
• Metabase version:0.47.4
• OS:docker

ClickHouse server

• ClickHouse Server version:22.9.5.25

[slvrtrn]

Thanks for the report.

i use groupUniqArray(toHour(gettime)) to find out unique hour in gettime ,but in metabase it result [false,false]. However when i use dbeaver,it't show [12,14] ,which mean gettime's unique hour is 12 and 14.

To simplify the debugging and test writing, I'd like to ask for a bit more details here.

• Do you run this from the query editor?
• What does the entire query look like?
• Do you have a minimal dataset to share, or at least the table definition/column types?

[jack-reso]

colume: gettime uid type: Datetime64 String data 2023-10-10 01:01:01 12edada 2023-10-10 03:01:01 12edada 2023-10-10 06:01:01 12edada

sql: select groupUniqArray(gettime) as hour_a, uid from table group by uid

result in dbeaver: [1,3,4],12edada result in metabase: [false,false,false],12edada

[jack-reso]

i run this from the sql query editor?

[slvrtrn]

@jack-reso, fixed in 1.3.1

[jack-reso]

@slvrtrn thanks！