I encountered error 3610 when running the code below
CREATE VOLATILE MULTISET TABLE table1 AS (
-- XMLAGG(COBR) (VARCHAR(1000)) AS COBRS,
-- XMLAGG(EXPE_LEVEL1) (VARCHAR(1000)) AS EXPE_LEVEL1S,
-- XMLAGG(SESS_SOURCE) (VARCHAR(1000)) AS SESS_SOURCES,
COUNT(QT) OVER (PARTITION BY GID, SESS_SKEY, SESS_START_DT, EP_UID, CNL_ID, SITE) AS CNT_QT
GROUP BY 1, 2, 3, 4, 5, 6, 7
) WITH DATA PRIMARY INDEX (SITE_ID, GUID, SESSION_SKEY, SESSION_START_DT) ON COMMIT PRESERVE ROWS;
When I delete the three rows in bold, the query runs fine, but when I keep them I met error 3610. I have checked that the teradata version of mine supports function xmlagg, and it works fine in the test code below:
XMLAGG(COBR) (VARCHAR(10000)) AS COBRS,
GROUP BY 1, 2, 3, 4, 5;
I am not sure how to revise my code to achieve the same result. Can anyone help me with it? Thanks!
Solved! Go to Solution.
Thanks for your answer. I know I cannot fix a 3610 error, but do you know how I can revise my query to achieve the same result?