[
https://issues.apache.org/jira/browse/BEAM-12837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17483569#comment-17483569
]
Ranjan Dahal commented on BEAM-12837:
-------------------------------------
Apologies for delay here. Basically the error message is this line:
[https://github.com/apache/beam/blob/master/sdks/java/io/jdbc/src/main/java/org/apache/beam/sdk/io/jdbc/SchemaUtil.java#L176]
The JdbcType that are used in the switch statement doesn't support Sql Sever
specific types.
> JdbcIO Microsoft Sql Types are not supported
> --------------------------------------------
>
> Key: BEAM-12837
> URL: https://issues.apache.org/jira/browse/BEAM-12837
> Project: Beam
> Issue Type: Bug
> Components: io-java-jdbc
> Affects Versions: 2.32.0
> Environment: Production
> Reporter: Ranjan Dahal
> Priority: P3
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> While working with JdbcIO Sql Server data store, I encountered an issue where
> a data type DATETIMEOFFSET was not supported when reading data as Beam Row.
> The Beam field converter only looks for JdbcType and ignores the
> microsoft.sql.Types which makes is impossible for genuine data type to be
> processed. The list of non supported types are as follows:
> - microsoft.sql.Types.SMALLDATETIME // -150 represents TSQL smalldatetime
> type
> - microsoft.sql.Types.DATETIME // -151 represents TSQL datetime type
> - microsoft.sql.Types.DATETIMEOFFSET // -155 represents TSQL Datetimeoffset
> type
>
> All above types should be treated as if they are TIMESTAMP.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
