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 |