I have a query regarding a piece of code that generates an automated report in Teradata.
PROC SQL;
&connect_db
execute (
CREATE TABLE table1 AS
(
SELECT a.x1, a.x2, a.x3, b.y1
FROM PreviousTable a LEFT JOIN DailyTable b
ON a.acct_id = b.acct_id
WHERE b.acct_ind =1 AND
b.date <= a.date
)
WITH DATA;
) by db;
QUIT;
So in the above query throws Exception criteria exceeded : CPU Time. Could you help me understand how we change this CPU time error