Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]Doris数据源时间字段,时间组件与图表中的时间相差了八小时 #8539

Open
luyang351 opened this issue Mar 15, 2024 · 2 comments
Assignees
Labels
类型:bug Something isn't working
Milestone

Comments

@luyang351
Copy link
Contributor

luyang351 commented Mar 15, 2024

DataEase 版本
v2.4

运行方式(安装包运行 or 源码运行 ?)
安装包运行

浏览器版本
Chrome 标准版

Bug 描述
Doris数据源时间字段,时间组件与图表中的时间相差了八小时

Bug 重现步骤(有截图更好)
1.使用 Doris 数据源创建数据集,其中有时间字段 insert_time。
image

2.使用该数据集在仪表板上创建一个图表,并为该图表添加筛选条件。
image

3.使用筛选组件查询,查询时间为:2024-02-02 02:53:36,但是查询出来的图表的维度时间为:2024-02-02 10:53:36,正好相差了 8 小时。而使用正确的时间无法查询出结果。
https://github.com/dataease/dataease/assets/48945409/7044bb86-5a3a-4762-a477-a7bc8b764e01

相关问题:https://bbs.fit2cloud.com/t/topic/3801

@ChangeMaker2018
Copy link

ChangeMaker2018 commented Mar 17, 2024

时间戳转换也是,差了8小时。

97a7fc84c2256015153c138f8fa4b81

数据库及服务器的时区,都是正确的
image

image

老哥,你应该进容器里面看时区吧;<===咦,怎么做到编辑我的帖子的呀?答复:是进的容器里面看的,数据库时区就是按系统,而系统时区就是Asia/shanghai

@BBchicken-9527
Copy link

感谢反馈,我们会在后续版本进行修复;

@BBchicken-9527 BBchicken-9527 added 类型:bug Something isn't working and removed 状态:待处理 labels Mar 18, 2024
@BBchicken-9527 BBchicken-9527 added this to the v2.x milestone Mar 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
类型:bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants