1.1 - 8.10 - Best-Match Mode Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify the name of the InputTable column that contains the values of the sample data set.
[Optional] Specify one to three tests to perform:
test Description
'KS' Kolmogorov-Smirnov test.
'AD' Anderson-Darling test.
'CHISQ' Pearson's Chi-squared test.
Default: All tests
[Optional] Specify the reference distributions (which must be continuous) and their parameters. The possible distribution and parameters values for continuous distributions are in the table, Continuous Distributions and Parameters, in Hypothesis-Test Mode Syntax Elements.
Default: All of these distributions:
  • Beta
  • Cauchy
  • Exponential
  • F
  • Gamma
  • Lognormal
  • Normal
  • T
  • Triangular
  • Uniformcontinuous
  • Weibull
[Optional] Specify the names of the InputTable columns that contain the group identifications over which to run the test. The function can run multiple tests for different partitions of the data in parallel. If you omit this syntax element, specify PARTITION BY 1 and omit the GROUP BY clause in the second ON clause.
[Optional] Specify the minimum group size. The function ignores groups smaller than the minimum size when calculating statistics.
Default: 50
[Optional] Specify the number of cells to make discrete in a continuous distribution. The cell_size must be greater than 3 if distribution is NORMAL; otherwise, it must be greater than 1. The quotient min_group_size/cell_size cannot be less than 5.
If you specify NumCell, you must specify 'CHISQ' in the Tests syntax element.
Default: 10
[Optional] Specify the number of the top matching distributions for the function to output.
Default: 1