Example Query - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
SELECT * FROM Sessionize (ON td2 USING TimeCol('eventinfo') timeout(30))
AS J1;

CREATE SET TABLE UT1.td2 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
     guid INTEGER,
     payload VARCHAR(2048) CHARACTER SET LATIN NOT CASESPECIFIC,
     eventinfo TIMESTAMP(6))
;

SELECT guid, sessionid FROM Sessionize (ON td2 USING 
TimeCol('eventinfo') timeout(30)) AS J1;

*** Query completed. 5 rows found.

       GUID    SessionID
-----------  -----------
         33            1
         33            2
         33            2
         33            2
         33            3

SELECT * FROM td2;

*** Query completed. 5 rows found.

       guid  payload                         eventinfo
-----------  ------------------------------  ---------
         33  http://dougfy.wikidot.com/debu  2013-06-09 20:21:44.000000
         33  http://dougfy.wikidot.com/debu  2013-06-10 19:08:55.000000
         33  http://dougfy.wikidot.com/debu  2013-06-10 19:09:01.000000
         33  http://dougfy.wikidot.com/debu  2013-06-10 19:09:04.000000
         33  http://dougfy.wikidot.com/debu  2013-06-10 19:09:41.000000