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] [3932] 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;
SELECT * FROM CGCC;
DROP TABLE CGCC
[Teradata Database] [3932] 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;
SELECT * FROM CGCC;
DROP TABLE CGCC