REG: Update -Set in Phoenix

[Ns G]

HI There,

I have a query like one below

UPDATE table_1
SET    id1 = (SELECT Min(id1)
          FROM   table_1 t2
          WHERE  table_1.id3 = t2.id3)
WHERE  id3 = id4

I am trying to implement this in Apache Phoenix. Can anyone suggest how
should i be doing this as we do not have set command in phoenix. I am using
4.3.1 version.


Thanks,

Satya