SQL Server datetime and datetime2 are not supported well in assessment for replication
Description
Release Notes
Fix issue in replication assessment, where columns of type DATETIME and DATETIME2 in SQL server were shown as being mapped to TIMESTAMP type in BigQuery, which was wrong as replication pipeline actually maps them to DATETIME type.
Attachments
1
- 06 Jul 2022, 06:36 AM
Activity
Show:
Sumit Jain December 1, 2022 at 9:17 AM
Created https://cdap.atlassian.net/browse/CDAP-20169 for similar problem in Mysql/Oracle assessment.
Sumit Jain November 24, 2022 at 10:32 AM
Fixed
Pinned fields
Click on the next to a field label to start pinning.
Created July 6, 2022 at 6:35 AM
Updated April 4, 2023 at 8:24 AM
Resolved December 5, 2022 at 2:38 AM
When doing the assessment,
datetime
anddatetime2
will be converted to CDAP data typeTimeStamp
instead ofdateTime
anddatetime2
will be complained as partial support. The problem is with this code, bothdatetime
anddatetime2
will reach to this branch.Note that
datetime
anddatetime2
are actually mapped to CDAP typeDATETIME
(code) during pipeline execution.