After I executed a query it returned 200,000 records and asked if I wanted a sample and clicked the "No" button. Shortly after, I received the following error message:
I guess you are running this query from SQLA. Basically SQLA is used to analyze sample data and build queries on it. When you try to display large amounts of data, this error occures. This is basically a java error related to memmory handling.
If you want to see all the data you can export it. But I would suggest you to click yes when it says do you want a sample.
I clicked yes when it asked for the sample data. However, if I export the data into Excel I only receive the sample data. How do I export all the data into an Excel spreadsheet?