SELECT * FROM Path_Summarizer (
ON (SELECT * FROM
Path_Generator (
ON clickstream1
SeqColumn ('path')
Delimiter (',')
)
) PARTITION BY prefix
SeqColumn ('sequence')
PrefixColumn ('prefix')
PartitionNames ('prefix')
Delimiter (',')
CountColumn ('cnt')
Hash ('false')
) ORDER BY node;