0 - 5 of 5 tags for spool space error

What could be the cause of this?
I have the following two queries with similar source views and joins:
FIRST QUERY
The first one has more columns projected but is not returning a spool space issue: (EXPLAIN plan provided below - 5 steps)
SEL      D.PrimaryIndex

I am getting spool space error while trying to join 3-5 views that are accessing same underlying tables.
Teradata optimizer is using the intermediate spool result in stead of the actual view output while joining. As a result, it is using much more data which would otherwise be filtered out in the join conditions inside view definiton.

Hi,
 
Im running with the spool space error when im trying to insert into a table based on the selection i do on the join of a fact and few other dimension tables.
Following are the details:
 
1.      Problem Description

Hi All,
 
When I tried to run the belong query it showed a spool space issue. However, I am able to run the select part. I have collected all the stats that are required and tried but no use. When gone through the explain plan it shows 15minutes to merge all-AMPs into Target table. Please help me in this.
Query:-

Hi All !!!

In Teradata 12, collect statistics step fails with spool space error for the below mentioned table. Skewness of the table is under the acceptable range. PFB the table structure and collect statistics step:

CREATE SET TABLE DB_1.TABLE_1, NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
(
COL_A DECIMAL(11,0)
, COL_B CHAR(3)