URIPack Example - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.