1.1 - 8.10 - URIUnpack Output - 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)

URIUnpack Output Table Schema

Column Data Type Description
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.
scheme VARCHAR [Column appears only with OutputType ('scheme')]. Scheme of URI.
host VARCHAR [Column appears only with OutputType ('host')]. Host of URI.
path VARCHAR [Column appears only with OutputType ('path')]. Path of URI.
fragment VARCHAR [Column appears only with OutputType ('fragment')]. Fragment of URI.



VARCHAR [Column appears once for each specified query_parameter.] Value of query_parameter.

Column name is query_parameter unless query_parameter is an accumulate_column, in which case column name is query_parameter_.

Key Hierarchical URI Components

The examples in the following table are from this sample URI:


Component Example
scheme https
host www.sample.com
path /webhp
query ?p1=chrome&p2=hello%20world&p3=UTF-8

A query starts with a question mark (?). An ampersand (&) precedes each query parameter. Here, the query parameters are p1, p2, and p3. Their values are chrome, hello%20world, and UTF-8, respectively. %20 represents a space character.

fragment #fragment1