首先你需要确认一下,column 17 这个列的类型是什么?以及 value 'e792-02-22 13:30:02' 是否是你表里面的数据。

Ling Miao

温天柱 <wtz4...@163.com> 于2022年1月18日周二 10:37写道:

> 各位老师们好:
> 我通过jdbc的方式去查询Doris中存储的表信息时,有部分表返回类似如下报错:
>
>
> jdbc :
> Caused by: java.sql.SQLException: Cannot convert value 'e767-06-09
> 18:23:19' from column 17 to TIMESTAMP.
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
> at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1170)
> at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:130)
> at
> com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5921)
> at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5591)
> at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4552)
> at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4698)
> at
> com.dtstack.flinkx.metadatadoris.collector.JdbcCollector.toJavaBean(JdbcCollector.java:159)
> ... 11 more
> Caused by: java.lang.NumberFormatException: e767-06-09 18:23:19
> at com.mysql.jdbc.StringUtils.getInt(StringUtils.java:758)
> at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1008)
> ... 17 more
>
>
>
>
> 这种报错只存在部分表中,但是这些表没有任何异常,只是在information.tables查询出来的结果中CHECK_TIME字段存在报错:
> <failed to load>
> java.sql.SQLException: Cannot convert value 'e792-02-22 13:30:02' from
> column 17 to TIMESTAMP.
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
> at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1181)
> at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:559)
> at
> com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5921)
> at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5589)
> at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4550)
> in JdbcHelperImpl.getObject(JdbcHelperImpl.java:321)
> Caused by: java.lang.NumberFormatException:
> �xiaohe_dbxiao_ftp_dest_3_rep_10g
> BASE TABLEDoris���������2021-10-27 17:14:39�e792-02-22 13:30:02���OLAP
> at com.mysql.jdbc.StringUtils.getInt(StringUtils.java:758)
> at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1018)
> ... 25 more
>
>
> 请问这种报错应该如何处理呢?如果是Doris bug,我想尝试修复下
>
>

Reply via email to