7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

Each row of the output table contains a burst interval. The following table describes the columns of the output table. Columns copied from input_table appear in the same order in the output table.

Burst Output Table Schema
Column Data Type Description
start_time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) Copied from input_table.
end_time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) Copied from input_table.
value_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), or VARCHAR Copied from input_table.
burst_start INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) Contains the start time of the burst interval.
burst_end INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) Contains the end time of the burst interval.
burst_duration DOUBLE PRECISION Contains the duration of the burst interval:

burst_end - burst_start

accumulate_column Any Copied from input_table only if specified by the Accumulate argument.

Typically, one accumulate_column is a row identifier, such as 'id'.