1.0 - 8.00 - Data Transformation - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
May 2019
Content Type
Programming Reference
Publication ID
English (United States)
Function Description
AntiSelect Returns all columns except those specified.
ApacheLogParser Parses Apache log file content and extracts multiple columns of structural information, including search engines and search terms.
ConvertToCategorical Converts specified columns from any numeric type to VARCHAR.
Fellegi-Sunter Functions FellegiSunter estimates the parameters of the Fellegi-Sunter model, using either supervised or unsupervised learning. FellegiSunterPredict predicts whether a pair of objects are duplicates.
Geometry Functions GeometryOverlay finds result of overlaying two geometries. PointInPolygon computes list of binary values for every point and polygon combination, which indicate whether point is contained in polygon.
IdentityMatch Tries to match enterprise customers with users records provided by external data sources.
IPGeo Maps IP addresses to information that you can use to identify the geographical location of a visitor.
JSONParser Extracts the element name and text from JSON strings and outputs them in a flattened relational table.
MultiCaseMatch Extends the capability of the SQL CASE statement by supporting matches to multiple options and iterating through the input data set only once, emitting matches as they occur.
MurmurHash Computes the hash value of the input columns.
OutlierFilter Removes outliers from a data set.
Pack Compresses data in multiple columns into a single packed data column.
Pivoting Converts rows into columns.
Scale Functions Normalize input data sets.
StringSimilarity Calculates the similarity between two strings, using either the Jaro, Jaro-Winkler, N-Gram, or Levenshtein distance.
Unpack Expands data from a single packed column to multiple unpacked columns.
Unpivoting Converts columns into rows.
URIPack Reconstructs encoded hierarchical uniform resource identifier (URI) strings that were unpacked by the URIUnpack function.
URIUnpack Separates hierarchical URIs into constituent components and extracts the values of specified parameters.
XMLParser Extracts data from XML documents and stores it in a relational table.
XMLRelation Extracts element name, text and attribute values, and structural information from XML documents and outputs them in a relational table.