GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

MySql - Spanner Comp-Field Validation failing for FLOAT datatype

Open
#719 4 comments 0 reactions 1 assignee Claimed by @piyushsarraf View on GitHub
Dominant language
Python
Stars
524
Forks
171
Avg merge
5d 15h
Merged PRs (30d)
4

Description

Comp field comparison between SQL server and Big query for FLOAT datatype (column name : adjusted) failing.

Source data (SQL Server)

sr_no adjusted
----------- ------------------------
2217126 7.3018260000000001
2622064 4.8977870000000001
3339058 43.23809
3960098 60.973129999999998
4585861 8.3525019999999994
10158240 2.598392

Target data (Bigquery)

sr_no | adjusted |  
2217126 | 7.301826 |  
2622064 | 4.897787 |  
3339058 | 43.23809 |  
3960098 | 60.97313 |  
4585861 | 8.352502 |  
10158240 | 2.598392

Command used :

data-validation validate row \
-sc MSSQL_CONN \
-tc BQ_CONN \
-tbls tempdb.dbo.dvt_prices=paras-sandbox-364713.dlp.dvt_prices \
--primary-keys sr_no \
-comp-fields symbol,adjusted \
-rr \
-rbs 5 \
--bq-result-handler paras-sandbox-364713.data_validator.results

Output :

Screenshot 2023-02-11 at 12 33 52 AM

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.