1.1 - 8.10 - UnivariateStatistics Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Output Message Schema

Column Data Type Description
message VARCHAR Reports whether function succeeded and saved output files.

MomentsStatistics, BasicStatistics, and QuantileStatistics Schema

The StatisticsGroups syntax element determines which statistics tables the function outputs:
  • If you omit StatisticsGroups, the function calculates all statistics and outputs three tables, one for each statistics_group.
  • If you specify StatisticsGroups, the function outputs a table for each specified statistics_group.

For each table to be output, you must specify a name, using the MomentsTableName, BasicTableName, or QuantilesTableName syntax element.

The tables have the same schema.

Column Data Type Description
partition_column Same as in input table [Column appears once for each specified partition_column.] Column copied from input table.Defines a partition for statistics calculation.
stats VARCHAR Identifies statistic in row; for example, "Coefficient of variation" or "Corrected sum of squares."
result_value DOUBLE PRECISION [Column appears once for each specified target_column.] Calculated statistic identified by statistics column.