You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Ranjan Dahal (Jira)" <ji...@apache.org> on 2021/09/02 20:41:00 UTC

[jira] [Created] (BEAM-12837) JdbcIO Microsoft Sql Types are not supported

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)