16.20 - Example: Volatile Table With Single-Level Partitioning - 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
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following example demonstrates a valid CREATE VOLATILE TABLE request with single-level partitioning.

     CREATE VOLATILE TABLE V_lineitem (
       l_orderkey INTEGER NOT NULL,
       l_partkey INTEGER NOT NULL,
       l_suppkey INTEGER,
       l_linenumber INTEGER,
       l_quantity INTEGER NOT NULL,
       l_extendedprice DECIMAL(13,2) NOT NULL,
       l_discount DECIMAL(13,2),
       l_tax DECIMAL(13,2),
       l_returnflag CHARACTER(1),
       l_linestatus CHARACTER(1),
       l_shipdate DATE FORMAT 'yyyy-mm-dd',
       l_commitdate DATE FORMAT 'yyyy-mm-dd',
       l_receiptdate DATE FORMAT 'yyyy-mm-dd',
       l_shipinstruct VARCHAR(25),
       l_shipmode VARCHAR(10),
       l_comment VARCHAR(44))
     PRIMARY INDEX (l_orderkey)
     PARTITION BY RANGE_N(l_shipdate BETWEEN DATE '1992-01-01' 
                                     AND     DATE '1998-12-31' 
                                     EACH INTERVAL '1' MONTH);