Currently i am using N1QL query to move data from one bucket to another, the query is below,
poc-target (KEY _k, VALUE _v) SELECT META().id _k, _v from
masterdata-source _v where meta().id=‘Cus::1111_999’
Now i want to change something in one of the field coming from SELECT statement( like a filed called
modifiedtime while inserting in the target. The reason for using UPSERT to make sure we are not worrying whether INSERT or UPDATE.
Is there a way for this?