Source MSSQL: converter decimal and money datatype

[duytp]

Environment

• Airbyte version: example is 0.40.0-alpha
• OS Version / Instance: Ubuntu 20.04
• Deployment: Docker
• Source Connector and version: airbyte/source-mssql:0.4.16
• Destination Connector and version: airbyte/destination-s3:0.3.13
• Step where error happened: Sync from scratch (using CDC, SNAPSHOT)

Current Behavior

Replication from MSSQL to S3 from scratch.

Caused by: org.apache.avro.AvroTypeException: Could not evaluate union, field xxx is expected to be one of these: NULL, DOUBLE. If this is a complex type, check if offending field (path: TotalAmount) adheres to schema: 0.00

Expected Behavior

Cannot init the parquet file in S3

Logs

logs-32795.txt

Steps to Reproduce

1. Source: MSSQL
2. Destination: S3 (parquet files)
3. CDC & Snapshot

Are you willing to submit a PR?

Refer by this pull request: #14449
@gsmith-schlesinger also mentions this before

[xiaohansong]

looks like we have supported this already. From my logs:

2023-12-20 22:11:02 destination > INFO i.a.i.d.e.l.FirstNLogger(log):27 [2023-12-20T22:10:57.803Z] Types #0001: {"id":"1","money":20.07}
2023-12-20 22:11:02 destination > INFO i.a.i.d.e.l.FirstNLogger(log):27 [2023-12-20T22:10:57.803Z] Types #0002: {"id":"1","geometry":"LINESTRING(100 100, 20 180, 180 180)"}
2023-12-20 22:11:02 destination > INFO i.a.i.d.e.l.FirstNLogger(log):27 [2023-12-20T22:10:57.803Z] Types #0003: {"id":"2","geography":"LINESTRING(-122.36 47.656, -122.343 47.656)"}