Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2015 @ 09:23:20 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   PPI and concurrent loads to the table
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, July 14, 2015 12:24 -->

Hi,

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...


Thanks



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016