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.
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.