7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
The Burst function has two input tables:
  • input_table
  • time_table [Optional]

    If you omit time_table, you must specify either the TimeInterval or NumPoints argument.

Each row of input_table contains a time interval to be burst. The following table describes the input_table columns that you can specify in function arguments.

Burst input_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) Contains the start time of the time interval to be burst, specified by the TimeColumn argument.
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) Contains the end time of the time interval to be burst, specified by the TimeColumn argument.
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 Column to be copied to the output table, specified by the ValueColumns argument.
accumulate_column Any Optional. Column to be copied to the output table, specified by the Accumulate argument.

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

Each row of time_table contains the start and end times of a burst interval. The following table describes the columns of time_table.

Burst time_table Schema
Column Data Type Description
id Any Contains the identifier of the input_table row with the time interval to be burst.

If input_table row i is to be burst into n burst intervals, time_table has n rows with the id value i.

burst_start_time 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 a burst interval.
burst_end_time 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 a burst interval.