topic Re: MySQL to Snowflake: NULL result in a non-nullable column in Talend Studio

MySQL to Snowflake: NULL result in a non-nullable column

Chitrangad — Sat, 16 Nov 2024 00:34:57 GMT

Hello,

I'm running into a peculiar issue.

I have a simple job that reads from MySQL and loads into Snowflake via Bulkexec with a tMap in between. I have auto-type conversion enabled.

All the fields in both source and target are not-nullable and data also doesn't have any nulls.

However, I keep getting this error message when trying to run. Oddly enough, it comes for the 1st field which is a primary key. I tried null handling but no luck.

"NULL result in a non-nullable column"

Appreciate if someone can help with the issue?

Re: MySQL to Snowflake: NULL result in a non-nullable column

Anonymous — Thu, 18 Feb 2021 03:11:28 GMT

How do you handle null value?

For debugging, try to use tLogRow to print the value on the console or use tFilterRow to filter the null value to check there exist null value.

Regards

Shong

Re: MySQL to Snowflake: NULL result in a non-nullable column

Chitrangad — Thu, 18 Feb 2021 13:56:10 GMT

Hi,

I'm using row1.column==null?"":row1.column

Checked the data visually (12 recs) as well as by adding a reject file. There are no nulls.

Re: MySQL to Snowflake: NULL result in a non-nullable column

Anonymous — Fri, 19 Feb 2021 03:22:56 GMT

Take a look at this topic and check if you have similar cause.

https://community.talend.com/s/question/0D53p00007vCp6xCAC/null-result-in-a-nonnullable-column-error-while-inserting-data-from-one-snowflake-table-to-other-snowflake-table-using-talend-data-integration

Re: MySQL to Snowflake: NULL result in a non-nullable column

CFlores1613722497 — Fri, 19 Feb 2021 12:51:02 GMT

Check the Default value status for column (PK) in table structure.

Sequence in the table(PK default value) will be in invalid state if sequence is dropped and recreated/replaced with same name after creating table. drop and recreate the table again. Check the sequence status and load the data. shareit vidmate