ClickHouse JDBC：datetime类型无法解析 #26049
-
|
【系统环境】 【复现步骤】 CREATE CATALOG jdbc_clickhouse PROPERTIES (
"type"="jdbc",
"user"="xx",
"password"="xx",
"jdbc_url" = "jdbc:clickhouse://127.0.0.1:8123/dev_lake",
"driver_url" = "clickhouse-jdbc-0.4.2.jar",
"driver_class" = "com.clickhouse.jdbc.ClickHouseDriver"
);2、切换catalog，查询外表中数据 select count(*) from defect_changelogs;引发如下异常： 3、Clickhouse 中defect_changelogs表结构如下： CREATE TABLE defect_changlogs
(
`issue_id` UInt64 COMMENT 'issue_id',
`created_at` DateTime('Asia/Shanghai') COMMENT '记录创建时间',
-- 省略其他字段
)
ENGINE = ReplacingMergeTree()4、改造defect_changelogs，去掉DateTime类型的字段，重新创建catalog，可以顺利执行select count(*) 【结论】 PS: clickhouse-jdbc-0.4.2.jar 换成较新的 clickhouse-jdbc-0.4.6.jar 也是一样的错误 |
Beta Was this translation helpful? Give feedback.
Answered by
liugddx
Oct 29, 2023
Replies: 1 comment
-
|
I will deal with this problem |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
rulerhuang
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I will deal with this problem