Archives of the TeradataForum
Message Posted: Tue, 19 Oct 1999 @ 20:04:32 GMT
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.
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|