Archives of the TeradataForum
Message Posted: Tue, 02 Sep 2003 @ 17:15:32 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|