UnivariateStatistics Example 2: TargetColumns, PartitionColumns - Teradata Vantage

This example specifies the target columns explicitly and partitions the data.

Input

• finance_data3, as in VARMAX Example 1: No Exogenous Model

SQL Call

DROP TABLE moments;
DROP TABLE basic;  
DROP TABLE quantiles;

SELECT * FROM UnivariateStatistics (
  ON finance_data3 AS InputTable
  OUT TABLE MomentsTableName (moments)
  OUT TABLE BasicTableName (basic)
  OUT TABLE QuantilesTableName (quantiles)
  USING
  TargetColumns ('expenditure','income','investment')
  PartitionColumns ('id')
) AS dt;

Output

UnivariateStatistics succeeded. The output tables are saved.

This query returns the following table:

SELECT * FROM moments ORDER BY id, stats;

This query returns the following table:

SELECT * FROM basic ORDER BY id, stats;

This query returns the following table:

SELECT * FROM quantiles ORDER BY id, stats;