16.20 - TD_TIMESERIES_RANGE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

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

Purpose

The TD_TIMESERIES_RANGE macro finds the valid ranges of the TD_TIMECODE and TD_SEQNO columns in a PTI table.

Syntax



Syntax Elements

DBC
The name of the database where the function is located.
DBname.TSTable
The name of the database and PTI table.

Usage Notes

Use this macro to show the upper limit of values that can be stored in the TD_TIMECODE and TD_SEQNO columns of a PTI table. Sensor data can flow rapidly into a system and cause a PTI overflow. This macro provides available space information for planning purposes and can also be helpful in resolving out of range errors.

Example: Get the Valid Range of Values for the TD_TIMECODE and TD_SEQNO Columns

Create table MyDB.ocean_buoy (
TD_TIMEBUCKET BIGINT NOT NULL GENERATED SYSTEM TIMECOLUMN,
TD_TIMECODE TIMESTAMP(6) NOT NULL GENERATED TIMECOLUMN,
TD_SEQNO INTEGER NOT NULL GENERATED TIMECOLUMN,
BuoyID INTEGER,
Temperature INTEGER NOT NULL)
PRIMARY TIME INDEX (TIMESTAMP(6), DATE '2016-01-01', HOURS(1), SEQUENCED);
 
exec DBC.TD_TIMESERIES_RANGE('MyDB.ocean_buoy');
 
TD_TIMECODE_RANGE 
----------------------------------------------------                                                                                        
TD_TIMECODE  BETWEEN TIMESTAMP '2016-01-0100:00:00.000000+00:00' AND
TIMESTAMP '2030-08-1214:23:21.842737+00:00'
                                                                                                          
TD_SEQNO_RANGE 
----------------------------------------------------  
TD_SEQNO  BETWEEN 1  AND 20000
 
-- you can specify the table name in the macro and will get the same output as above example.
 
exec DBC.TD_TIMESERIES_RANGE('ocean_buoy');