professional-services-data-validator: Custom-Query failure for boolean datatype columns
Hi Team,
I have a failure using the DVT tool for random row validation using custom - query method. I have generated the configuration file using below command where the column is_top_placement is boolean datatype.
data-validation validate custom-query row \
--source-query-file sq_rm.sql \
--target-query-file tq_rm.sql \
-sc rs \
-tc bq \
--hash '*' \
--primary-keys _rest_hash_key,visit_dt,is_top_placement,outcode,app_type \
-rbs 100 \
-c cq_rm.yaml
when I trigger the command to run the validation of the above generated YAML file , I run into issues as shown below.
data-validation configs run -c ./cq_rm.yaml
Error: My validation runs fine when I exclude the boolean datatype column from the configuration file.
07/17/2023 02:38:35 PM-INFO: Currently running the validation for yml file: ./cq_rm.yaml
07/17/2023 02:44:03 PM-ERROR: Error (psycopg2.errors.CannotCoerce) cannot cast type boolean to character varying
Please do let me know if more details are required to debug further.
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 21 (4 by maintainers)
why are we sharing email id over github? Can’t this be an issue of GDPR?