7.00.02 - Output - 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 SeriesSplitter function outputs two tables, the output table and the stats table.

SeriesSplitter Output Table Schema
Column Name Data Type Description
partition_column Same as input column Partitioning column specified by the PartitionByColumns argument. The output table has a column for each partitioning column.
split_id_column INTEGER or VARCHAR Contains the split identifier, in the form specified by the PartialSplitID argument.
ordering_column Same as input column Ordering column specified by the OrderByColumns argument. The output table has a column for each ordering column.
duplicate_column SMALLINT Duplicate column specified by the DuplicateColumn argument.
SeriesSplitter Stats Table Schema
Column Name Data Type Description
statistics VARCHAR Contains these statistics for the splitting operation that the function performed:

input_table_row_count

input_partition_count

output_split_count

inserted_row_count

output_table_row_count

processing_time_in_seconds

value BIGINT Contains the values for the statistics.