Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 26 Aug 2003 @ 11:09:45 GMT

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

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;
  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,


  <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: 28 Jun 2020