I am a new teradata user, I am getting an error when trying to xport data into a flat file from teradata table. *** Failure 3150 DQM Resource violation: Answer set size, Estimated value of 1051082348 exceeds limit of 500000000, Global Rule, Regulation applies from 00:00 to 24:00
Your DBA has set a resource limit using TDQM which prevents your from firing SQLs whose estimated result set size exceeds 500000000.
Probably "the couple of things" you tried fixed a logic error in query (may be you forgot to put some join conditions resulting in product joins and hence a larger estimated result set size) or you added some filter conditions later which resulted in fewer number of rows in the answer set.
your DBA must be able to fill in the blanks for you.