Optional Syntax Elements for TD_KNN - Analytics Database
Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
Introduction to Analytics Database Analytic Functions
Changes and Additions
Analytics Database Analytic Function Categories
Data Cleaning Functions
Data Exploration Functions
Feature Engineering Transform Functions
Feature Engineering Utility Functions
Model Training Functions
Model Scoring Functions
Model Evaluation Functions
Text Analytic Functions
Path and Pattern Analysis Functions
Hypothesis Testing Functions
Usage Notes
How to Read Syntax
Input Table Rows Redistribution
Function Syntax Descriptions
Size of the Query
AMP Configuration Impact on Function Execution
Limitations When Using PARTITION BY
Functions Ignore Disallowed Syntax Elements
Input Table Schemas
Function Names with and without TD Prefix
Accumulated Columns Impact on Function Performance
Datatype Change in Accumulated Columns
Displaying Online Help for Analytics Database Analytic Functions
BC/BCE Timestamps
Workload Management Configuration for Analytics Database Analytic Functions
Avoid Deadlocks Using Volatile Tables
Non-Deterministic Behavior
Maximum Number of Columns in a Database Table
Spool Space Exhaustion for Large Partitions at High Concurrency
Recommendations for Using Analytic Functions
Data Cleaning Functions
Pack
Pack Syntax
Required Syntax Elements for Pack
Optional Syntax Elements for Pack
Pack Input
Pack Output
Examples: How to Use Pack
Pack Examples Input
Example: Default Options
Example: Nondefault Options
StringSimilarity
StringSimilarity Syntax
StringSimilarity Syntax Elements
StringSimilarity Input
StringSimilarity Output
Examples: How to Use StringSimilarity
StringSimilarity Example: Specify Column Names
StringSimilarity Example: Specify Column Ranges
TD_ConvertTo
TD_ConvertTo Syntax
Required Syntax Elements for TD_ConvertTo
Optional Syntax Elements for TD_ConvertTo
TD_ConvertTo Input
TD_ConvertTo Output
TD_ConvertTo Usage Notes
Example: How to Use TD_ConvertTo
TD_GetFutileColumns
TD_GetFutileColumns Syntax
Required Syntax Elements for TD_GetFutileColumns
Optional Syntax Elements for TD_GetFutileColumns
TD_GetFutileColumns Input
TD_GetFutileColumns Output
Example: How to Use TD_GetFutileColumns
TD_GetRowsWithoutMissingValues
TD_GetRowsWithoutMissingValues Syntax
Required Syntax Elements for TD_GetRowsWithoutMissingValues
Optional Syntax Elements for TD_GetRowsWithoutMissingValues
TD_GetRowsWithoutMissingValues Input
TD_GetRowsWithoutMissingValues Output
Example: How to Use TD_GetRowsWithoutMissingValues
TD_OutlierFilterFit
TD_OutlierFilterFit Syntax
TD_OutlierFilterFit Syntax Elements
TD_OutlierFilterFit Input
TD_OutlierFilterFit Output
Example: Using TD_OutlierFilterFit with Percentile Method
TD_OutlierFilterTransform
TD_OutlierFilterTransform Syntax
Required Syntax Elements for TD_OutlierFilterTransform
Optional Syntax Elements for TD_OutlierFilterTransform
TD_OutlierFilterTransform Input
TD_OutlierFilterTransform Output
Example: How to Use TD_OutlierFilterTransform
TD_SimpleImputeFit
TD_SimpleImputeFit Syntax
Required Syntax Elements for TD_SimpleImputeFit
Optional Syntax Elements for TD_SimpleImputeFit
TD_SimpleImputeFit Input
TD_SimpleImputeFit Output
Example: How to Use TD_SimpleImputeFit
TD_SimpleImputeTransform
TD_SimpleImputeTransform Syntax
Required Syntax Elements for TD_SimpleImputeTransform
Optional Syntax Elements for TD_SimpleImputeTransform
TD_SimpleImputeTransform Input
TD_SimpleImputeTransform Output
Example: How to Use TD_SimpleImputeTransform
Unpack
Unpack Syntax
Required Syntax Elements for Unpack
Optional Syntax Elements for Unpack
Unpack Input
Unpack Output
Examples: How to Use Unpack
Example: Delimiter Separates Virtual Columns
Example: No Delimiter Separates Virtual Columns
Example: More Input Columns than Output Columns
Example: Input Columns with Trailing Special Characters
Data Exploration Functions
MovingAverage
Weighted Moving Average
Triangular Moving Average
Simple Moving Average
Modified Moving Average
Exponential Moving Average
Cumulative Moving Average
MovingAverage Syntax
Required Syntax Elements for MovingAverage
Optional Syntax Elements for MovingAverage
MovingAverage Input
MovingAverage Output
Examples: How to Use MovingAverage
MovingAverage Examples Input
Example: Simple Moving Average
Example: Weighted Moving Average
Example: Exponential Moving Average
Example: Modified Moving Average
Example: Cumulative Moving Average
Example: Triangular Moving Average
TD_CategoricalSummary
TD_CategoricalSummary Syntax
TD_CategoricalSummary Syntax Elements
TD_CategoricalSummary Input
TD_CategoricalSummary Output
Example: How to Use TD_CategoricalSummary
TD_ColumnSummary
TD_ColumnSummary Syntax
Required Syntax Elements for TD_ColumnSummary
Optional Syntax Elements for TD_ColumnSummary
TD_ColumnSummary Input
TD_ColumnSummary Output
Example: How to Use TD_ColumnSummary
TD_GetRowsWithMissingValues
TD_GetRowsWithMissingValues Syntax
Required Syntax Elements for TD_GetRowsWithMissingValues
Optional Syntax Elements for TD_GetRowsWithMissingValues
TD_GetRowsWithMissingValues Input
TD_GetRowsWithMissingValues Output
Example: Using TD_GetRowsWithMissingValues to Find NULL Values
TD_Histogram
TD_Histogram Syntax
Required Syntax Elements for TD_Histogram
Optional Syntax Elements for TD_Histogram
TD_Histogram Input
TD_Histogram Output
Examples: How to Use TD_Histogram
TD_QQNorm
TD_QQNorm Syntax
Required Syntax Elements for TD_QQNorm
Optional Syntax Elements for TD_QQNorm
TD_QQNorm Input
TD_QQNorm Output
Example: How to Use TD_QQNorm
TD_UnivariateStatistics
TD_UnivariateStatistics Syntax
TD_UnivariateStatistics Syntax Elements
TD_UnivariateStatistics Input
TD_UnivariateStatistics Output
Example: Using TD_UnivariateStatistics to Determine Mean, Median, and Mode
TD_WhichMax
TD_WhichMax Syntax
Required Syntax Elements for TD_WhichMax
Optional Syntax Elements for TD_WhichMax
TD_WhichMax Input
TD_WhichMax Output
TD_WhichMax Example
TD_WhichMin
TD_WhichMin Syntax
Required Syntax Elements for TD_WhichMin
Optional Syntax Elements for TD_WhichMin
TD_WhichMin Input
TD_WhichMin Output
TD_WhichMin Example
Feature Engineering Transform Functions
Antiselect
Antiselect Syntax
Antiselect Syntax Elements
Antiselect Input
Antiselect Output
Antiselect Examples
Antiselect Example: No Column Ranges
Antiselect Example: Column Range
TD_BinCodeFit
TD_BinCodeFit Syntax
Required Syntax Elements for TD_BinCodeFit
Optional Syntax Elements for TD_BinCodeFit
TD_BinCodeFit Input
TD_BinCodeFit Output
Example: How To Use TD_BinCodeFit
TD_BinCodeTransform
TD_BinCodeTransform Syntax
Required Syntax Elements for TD_BinCodeTransform
Optional Syntax Elements for TD_BinCodeTransform
TD_BinCodeTransform Input
TD_BinCodeTransform Output
TD_BinCodeTransform Usage Notes
Example: How to Use TD_BinCodeTransform
TD_ColumnTransformer
TD_ColumnTransformer Syntax
TD_ColumnTransformer Syntax Elements
TD_ColumnTransformer Input
TD_ColumnTransformer Output
TD_ColumnTransformer Example
TD_FunctionFit
TD_FunctionFit Syntax
TD_FunctionFit Input
TD_FunctionFit Output
TD_FunctionFit Example
TD_FunctionTransform
TD_FunctionTransform Syntax
TD_FunctionTransform Syntax Elements
TD_FunctionTransform Input
TD_FunctionTransform Output
TD_FunctionTransform Example
TD_NonLinearCombineFit
TD_NonLinearCombineFit Syntax
Required Syntax Elements for TD_NonLinearCombineFit
Optional Syntax Elements for TD_NonLinearCombineFit
TD_NonLinearCombineFit Input
TD_NonLinearCombineFit Output
Example: How to Use TD_NonLinearCombineFit
TD_NonLinearCombineTransform
TD_NonLinearCombineTransform Syntax
Required Syntax Elements for TD_NonLinearCombineTransform
Optional Syntax Elements for TD_NonLinearCombineTransform
TD_NonLinearCombineTransform Input
TD_NonLinearCombineTransform Output
Example: How to Use TD_NonLinearCombineTransform
TD_OneHotEncodingFit
TD_OneHotEncodingFit Syntax
Required Syntax Elements for TD_OneHotEncodingFit
Optional Syntax Elements for TD_OneHotEncodingFit
TD_OneHotEncodingFit Input
TD_OneHotEncodingFit Output
TD_OneHotEncodingFit Usage Notes
Example: How to Use TD_OneHotEncodingFit
TD_OneHotEncodingTransform
TD_OneHotEncodingTransform Syntax
Required Syntax Elements for TD_OneHotEncodingTransform
Optional Syntax Elements for TD_OneHotEncodingTransform
TD_OneHotEncodingTransform Input
TD_OneHotEncodingTransform Output
Example: How to Use TD_OneHotEncodingTransform
TD_OrdinalEncodingFit
TD_OrdinalEncodingFit Syntax
Required Syntax Elements for TD_OrdinalEncodingFit
Optional Syntax Elements for TD_OrdinalEncodingFit
TD_OrdinalEncodingFit Input
TD_OrdinalEncodingFit Output
Example: How to Use TD_OrdinalEncodingFit
TD_OrdinalEncodingTransform
TD_OrdinalEncodingTransform Syntax
Required Syntax Elements for TD_OrdinalEncodingTransform
Optional Syntax Elements for TD_OrdinalEncodingTransform
TD_OrdinalEncodingTransform Input
TD_OrdinalEncodingTransform Output
Example: How to Use TD_OrdinalEncodingTransform
TD_Pivoting
TD_Pivoting Syntax
Required Syntax Elements for TD_Pivoting
Optional Syntax Elements for TD_Pivoting
TD_Pivoting Input
TD_Pivoting Output
Example: How to Use TD_Pivoting
RowsPerPartition
PivotColumn
Aggregation with PivotColumn
Aggregation Only
TD_PolynomialFeaturesFit
TD_PolynomialFeaturesFit Syntax
Required Syntax Elements for TD_PolynomialFeaturesFit
Optional Syntax Elements for TD_PolynomialFeaturesFit
TD_PolynomialFeaturesFit Input
TD_PolynomialFeaturesFit Output
Example: How to Use TD_PolynomialFeaturesFit
TD_PolynomialFeaturesTransform
TD_PolynomialFeaturesTransform Syntax
Required Syntax Elements for TD_PolynomialFeaturesTransform
Optional Syntax Elements for TD_PolynomialFeaturesTransform
TD_PolynomialFeaturesTransform Input
TD_PolynomialFeaturesTransform Output
Example: How to Use TD_PolynomialFeaturesTransform
TD_RandomProjectionFit
TD_RandomProjectionFit Syntax
TD_RandomProjectionFit Syntax Elements
TD_RandomProjectionFit Input
TD_RandomProjectionFit Output
TD_RandomProjectionFit Example
TD_RandomProjectionMinComponents
TD_RandomProjectionMinComponents Syntax
TD_RandomProjectionMinComponents Syntax Elements
TD_RandomProjectionMinComponents Input
TD_RandomProjectionMinComponents Output
TD_RandomProjectionMinComponents Example
TD_RandomProjectionTransform
TD_RandomProjectionTransform Syntax
TD_RandomProjectionTransform Syntax Elements
TD_RandomProjectionTransform Input
TD_RandomProjectionTransform Output
TD_RandomProjectionTransform Example
TD_RowNormalizeFit
TD_RowNormalizeFit Syntax
Required Syntax Elements for TD_RowNormalizeFit
Optional Syntax Elements for TD_RowNormalizeFit
TD_RowNormalizeFit Input
TD_RowNormalizeFit Output
Example: How to Use TD_RowNormalizeFit
TD_RowNormalizeTransform
TD_RowNormalizeTransform Syntax
Required Syntax Elements for TD_RowNormalizeTransform
Optional Syntax Elements for TD_RowNormalizeTransform
TD_RowNormalizeTransform Input
TD_RowNormalizeTransform Output
Example: How to Use TD_RowNormalizeTransform
TD_ScaleFit
TD_ScaleFit Syntax
Required Syntax Elements for TD_ScaleFit
Optional Syntax Elements for TD_ScaleFit
TD_ScaleFit Input
TD_ScaleFit Output
Examples: How to Use TD_ScaleFit
Dense Input
Sparse Input without Partition
Sparse Input with Partition
TD_ScaleTransform
TD_ScaleTransform Syntax
Required Syntax Elements for TD_ScaleTransform
Optional Syntax Elements for TD_ScaleTransform
TD_ScaleTransform Input
TD_ScaleTransform Output
Examples: How to Use TD_ScaleTransform
Dense Input
Sparse Input without Partition
Sparse Input with Partition
TD_TargetEncodingFit
TD_TargetEncodingFit Syntax
TD_TargetEncodingFit Syntax Elements
TD_TargetEncodingFit Input
TD_TargetEncodingFit Output
TD_TargetEncodingFit Examples
TD_TargetEncodingFit Usage Notes
TD_TargetEncodingTransform
TD_TargetEncodingTransform Syntax
TD_TargetEncodingTransform Syntax Elements
TD_TargetEncodingTransform Input
TD_TargetEncodingTransform Output
TD_TargetEncodingTransform Examples
TD_TargetEncodingTransform Usage Notes
TD_Unpivoting
TD_Unpivoting Syntax
Required Syntax Elements for TD_Unpivoting
Optional Syntax Elements for TD_Unpivoting
TD_Unpivoting Input
TD_Unpivoting Output
TD_Unpivoting Usage Notes
Example: How to Use TD_Unpivoting
Feature Engineering Utility Functions
TD_FillRowID
TD_FillRowID Syntax
Required Syntax Elements for TD_FillRowID
Optional Syntax Elements for TD_FillRowID
TD_FillRowID Input
TD_FillRowID Output
Example: Using TD_FillRowID to Generate Row Identifers
TD_NumApply
TD_NumApply Syntax
Required Syntax Elements for TD_NumApply
Optional Syntax Elements for TD_NumApply
TD_NumApply Input
TD_NumApply Output
TD_NumApply Usage Notes
Example: How to Use TD_NumApply
TD_RoundColumns
TD_RoundColumns Syntax
Required Syntax Elements for TD_RoundColumns
Optional Syntax Elements for TD_RoundColumns
TD_RoundColumns Input
TD_RoundColumns Output
Example: How to Use TD_RoundColumns
TD_RoundColumns Column Examples
TD_StrApply
TD_StrApply Syntax
Required Syntax Elements for TD_StrApply
Optional Syntax Elements for TD_StrApply
TD_StrApply Input
TD_StrApply Output
Example: How to Use TD_StrApply
Model Training Functions
TD_DecisionForest
TD_DecisionForest Syntax
Required Syntax Elements for TD_DecisionForest
Optional Syntax Elements for TD_DecisionForest
TD_DecisionForest Input
TD_DecisionForest Output
TD_DecisionForest Examples
TD_GLM
Using Partition by Any
Using Partition by Key (Micromodeling)
TD_GLM Syntax
Required Syntax Elements for TD_GLM
Optional TD_GLM Syntax Elements
TD_GLM Input
TD_GLM Output
Examples: How to Use TD_GLM
TD_KMeans
TD_KMeans Syntax
Required Syntax Elements for TD_KMeans
Optional Syntax Elements for TD_KMeans
TD_KMeans Input
TD_KMeans Output
TD_KMeans Usage Notes
Example: How to Use TD_KMeans
TD_KNN
TD_KNN Usage Notes
TD_KNN Syntax
Required Syntax Elements for TD_KNN
Optional Syntax Elements for TD_KNN
TD_KNN Input
TD_KNN Output
Examples: How to Use TD_KNN
Example: Using TD_KNN To Predict Weight Based on Height and Age
Example: Using TD_KNN with Classification
Example: Using TD_KNN with Neighbors
TD_OneClassSVM
TD_OneClassSVM Syntax
TD_OneClassSVM Syntax Elements
TD_OneClassSVM Input
TD_OneClassSVM Output
TD_OneClassSVM Usage Notes
Example: How to Use TD_OneClassSVM
TD_SVM
TD_SVM Syntax
TD_SVM Syntax Elements
TD_SVM Input
TD_SVM Output
Examples: How to Use TD_SVM
TD_VectorDistance
TD_VectorDistance Syntax
TD_VectorDistance Syntax Elements
TD_VectorDistance Input
TD_VectorDistance Output
Example: TD_VectorDistance Using Euclidean, Manhattan, and Cosine
TD_XGBoost
TD_XGBoost Syntax
Required Syntax Elements for TD_XGBoost
Optional Syntax Elements for TD_XGBoost
TD_XGBoost Input
TD_XGBoost Output
Examples: How to Use TD_XGBoost
TD_XGBoost for Classification
TD_XGBoost for Regression
TD_XGBoost for JSON Tree Model String
Model Scoring Functions
TD_DecisionForestPredict
TD_DecisionForestPredict Syntax
Required Syntax Elements for TD_DecisionForestPredict
Optional Syntax Elements for TD_DecisionForestPredict
TD_DecisionForestPredict Input
TD_DecisionForestPredict Output
Example: How to Use TD_DecisionForestPredict
TD_GLMPredict
TD_GLMPredict Syntax
Required Syntax Elements for TD_GLMPredict
Optional Syntax Elements for TD_GLMPredict
TD_GLMPredict Input
TD_GLMPredict Output
Examples: How to Use TD_GLMPredict
TD_KMeansPredict
TD_KMeansPredict Syntax
Required Syntax Elements for TD_KMeansPredict
Optional Syntax Elements for TD_KMeansPredict
TD_KMeansPredict Input
TD_KMeansPredict Output
Example: How to Use the k-means Algorithm
Examples: How to Use TD_KMeansPredict
TD_OneClassSVMPredict
TD_OneClassSVMPredict Syntax
Required Syntax Elements for TD_OneClassSVMPredict
Optional Syntax Elements for TD_OneClassSVMPredict
TD_OneClassSVMPredict Input
TD_OneClassSVMPredict Output
Example: How to Use TD_OneClassSVMPredict
TD_SVMPredict
TD_SVMPredict Syntax
Required Syntax Elements for TD_SVMPredict
Optional Syntax Elements for TD_SVMPredict
TD_SVMPredict Input
TD_SVMPredict Output
TD_SVMPredict Usage Notes
Examples: How to Use TD_SVMPredict
TD_XGBoostPredict
TD_XGBoostPredict Syntax
Required Syntax Elements for TD_XGBoostPredict
Optional Syntax Elements for TD_XGBoostPredict
TD_XGBoostPredict Input
TD_XGBoostPredict Output
Examples: How to Use TD_XGBoostPredict
XGBoostPredict for Classification
XGBoostPredict for Regression
Model Evaluation Functions
TD_Silhouette
TD_Silhouette Syntax
Required Syntax Elements for TD_Silhouette
Optional Syntax Elements for TD_Silhouette
TD_Silhouette Input
TD_Silhouette Output
Example: How to Use TD_Silhouette
TD_ClassificationEvaluator
TD_ClassificationEvaluator Syntax
Required Syntax Elements for TD_ClassificationEvaluator
Optional Syntax Elements for TD_ClassificationEvaluator
TD_ClassificationEvaluator Input
TD_ClassificationEvaluator Output
TD_ClassificationEvaluator Usage Notes
Example: How to Use TD_ClassificationEvaluator
TD_RegressionEvaluator
TD_RegressionEvaluator Syntax
Required Syntax Elements for TD_RegressionEvaluator
Optional Syntax Elements in TD_RegressionEvaluator
TD_RegressionEvaluator Input
TD_RegressionEvaluator Output
TD_RegressionEvaluator Usage Notes
Example: How to Use TD_RegressionEvaluator
TD_ROC
TD_ROC Syntax
Required Syntax Elements for TD_ROC
Optional Syntax Elements for TD_ROC
TD_ROC Input
TD_ROC Output
Example: How to Use TD_ROC
TD_TrainTestSplit
TD_TrainTestSplit Syntax
Required Syntax Elements for TD_TrainTestSplit
Optional Syntax Elements for TD_TrainTestSplit
TD_TrainTestSplit Input
TD_TrainTestSplit Output
TD_TrainTestSplit Examples
Text Analytic Functions
NGramSplitter
NGramSplitter Usage Notes
NGramSplitter Syntax
Required Syntax Elements for NGramSplitter
Optional Syntax Elements for NGramSplitter
NGramSplitter Input
NGramSplitter Output
Examples: How to Use NGramSplitter
NGramSplitter Examples Input
Example: Omit Accumulate
Example: Specify Accumulate
TD_NaiveBayesTextClassifierPredict
TD_NaiveBayesTextClassifierPredict Syntax
TD_NaiveBayesTextClassifierPredict Syntax Elements
TD_NaiveBayesTextClassifierPredict Input
TD_NaiveBayesTextClassifierPredict Output
TD_NaiveBayesTextClassifierPredict Examples
TD_NaiveBayesTextClassifierPredict Example: TopK Specified
TD_NaiveBayesTextClassifierPredict Example: Responses Specified
TD_NaiveBayesTextClassifierTrainer
TD_NaiveBayesTextClassifierTrainer Syntax
TD_NaiveBayesTextClassifierTrainer Syntax Elements
TD_NaiveBayesTextClassifierTrainer Input
TD_NaiveBayesTextClassifierTrainer Output
Example: Using TD_NaiveBayesTextClassifierTrainer with Multinomial Model Type
TD_SentimentExtractor
TD_SentimentExtractor Syntax
Required Syntax Elements for TD_SentimentExtractor
Optional Syntax Elements for TD_SentimentExtractor
TD_SentimentExtractor Input
TD_SentimentExtractor Output
TD_SentimentExtractor Usage Notes
Examples: How to Use TD_SentimentExtractor
TD_TextParser
TD_TextParser Syntax
Required Syntax Elements for TD_TextParser
Optional Syntax Elements for TD_TextParser
TD_TextParser Input
TD_TextParser Output
TD_TextParser Example
TD_TFIDF
TD_TFIDF Syntax
Required Syntax Elements for TD_TFIDF
Optional Syntax Elements for TD_TFIDF
TD_TFIDF Input
TD_TFIDF Output
Example: How to Use TD_TFIDF
TD_WordEmbeddings
TD_WordEmbeddings Syntax
Required Syntax Elements for TD_WordEmbeddings
Optional Syntax Elements for TD_WordEmbeddings
TD_WordEmbeddings Input
TD_WordEmbeddings Output
Example: How to Use TD_WordEmbeddings
Hypothesis Testing Functions
Hypothesis Test Components
Hypothesis Test Types
TD_ANOVA
TD_ANOVA Syntax
Required Syntax Elements for TD_ANOVA
Optional Syntax Elements for TD_ANOVA
TD_ANOVA Input
TD_ANOVA Output
Examples: How to Use TD_ANOVA
Using TD_ANOVA to Determine Difference of Insect Sprays
Using GroupNames Argument
Using NumGroups Argument
TD_ChiSq
TD_ChiSq Syntax
Required Syntax Elements for TD_ChiSq
Optional Syntax Elements for TD_ChiSq
TD_ChiSq Input
TD_ChiSq Output
TD_ChiSq Usage Notes
Example: How to Use TD_ChiSq
TD_FTest
TD_FTest Syntax
Required Syntax Elements for TD_FTest
Optional Syntax Elements for TD_FTest
TD_FTest Input
TD_FTest Output
TD_FTest Usage Notes
Examples: How to Use TD_FTest
Using FirstSampleVariance and SecondSampleVariance Arguments
Using FirstSampleName and SecondSampleName Arguments
Using FirstSampleName and SecondSampleVariance Arguments
Using SecondSampleName and FirstSampleVariance Arguments
TD_ZTest
TD_ZTest Syntax
Required Syntax Elements for TD_ZTest
Optional Syntax Elements for TD_ZTest
TD_ZTest Input
TD_ZTest Output
TD_ZTest Usage Notes
Examples: How to Use TD_ZTest
Using Two-tailed Test
Using Two Samples
Using One Sample
Path and Pattern Analysis Functions
Terminology
Attribution
Attribution Syntax
Attribution Syntax Elements
Attribution Input
Model Specification
Attribution Output
Example: Model Assigns Attribution Weights to Events and Channels
nPath
nPath Syntax
nPath Syntax Elements
nPath Input
nPath Output
nPath Symbols
LAG and LEAD Expressions in Symbol Predicates
LAG Expression Syntax
LAG and LEAD Expression Rules
LAG and LEAD Expressions Example: Alias for Input Query
LAG and LEAD Expressions Example: No Alias for Input Query
nPath Patterns
nPath Greedy Pattern Matching
nPath Filters
nPath Filters Example
nPath Results
nPath Results Examples
nPath Results Example: FIRST, LAST_NOTNULL, MAX_CHOOSE, and MIN_CHOOSE
nPath Results Example: FIRST and Three Forms of ACCUMULATE
nPath Results Example: FIRST, Three Forms of ACCUMULATE, COUNT, and NTH
nPath Results Example: Combine Values from One Row with Values from the Next Row
nPath Results Example: ACCUMULATE String over 64000 Characters
nPath Results Example: ACCUMULATE String over 64000 Characters, DISTINCT
nPath Results Example: ACCUMULATE String over 64000 Characters, CDISTINCT
nPath Results Example: Hindi Input, ACCUMULATE FIRST_NOTNULL
nPath Results Example: Hindi Input, ACCUMULATE DISTINCT and CDISTINCT
nPath Examples
Symbols and Symbol Predicates That Examples Use
nPath ClickStream Data Examples
nPath Range-Matching Examples
nPath Range-Matching Example: Accumulate Pages Visited in Each Session
nPath Range-Matching Example: Find Sessions That Start at Home Page and Visit Page1
nPath Range-Matching Example: Find Paths to Checkout Page for Purchases Over $200
nPath Range-Matching Example: Use OVERLAPPING Mode
nPath Range-Matching Example: Find First Product with Multiple Referrers in Any Session
nPath Range-Matching Example: Find Data for Sessions That Checked Out 3-6 Products
nPath Range-Matching Example: Find Data for Sessions That Checked Out at Least 3 Products
nPath Range-Matching Example: Multiple Partitioned Input Tables and Dimension Input Table
Sessionize
Sessionize Syntax
Required Syntax Elements for Sessionize
Optional Syntax Elements for Sessionize
Sessionize Input
Sessionize Output
Example: How to Use Sessionize
How to Read Syntax
Additional Information
Teradata Links
Related Documentation
ModelType
Specifies the model type for the KNN function.
Accepted Values: Regression, Classification, or Neighbors.
Default Value: Classification
K
Specifies the number of nearest neighbors to use in the algorithm. Select any positive integer value greater than 0 or less than or equal to 100.
Default Value: 5
Accumulate
Specifies the test table column names to copy to the output table.
ResponseColumn
[For the Regression or Classification model type] Specifies the training table column name that contains the numeric response variable values used for prediction in KNN-based regression or classification.
The class labels under the Response column must be numeric.
Invalid for the Neighbors model type.
VotingWeight
[For the Regression or Classification model type] Specifies the voting weight of the training object to determine the test object class as a function of the distance between the training and the test object.
The weighted voting score is calculated as w=1/power(distance, voting_weight), where distance is the distance between the test object and the training object. The voting_weight value must be a non-negative real number.
Default Value: 0
Tolerance
Specifies the tolerance value to define the smallest distance.
The weight (w=1/POWER(distance, voting_weight)) is undefined if the distance is zero and a non-zero voting_weight is used.
For any distance less than the specified tolerance, the weight is calculated as w=1/POWER(tolerance, voting_weight).
Default Value: 0.0000001
OutputProb
[For the Classification model type] Specifies whether you want to return the probability of each response specified in the Responses argument. If the Responses argument is not specified, then the function returns the probability of the predicted response when it is set to True.
Default Value: False
Invalid for the Regression or the Neighbors model type
Responses
[When the OutputProb argument is true] Specifies the class labels for returning probabilities. The class labels are transformed to integer values only.
The maximum value is 1000.
EmitNeighbors
[For the Classification or Regression model type] Specifies whether to display neighbors in the output. The default value is true for the Neighbors model type, or you can manually set the value to true. However, you cannot set the value to false for the Neighbors model type.
The default value for the Classification or the Regression model type is false.
EmitDistances
Specifies whether to display the neighbor distances in the output.
Default value: False