设置时区+08:00后,查询 information_schema.`partitions` 报错invalid format: Fixed/UTC+08:00:00

Viewed 23

doris设置时区后查询报错 information_schema.partitions
java.sql.SQLException: errCode = 2, detailMessage = (ip)[INTERNAL_ERROR]TStatus: Invalid ID for region-based ZoneId, invalid format: Fixed/UTC+08:00:00

doris 版本: doris version doris-4.0.1-rc02-791725594d

按照这个文档部署的 https://doris.apache.org/zh-CN/docs/3.x/gettingStarted/quick-start#%E7%AC%AC-1-%E6%AD%A5%E4%B8%8B%E8%BD%BD%E4%BA%8C%E8%BF%9B%E5%88%B6%E5%8C%85

执行步骤:

  1. 先设置时区 SET TIME_ZONE='+08:00';
  2. 执行 SELECT * FROM information_schema.partitions LIMIT 1 报错 invalid format: Fixed/UTC+08:00:00

image.png

SET time_zone = 'Asia/Shanghai',不使用+08:00就是正常的
求大佬帮忙看下什么原因🙏

0 Answers