Archives of the TeradataForum
Message Posted: Thu, 10 Sep 2009 @ 12:13:17 GMT
Subj: | | Re: Export of 1 Million Rows |
|
From: | | McCall, Glenn David |
| I run a query that returns about 1 million records. Is there a better way of exporting the data? I'm currently using Teradata SQL
Assistant and copying the result set into Excel to do some analysis. | |
Another option is to create a fast export job. However you might need to fiddle with the data a bit to get it into Excel.
I guess you aren't using Excel 2003 (65,000 row limit)!
You don't mention what sort of analysis you are going to do, but have you considered doing your analysis in Teradata?
It's a great way to practice your SQL skills and it is likely your analyses will run faster. After all once you export the data into excel, you
lose the massively parallel processing capabilities. Not to mention that it takes a long time to transfer the data via ODBC.
Teradata Corporation
Glenn McCall
Canberra Australia
|