SQL Server datetime and datetime2 are not supported well in assessment for replication

Description

When doing the assessment, datetime and datetime2 will be converted to CDAP data type TimeStamp instead of dateTime and datetime2 will be complained as partial support. The problem is with this code, both datetime and datetime2 will reach to this branch.

Note that datetime and datetime2 are actually mapped to CDAP type DATETIME (code) during pipeline execution.

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.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Affects versions

Triaged

No

Components

Fix versions

Priority

Created July 6, 2022 at 6:35 AM
Updated April 4, 2023 at 8:24 AM
Resolved December 5, 2022 at 2:38 AM