For a PPI table (with a NUPI), is it possible to load data concurrently to the same table via multiple sessions by the same user ? In other words, in a PPI table does TD lock only a particular partition for loading or the entire table is locked ?
For e.g. we have the following table :
Create table test_concur
)Primary Index (Stud_Id)
PARTITION BY (Course_Id);
Now consider the following records being loaded by each session -
1001, John Davis, 9001
1004, Mike Connor, 9001
1002, Peter Martin, 9002
1005, Kevin Pike, 9003
Assume that all the above records hash to the same AMP. Will TD allow loading these 4 records concurrently (since partition is different) or will it block one session until the earlier session concludes loading to the table ?