Support Questions

Find answers, ask questions, and share your expertise

Phoenix Upsert command for Primary key

We have an Phoenix table in which records are inserted by Nifi workflow. Our table and primary key looks something like below:

PRIMARY KEYCOL1COL2COL3COL4COL5
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

2 REPLIES 2

@Rajeshbabu Chintaguntla Request for assiatnace

New Contributor

Hi,
Please let me know in case you have come up with any solution, I am facing the same issue.

Thanks in advance !!!

Hardeep

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.