GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Fixed length character columns as primary keys not handled correctly in SQL Server, Hive, Impala and RedShift

Open
#1,470 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
524
Forks
171
Avg merge
5d 15h
Merged PRs (30d)
4

Description

**Describe the bug**
Fixed length character columns as part of primary keys are not handled correctly in Hive, Impala and Redshift

**Why is this bug happening**
DVT correctly handles fixed length character columns in many database as stated in [PR 1472](https://github.com/GoogleCloudPlatform/professional-services-data-validator/issues/1472).

The methods `raw_column_metadata` and `is_char_type_padded` are not yet implemented for Microsoft SQL Server, Hive, Impala and Redshift, therefore fixed length character columns that are primary keys are not trimmed.

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.