Update and Delete is failing at branch level in dremio

1

Hi,

I encountered failure with dremio during update and delete at nessie branch. I am using docker containers to run.

Error:
Cannot assign to target field ‘D_R_E_M_I_O_D_A_T_A_F_I_L_E_F_I_L_E_P_A_T_H’ of type VARCHAR(65536) from source field ‘D_R_E_M_I_O_D_A_T_A_F_I_L_E_F_I_L_E_P_A_T_H’ of type VARCHAR(65536) NOT NULL

Kindly assist, what could be the reason?

Thanks
Zaid

2

Hi,

We are using dremio version 25.0.0. Any clue which version is going to have fix for this and when is it going to be released?

3

I got a way to manage this by using below.

USE BRANCH BRANCH_NAME IN CATALOG;
UPDATE TABLE SET COL = VALUE WHERE COL = “abc”;

Thanks

4

Thanks for updating the thread with what action you took @zaidhasan88