running-elephant / datart

Datart is a next generation Data Visualization Open Platform
https://running-elephant.github.io/datart-docs/
Apache License 2.0
1.99k stars 591 forks source link

clickhouse 数据源,视图中使用groupArray函数报错 #2084

Open CharlesTHN opened 1 year ago

CharlesTHN commented 1 year ago

Datart版本号 datart-server-1.0.0-rc.1

错误描述 clickhouse 数据源,使用groupArray函数报错

如何重现

  1. 到数据视图页面
  2. sql: SELECT max(id),groupArray(detail) FROM sample_audit_flow_info GROUP BY apply_code

期望结果 分组聚合,groupArray得到数组

截图 image

运行环境详情:(可选,取决于错误发生的具体位置)

zangjietutu commented 1 year ago

有结果了吗?

lichong-a commented 1 year ago

+1

nianhua99 commented 1 year ago

我这边测试可以用,是不是你们的clickhouse驱动版本有问题,或者druid版本,下面是我的

<dependency>
    <groupId>ru.yandex.clickhouse</groupId>
    <artifactId>clickhouse-jdbc</artifactId>
    <version>0.3.2</version>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.4</version>
</dependency>
lichong-a commented 1 year ago

但是ru.yandex.clickhouse已经被废弃了,新的com.clickhouse驱动貌似很多函数都执行不了