Data Preparation and Transformation - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.