I am new to Teradata, so I am trying to learn all its quirks. What I am trying to accomplish is write a temp table and then query off of it all in one statement. When I run the query below in Powerpivot I get the following error:
[Teradata Database]  Only an ET or null statement is legal after a DDL Statement.
If I run the same query in Teradata, it works if I use execute. If I use execute parallel, I get the same error. I am assuming that when it runs in parallel it is creating a circular reference. I am assuming the easiest solution would be to not run the query in parallel, but I don't see any way to accomplish this using Powerpivot. Any advise would be appreciated.
I miss using Microsoft SQL
CREATE VOLATILE TABLE CGCC ( ID INT, NAME VARCHAR(20) ) ON COMMIT PRESERVE ROWS;