1.0 - 8.00 - URIPack Example - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

SQL Call

SELECT * FROM URIPack (
  ON uripack_input
  USING
  Queries ('p1', 'p2', 'p3')
  Accumulate ('id')
  SchemeColumn ('scheme')
  HostColumn ('host')
  PathColumn ('path')
  FragmentColumn ('fragment')
  IgnoreValues ('null', '192.0.2.16')
) AS dt ORDER BY id;

Output

id URI
1 https://www.sample.com/webhp?p1=chrome&p2=hello+world&p3=UTF-8#fragment1
2 http://www.ietf.org/rfc/rfc2396.txt
3 ldap://[2001:db8::7]/c=GB
4 telnet:///
5 http://www.bar.com/baz/foo?p1=netscape&p2=%7Bhello+world%7D&p3=UTF#This+is+fragment+too