[
https://issues.apache.org/jira/browse/FLINK-13283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16991166#comment-16991166
]
Jingsong Lee commented on FLINK-13283:
--------------------------------------
Fixed in https://issues.apache.org/jira/browse/FLINK-14645
> JDBC source/sink should respect the conversion class of DataType
> ----------------------------------------------------------------
>
> Key: FLINK-13283
> URL: https://issues.apache.org/jira/browse/FLINK-13283
> Project: Flink
> Issue Type: Sub-task
> Components: Connectors / JDBC
> Affects Versions: 1.9.0
> Reporter: LakeShen
> Assignee: Caizhi Weng
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.10.0
>
>
> Hi , when I use Flink 1.9 JDBCTableSource,and I create TableSchema like
> this:
> final TableSchema schema = TableSchema.builder()
> .field("id", DataTypes.INT())
> .field("create", DataTypes.DATE())
> .field("update", DataTypes.DATE())
> .field("name", DataTypes.STRING())
> .field("age", DataTypes.INT())
> .field("address", DataTypes.STRING())
> .field("birthday",DataTypes.DATE())
> .field("likethings", DataTypes.STRING())
> .build();
> I use JDBCTableSource.builder() to create JDBCTableSource, I run the
> program, and there is a exception :
> {color:red}java.lang.IllegalArgumentException: Unsupported type:
> LocalDate{color}
> I saw the src code , I find that in LegacyTypeInfoDataTypeConverter ,
> DateType convert to Types.LOCAL_DATE,but in JDBCTypeUtil class, the HashMap
> TYPE_MAPPING doesn't have the key Types.LOCAL_DATE,so that throw the
> exception.
> Does the JDBC dim table support the time data,Like Date? May it is bug for
> JDBCTableSource join.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
