1.1 - 8.10 - URIPack Example - 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)

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

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.