|
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. |