16.20 - Example - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

For a queue table, you must specify a contiguous map. You cannot specify a sparse map.

CREATE TABLE qtbl_1, QUEUE, 
 MAP=TD_Map1 (
col_1 TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
col_2 INTEGER,
col_3 INTEGER)
PRIMARY INDEX (col_2, col_3);