Teradata建表语句

1.常规

 

写道

CREATE TABLE SampDb.PhoneList
,FALLBACK
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
(
Number CHAR(10) TITLE 'Number' NOT NULL
,Name CHAR(25) TITLE 'Name' NOT NULL
,LType CHAR(4) TITLE 'Line Type'
,Calls INTEGER TITLE 'Calls Made' FORMAT 'zzz9'
,Take CHAR(1) TITLE 'Important'
)
UNIQUE PRIMARY INDEX( Number );

 2.copy

写道

CREATE TABLE PhoneList2
AS PhoneList WITH DATA;

 

3.select

写道

CREATE TABLE PhoneUS
AS (
SELECT * FROM PhoneList WHERE country = 'US'
) WITH DATA;

 

4.可变临时表

写道

create volatile multiset table tb1, no log (
USER_ID DECIMAL(14,0)
,REGION_CODE CHAR(2)
,LAC_CODE CHAR(5)
,CELL_CODE CHAR(5)
,CELL_LOC_ATTR_CODE CHAR(2)
,CALL_TIMES INTEGER
,CALL_DUR_SEC INTEGER
) primary index(USER_ID, REGION_CODE, LAC_CODE, CELL_CODE)
on commit preserve rows;