phoenix - How to use WHERE clause with Phoenix UPSERT

Question

Looks like UPSERT doesn't support a WHERE clause.

But people have used workaround like following:

UPSERT INTO test.MyTable(col1, col2) SELECT col3, col4 FROM test.TempTable WHERE col5 = ABC

Does that mean if I have a use case where I need to update all the columns of the MyTable based on some key, I need to add the data to be updated in another TempTable then use a command similar to above to update data of the MyTable. Please let me know if my understanding is correct. Somehow adding data in another table just to update source table does not seems correct.

标签： phoenix