Archives of the TeradataForum
Message Posted: Sat, 08 Dec 2012 @ 15:56:09 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|