GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
MySql - Spanner Comp-Field Validation failing for FLOAT datatype
- 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 :
Contributor guide
Assessment
This issue has not been assessed yet.