forked from DTStack/chunjun
-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Labels
bugSomething isn't workingSomething isn't working
Description
setting of col time_c TIME(0) is unsupported tempory
CREATE TABLE full_types (
id INTEGER NOT NULL,
bytea_c BYTEA,
small_c SMALLINT,
int_c INTEGER,
big_c BIGINT,
real_c REAL,
double_precision DOUBLE PRECISION,
numeric_c NUMERIC(10, 5),
decimal_c DECIMAL(10, 1),
boolean_c BOOLEAN,
text_c TEXT,
char_c CHAR,
character_c CHARACTER(3),
character_varying_c CHARACTER VARYING(20),
timestamp3_c TIMESTAMP(3),
timestamp6_c TIMESTAMP(6),
date_c DATE,
time_c TIME(0),
default_numeric_c NUMERIC,
PRIMARY KEY (id)
);
ALTER TABLE full_types REPLICA IDENTITY FULL;
INSERT INTO full_types VALUES (
1, '2', 32767, 65535, 2147483647, 5.5, 6.6, 123.12345, 404.4443, true,
'Hello World', 'a', 'abc', 'abcd..xyz', '2020-07-17 18:00:22.123', '2020-07-17 18:00:22.123456',
'2020-07-17', '18:00:22', 500);JdbcOutputFormat [postgre_mysql] writeRecord error: when converting field[0] in Row(+I(1,[50],32767,65535,2147483647,5.5,6.6,123.123450000000000000,404.400000000000000000,true,Hello World,a,abc,abcd..xyz,2020-07-17T18:00:22.123,2020-07-17T18:00:22.123456,18460,36022000,500.000000000000000000))
java.lang.IllegalStateException: index:17 val:36022000
at com.dtstack.chunjun.connector.jdbc.sink.JdbcOutputFormat.processWriteException(JdbcOutputFormat.java:353)
at com.dtstack.chunjun.connector.jdbc.sink.JdbcOutputFormat.writeSingleRecordInternal(JdbcOutputFormat.java:192)
at com.dtstack.chunjun.sink.format.BaseRichOutputFormat.writeSingleRecord(BaseRichOutputFormat.java:472)
at com.dtstack.chunjun.sink.format.BaseRichOutputFormat.lambda$writeRecordInternal$1(BaseRichOutputFormat.java:493)
at java.util.ArrayList.forEach(ArrayList.java:1257)
at com.dtstack.chunjun.sink.format.BaseRichOutputFormat.writeRecordInternal(BaseRichOutputFormat.java:493)
at com.dtstack.chunjun.sink.format.BaseRichOutputFormat.lambda$initTimingSubmitTask$0(BaseRichOutputFormat.java:449)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: index:17 val:36022000
at com.dtstack.chunjun.connector.jdbc.converter.JdbcColumnConverter.toExternal(JdbcColumnConverter.java:141)
at com.dtstack.chunjun.connector.jdbc.converter.JdbcColumnConverter.toExternal(JdbcColumnConverter.java:58)
at com.dtstack.chunjun.connector.jdbc.sink.PreparedStmtProxy.writeSingleRecordInternal(PreparedStmtProxy.java:222)
at com.dtstack.chunjun.connector.jdbc.sink.JdbcOutputFormat.writeSingleRecordInternal(JdbcOutputFormat.java:189)
... 12 more
Caused by: java.lang.UnsupportedOperationException: index:17,val:+I(1,[50],32767,65535,2147483647,5.5,6.6,123.123450000000000000,404.400000000000000000,true,Hello World,a,abc,abcd..xyz,2020-07-17T18:00:22.123,2020-07-17T18:00:22.123456,18460,36022000,500.000000000000000000)
at com.dtstack.chunjun.connector.jdbc.converter.JdbcColumnConverter.lambda$createExternalConverter$a54efc5$11(JdbcColumnConverter.java:283)
at com.dtstack.chunjun.connector.jdbc.converter.JdbcColumnConverter.lambda$wrapIntoNullableExternalConverter$f2b99adf$1(JdbcColumnConverter.java:87)
at com.dtstack.chunjun.connector.jdbc.converter.JdbcColumnConverter.toExternal(JdbcColumnConverter.java:138)
... 15 moreMetadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working