Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-12837

JdbcIO Microsoft Sql Types are not supported

Details

    • Bug
    • Status: Open
    • P3
    • Resolution: Unresolved
    • 2.32.0
    • None
    • io-java-jdbc
    • None
    • Production
    • Important

    Description

      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. 

      Attachments

        Activity

          People

            Unassigned Unassigned
            rdahal Ranjan Dahal
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 1h
                1h
                Remaining:
                Remaining Estimate - 1h
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified