Archives of the TeradataForum
Message Posted: Tue, 14 Jul 2015 @ 09:23:20 GMT
<-- Anonymously Posted: Tuesday, July 14, 2015 12:24 -->
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 ( Stud_Id varchar(10), Stud_Name varchar(100), Course_Id varchar(10) )Primary Index (Stud_Id) PARTITION BY (Course_Id); Now consider the following records being loaded by each session - Session 1: 1001, John Davis, 9001 1004, Mike Connor, 9001 Session 2: 1002, Peter Martin, 9002 1005, Kevin Pike, 9002
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 ?
Please share your thoughts...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|