[jira] [Resolved] (FLINK-13283) JDBC source/sink should respect the conversion class of DataType

["Jingsong Lee (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-13283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jingsong Lee resolved FLINK-13283.
----------------------------------
    Resolution: Fixed

> 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)