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

Posted to github@beam.apache.org by GitBox <gi...@apache.org> on 2022/06/04 21:01:43 UTC

[GitHub] [beam] damccorm opened a new issue, #21062: JdbcIO Microsoft Sql Types are not supported

damccorm opened a new issue, #21062:
URL: https://github.com/apache/beam/issues/21062

   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. 
   
   Imported from Jira [BEAM-12837](https://issues.apache.org/jira/browse/BEAM-12837). Original Jira may contain additional context.
   Reported by: rdahal.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org