1.0 - 8.00 - VectorDistance Arguments - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)
TargetIDColumns
Specify the names of the columns that comprise the target vector identifier. You must partition the target input table by these columns and specify them with this argument.
TargetFeatureColumn
Specify the name of the column that contains the target vector feature name (for example, the axis of a 3-D vector).
The function drops any entry that has a NULL value in a feature_column.
TargetValueColumn
[Optional] Specify the name of the column that contains the value for the target vector feature. If you omit this argument, each feature (that is, each row) has the target value 1.
The function drops any entry that has a NULL value in a value_column.
RefIDColumns
[Optional] Specify the names of the columns that comprise the reference vector identifier.
Default: TargetIDColumns value
RefFeatureColumn
[Optional] Specify the name of the column that contains the reference vector feature name.
The function drops any entry that has a NULL value in a feature_column.
Default: feature_column (TargetFeatureColumn value)
RefValueColumn
[Optional] Specify the name of the column that contains the value for the reference vector feature.
The function drops any entry that has a NULL value in a value_column.
Default: TargetValueColumn argument value.
RefTableSize
[Optional] Specify the size of the reference table. Specify 'LARGE' only if the reference table does not fit in memory, because 'SMALL' allows faster processing.
Default: 'SMALL'
DistanceMeasure
[Optional] Specify the distance measures that the function uses.
The binary distance between two vectors is 1 if the vectors are identical and 0 otherwise.
Default: 'cosine'
IgnoreMismatch
[Optional] Specify whether to drop mismatched dimensions. If DistanceMeasure is 'cosine', this argument is 'false'. If you specify 'true', two vectors with no common features become two empty vectors when only their common features are considered, and the function cannot measure the distance between them.
Default: 'true'
ReplaceInvalid
[Optional] Specify the value to return when the function encounters an infinite value or empty vectors. For custom, you can supply any DOUBLE PRECISION value.
Default: 'PositiveInfinity'
TopK
[Optional] Specify, for each target vector and for each measure, the maximum number of closest reference vectors to include in the output table. For k, you can supply any INTEGER value.
Default: Maximum INTEGER value (2,147,483,647)
MaxDistance
[Optional] Specify the maximum distance between a pair of target and reference vectors. If the distance exceeds the threshold, the pair does not appear in the output table.
If the DistanceMeasure argument specifies multiple measures, then the MaxDistance argument must specify a threshold for each measure. The ith threshold corresponds to the ith measure. Each threshold can be any DOUBLE PRECISION value.
Default behavior: The function returns all results.