1.1 - 8.10 - Data Preparation and Transformation - 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)
Function Description
Antiselect_MLE (ML Engine) Returns all columns except those specified.
ApacheLogParser (ML Engine) Parses Apache log file content and extracts multiple columns of structural information, including search engines and search terms.
ConvertToCategorical (ML Engine) Converts specified columns from any numeric type to VARCHAR.
IPGeo (ML Engine) Maps IP addresses to information that you can use to identify the geographical location of a visitor.
JSONParser (ML Engine) Extracts the element name and text from JSON strings and outputs them in a flattened relational table.
MultiCaseMatch (ML Engine) 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 (ML Engine) Computes the hash value of the input columns.
OutlierFilter (ML Engine) Removes outliers from a data set.
Pack_MLE (ML Engine) Concatenates data in multiple columns into a single packed data column.
Pivoting (ML Engine) Converts rows into columns.
RandomSample (ML Engine) Takes a data set and uses a specified sampling method to output one or more random samples, each with a specified size.
Sampling (ML Engine) Draws rows randomly from input, using either of two sampling schemes.
Unpack_MLE (ML Engine) Splits data from a single packed column to multiple unpacked columns, using a specified delimiter.
Unpivoting (ML Engine) Converts columns into rows.
URIPack (ML Engine) Reconstructs encoded hierarchical uniform resource identifier (URI) strings that were unpacked by the URIUnpack function.
URIUnpack (ML Engine) Separates hierarchical URIs into constituent components and extracts the values of specified parameters.
XMLParser (ML Engine) Extracts data from XML documents and stores it in a relational table.
XMLRelation (ML Engine) Extracts element name, text and attribute values, and structural information from XML documents and outputs them in a relational table.
Geometry Functions (ML Engine) 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.
Scale Functions (ML Engine) Normalize input data sets.