Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Row validation for DB2 to Bigquery not supported #692

Closed
Raniksingh opened this issue Feb 1, 2023 · 1 comment
Closed

Row validation for DB2 to Bigquery not supported #692

Raniksingh opened this issue Feb 1, 2023 · 1 comment
Assignees
Labels
priority: p1 High priority. Fix may be included in the next release.

Comments

@Raniksingh
Copy link
Contributor

Command:
data-validation -v validate row
-sc DB2_CONN
-tc BQ_CONN
-tbls POCDB2.customer=rite-aid-371612.bq_dvt.customer_db2_df
--primary-keys custid
--concat custname,age,phonenum,birthdate,order_amount,load_ts
--bq-result-handler rite-aid-371612.data_validator.results

Error :
sqlalchemy.exc.ProgrammingError: (ibm_db_dbi.ProgrammingError) ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0461N A value with data type "SYSIBM.INTEGER" cannot be CAST to type "SYSIBM.CLOB". SQLSTATE=42846 SQLCODE=-461

Query Generated: Instead of casting to string or varchar its being cast to CLOB
SELECT CAST(t5.age AS CLOB) AS cast__age, CAST(t5.birthdate AS CLOB) AS cast__birthdate, CAST(t5.order_amount AS CLOB) AS cast__order_amount, CAST(t5.load_ts AS CLOB) AS cast__load_ts
FROM test.table AS t5

@Raniksingh Raniksingh changed the title Row validation for DB2 to Bigquery fails Row validation for DB2 to Bigquery not supported Feb 9, 2023
@kanhaPrayas kanhaPrayas self-assigned this Feb 9, 2023
@Raniksingh Raniksingh added the priority: p1 High priority. Fix may be included in the next release. label Feb 9, 2023
@Raniksingh
Copy link
Contributor Author

Fix provided in PR #800

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
priority: p1 High priority. Fix may be included in the next release.
Projects
None yet
Development

When branches are created from issues, their pull requests are automatically linked.

2 participants