column 17 这列字段时 CHECK_TIME,字段类型是TIMESTAMP,其他表里这个字段值是NULL,部分表这个字段值是异常信息,情况比较奇怪。

















在 2022-01-18 10:51:49,"ling miao" <lingm...@apache.org> 写道:
>首先你需要确认一下,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