Input
Input table is banking_web_clicks (see nPath Results Example: ACCUMULATE String over 64000 Characters).
SQL Call
SELECT * FROM nPath ( ON banking_web_clicks PARTITION BY session_id ORDER BY datestamp USING Mode (NONOVERLAPPING) Pattern ('A*') Symbols (TRUE AS A) Result ( FIRST (session_id OF A) AS session_id, ACCUMULATE (100000)(CDISTINCT page OF A) AS path ) ) AS dt;
Output
Because ACCUMULATE specifies a size greater than 64000, the data type of the path column is CLOB. The length of the value of path is 82887.
session_id | path |
---|---|
1 | [ONLINE STATEMENT ENROLLMENT, CUSTOMER SUPPORT, ACCOUNT HISTORY, VIEW DEPOSIT DETAILS, PROFILE UPDATE, FREQUENTLY ASKED QUESTIONS, FUNDS TRANSFER, ACCOUNT HISTORY, ONLINE STATEMENT ENROLLMENT, BANK STATEMENT, COMPLAINTS, BANK STATEMENT, ACCOUNT SUMMARY, COMPLAINTS, FUNDS TRANSFER, … , BANK STATEMENT, CUSTOMER SUPPORT] |