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. |