Spool space in insert statement

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Spool space in insert statement

Hi,

 

While running an insert statement in sql assistant, I am getting spool space error. 

For eg:- 

Insert into table a

select * from table b;

But while running only "select * from table b" it gives me result. As per my understanding if "Insert" giving spool space error then "select" should also give the same result.

Can you please explain and provide the solution?

 

1 REPLY
Junior Contributor

Re: Spool space in insert statement

This is usually caused by a bad Primary Index of the target table, e.g. no PI in Create Table, which defaults to 1st column.