Ranjan Dahal created BEAM-12837:
-----------------------------------
Summary: 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: beam-community
Affects Versions: 2.32.0
Environment: Production
Reporter: Ranjan Dahal
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.3.4#803005)
