Now Phoenix don not support where clause within upsert. I also think this function is very important that use frequency is highly.
Maybe the dialect looks like this: Upset into scheme.table_name set col=‘x’ where id=‘x’ This semantic to implement is easy in Phoenix, we just need once write rpc if where condition can hit rowKey On 2018/07/14 23:54:38, alchemist <a...@gmail.com> wrote: > Looks like UPSERT doesn't support a WHERE clause.> > > But people have used workaroung 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.> > > > > --> > Sent from: http://apache-phoenix-user-list.1124778.n5.nabble.com/> >
