SELECT * FROM Path_Start (
ON (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')
)
) PARTITION BY (parent)
CountColumn ('cnt')
Delimiter (',')
ParentColumn ('parent')
PartitionNames ('partitioned')
NodeColumn ('node')
) ORDER BY node;