Teradata Query - Error 3932

Anything related to PowerPivot and DAX Formuale
nunz2
Posts: 1
Joined: Tue Jan 10, 2017 12:12 am

Teradata Query - Error 3932

Postby nunz2 » Tue Jan 10, 2017 12:17 am

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

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest