首先你需要确认一下,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,我想尝试修复下 > >