Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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

FROM   proddbase.source_table_01                 T1
      ,proddbase.source_table_02                 T2

WHERE       ... etc


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?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020