We have an Phoenix table in which records are inserted by Nifi workflow. Our table and primary key looks something like below:
PRIMARY KEY | COL1 | COL2 | COL3 | COL4 | COL5 |
COL1 | COL2 | COL3 |
We faced some issues in Nifi and |COL2|COL3 was inserted as primary keys for all rows without COL1 value. Now our primary key looks like this -> ( |COL2 | COL3) . Is there any upsert statement to update existing primary key with COL1 value so that out primary key become like this --> COL1|COL2|COL3 ? @Sergey Soldatov @Josh Elser