search

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

数值类型过滤bug #1657

Open lbship opened 2 years ago

lbship commented 2 years ago

Datart Version beta.4

Describe the bug beta.3版本正常，beta.4才有

To Reproduce Steps to reproduce the behavior: 1.拖入数值类型到筛选，聚合方式选择总计，筛选方式选择不为空， image 会发现报错 image

检查SQL发现多生成了一个.DATART_VTABLE才导致的 image

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Environmental details: (optional, depending on where the bug occurs)

Additional context Add any other context about the problem here.

Cuiyansong commented 2 years ago

目前RC.0版本不能复现，如有问题请留言。

Cuiyansong commented 2 years ago

SqlSever？Doris？

handsomepjf commented 2 years ago

SqlSever？Doris？

Mysql数据源试了也不行

caojinlong-827 commented 2 years ago

SqlSever？Doris？

SqlServer测试可以连接，但是读取数据报错

image

caojinlong-827 commented 2 years ago

SqlSever？Doris？

sql语法的问题。原因是后台传入前端的sql中，有一个名为DATART_VTABLE的字段。

SQL 字段/列名引号，MySQL使用的是飘号，impala使用的是单引号，postgresql使用的是双引号。

在conf/jdbc-driver-ext.yml中添加修改这两个配置：identifier-quote，identifier-end-quote。切记一定要一样。否则还会报错