Antiselect
|
Returns all columns except those specified. |
Apache_Log_Parser
|
Parses Apache log file content and extracts multiple columns of structural information, including search engines and search terms. |
Categorize
|
Converts specified columns from any numeric type to VARCHAR. |
Fellegi-Sunter Functions
|
FellegiSunterTrainer 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
|
GeometryLoader retrieves file-based geospatial files from AFS, parses them, and stores them in Aster Database. GeometryOverlay calculates the result of overlaying two geometries as specified by the overlay operator. PointInPolygon takes as input a list of location points and a list of polygons and returns a list of binary values for every point-and-polygon combination, which indicates whether the point is contained in the 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. |
Multi_Case
|
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. |
Pivot
|
Converts rows into columns. |
PSTParserAFS
|
Parses Personal Storage Table (PST) files that store email in Microsoft software such as Microsoft Outlook and Microsoft Exchange Client. |
Scale Functions
|
Normalize input data sets. The Scale functions are ScaleMap, Scale, ScalePrinter
, and
PartitionScale. |
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. |
Unpivot
|
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 flattens it into a relational table. |
XMLRelation
|
Extracts element name, text and attribute values, and structural information from XML documents and output them in a relational table. |