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



     
  <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