Hello, advise how to solve the problem:
My table t1 is having
It works :
update t1 set name='mm' where id=2
insert into t1(id,name) values(2,'kk');
UPDATE t1 SET col_a = value_a
WHERE PI_col = PI_value ELSE
INSERT INTO t1 VALUES (PI_value,value_a);
I prefer Merge if I have reference table. Do you have reference table from where you can refer?
This error message simply means that you're updating the PI or partitioning if the target table, which is not allowed in an UPSERT (or MERGE).
I have flat file with two columns data :
and if i try to do
only update will it allow ? bcz id=2 not avail in table as well.
update t1 set name= name@file where id=2 ;