1.1 - 8.10 - URIUnpack Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
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.
query_parameter

or

query_parameter_

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:

https://www.sample.com/webph?p1=chrome&p2=hello%20world&p3=UTF-8#fragment

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