Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 17:15:32 GMT


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


Subj:   CREATE TABLE AS : Primary Index and Compressed Columns
 
From:   Gary Ramsay

A CREATE TABLE ... AS of the following form causes a failure under V2R5.0 if any of the primary index columns is compressed on the source table :

CREATE TABLE mydbase.my_table  AS

(SELECT      T1.col_01
                        ,T1.col_03

FROM   proddbase.source_table_01                 T1
      ,proddbase.source_table_02                 T2

WHERE       ... etc
)

WITH NO DATA

PRIMARY INDEX     (T1.col_01, T2.col_02) ;

Under V2R4.1.3 the above worked - despite the manual implying that it wouldn't - and simply ignored the compression.

Does anyone know of a workaround that will still allow the convenience of using CREATE TABLE AS?


Thanks,

Gary



     
  <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: 27 Dec 2016