[Bug] Vertica Connector Incorrectly Converts Numeric(n), Varchar(n) Data Types

growthbook / growthbook

Open Source Feature Flagging and A/B Testing Platform

https://www.growthbook.io

Other

6.14k stars 500 forks source link

[Bug] Vertica Connector Incorrectly Converts Numeric(n), Varchar(n) Data Types #3093

Open alarinskii opened 3 weeks ago

alarinskii commented 3 weeks ago

Summary

We are using the Vertica connector in GrowthBook to integrate our data sources. Our tables include the numeric(n) and varchar(n) data type, but the Vertica connector is converting it incorrectly, leading to errors.

Expected Behavior

When adding a new datasource we do expect GrowthBook to work with numeric(n), varchar(n) fields without additional casting.

Current Behavior

We have cast all our data:

cast(user_id as bigint) as user_id,
cast(test_id as varchar) as experiment_id

lukesonnet commented 3 days ago

Can you paste an example of the error you're seeing? What types are the fields you are having to cast?

A little more information would do a lot to help me understand what your desired behavior is, seeing as we should definitely support varchar in vertica.