|
|
Archives of the TeradataForum
Message Posted: Tue, 26 Aug 2003 @ 11:09:45 GMT
Subj: | | Re: SAMPLE Statement- Divide by 0 issue |
|
From: | | Claybourne Barrineau |
I ran the same code on V2R5.0.1 and didn't receive any error messages.
Select TVMID, SampleID
From dbc.TVM
Sample .6, .25, .15;
Explanation -------------------------------------------------- | |
| 1) | First, we lock dbc.TVM for access.
| |
| 2) | Next, we do an all-AMPs SAMPLING step from dbc.TVM by way of an all-rows scan with no residual conditions into Spool 1 (group_amps),
which is built locally on the AMPs. Samples are specified as a fraction of total rows.
| |
| 3) | Finally, we send out an END TRANSACTION step to all AMPs involved in processing the request.
| |
| -> | The contents of Spool 1 are sent back to the user as the result of statement 1.
| |
I even tried this against an empty table without any error messages. Maybe it is something related to Windows 2000?
Hope this helps,
Clay
| |