Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 08 Dec 2012 @ 15:56:09 GMT


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


Subj:   Re: Creating a new table by copying other table with a portion of data
 
From:   Dave Wellman

Hi James,

If you want to use any components of a SELECT statement then your CREATE TABLE AS command must use the SELECT variation. Try:

     CREATE TABLE t2
     AS
     (Select ...
     From t1
     Sample 0.1) with data

But remember that if you're doing this then you should probably specify the column(s) required for the Primary Index. This option will default to the first column being a NUPI or it might build a NOPI table depending on your release of TD and the PrimaryIndexDefault setting in DBSControl.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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