Powerpivot - Teradata Query - Error 3932

Third Party Software
Visitor

Powerpivot - Teradata Query - Error 3932

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

  • powerpivot
  • volatile table