Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Oct 1999 @ 20:04:32 GMT


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


Subj:   MSR and Sampling
 
From:   Stuart MacMillan

Am I missing something here?

I want to insert into an empty 'sample' table 1000 sample rows from two tables. To do this I've run two insert/select statements in parallel using the sample feature.

ie.

     insert into my_sample_table
     sel * from  table_01 sample 1000
     ;insert into my_sample_table
     sel * from table_02 sample 1000
     ;

The explain runs two samples and implies it will insert 2*1000 rows in total, however I only get 1000 rows from table_02.

It does work fine if run serially.

From DBCINFO I'm running

     RELEASE V2R.03.00.02.03
     VERSION 03.00.02.08

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: 15 Jun 2023