Fwd: SPARK SQL update table based on condition

2017-10-27 Thread Suresh Ayyavoo
any comments? -- Forwarded message -- From: Suresh Ayyavoo Date: Tue, Oct 17, 2017 at 4:40 PM Subject: SPARK SQL update table based on condition To: users@zeppelin.apache.org Hi All, Senario: update existing row based on column value in a table, this is how it's done in

SPARK SQL update table based on condition

2017-10-17 Thread Suresh Ayyavoo
Hi All, Senario: update existing row based on column value in a table, this is how is do in SPARK SQL, i'm i doing right? is there any better way to do it in spark sql? 1. Table (zeppelin-report) row should be updated based on column value 1. select * from table1 where id not in(select id from t