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