Update Non key columns Query Pheonix JDBC

Question

I have problem with updating values in apache phoenix . The below query is throwing JDBC exception. I am new to Pheonix JDBC and confusing with upsert query usage for updating non primary key field values.

String sql = UPSERT INTO mytable (serverName,SationName, product) SELECT serverName,stationName ‘sampleProduct’ FROM mytable WHERE product = ‘sampleProduct’;

The primary key of "myTable" is combination of "serverName" and "StationName". I would like to update value of product column from 'sampleProduct' to 'TestProduct'.

score 0 · Answer 1 · edited Dec 20 '16 at 21:15

0

Update the sql query with following line. Hope it will help.

String sql = "REPLACE INTO mytable (serverName,SationName, product)
         SELECT serverName,stationName , 'sampleProduct'
            FROM mytable WHERE product = 'sampleProduct'";

edited Dec 20 '16 at 21:15

Rick James

135,179
13
127
222

answered Dec 19 '16 at 19:43

Faizan Younus

793
1
8
13

Isn't `UPSERT` really `INSERT ... ON DUPLICATE KEY UPDATE...`? – Rick James Dec 20 '16 at 21:16
UPSERT is not in mysql – Faizan Younus Dec 21 '16 at 10:20

score 0 · Answer 2 · answered Dec 20 '16 at 21:20

"The primary key of "myTable" is combination of "serverName" and "StationName". I would like to update value of product column from 'sampleProduct' to 'TestProduct'."

You say nothing about "inserting if the row does not already exist, so I don't see UPSERT as being appropriate. The MySQL code is

UPDATE myTable
    SET product = 'sampleProduct'
    WHERE serverName = '...'
      AND sampleProduct = '...';

(I don't know what values are needed for '...'.)

Update Non key columns Query Pheonix JDBC

2 Answers2