Re: How to support UPSERT with WHERE clause

[alchemist]

Thanks so much for your help:

This works:

UPSERT INTO TESTTABLE1 (PK, CF.COL1 , CF.COL2 , CF.COL3 )  SELECT 'row2',
'xxx1', 'yyy1', 'zzz1'  FROM TESTTABLE1  WHERE MEDIAID = '123';



--
Sent from: http://apache-phoenix-user-list.1124778.n5.nabble.com/