After extraction of 10,00000 rows query giving 'Out of memory' error

Database

After extraction of 10,00000 rows query giving 'Out of memory' error

Hi All,

I am facing this issue, please help me out with this:

I am executing a query, it gets executed for 1.5 hrs and after extraction of 10,00000 rows out of 13,00000 it displays 'Out of memory error'. and in history it shows only 17 secs of execution.

I am using Teradata SQL assistant for the execution of this query, i am not sure as to why i am getting this error.

1 REPLY
Enthusiast

Re: After extraction of 10,00000 rows query giving 'Out of memory' error

Hi,

It has been discussed before on another thread, there is a limit of data that can be seen using SQLA, after the consuming that much memmory, the SQLA fails to handle the large amounts of data. You can get some thousand rosw and analyse, else use export option of SQLA, or fast export and then you can see that file. 

Khurram