Using below statement I am able to download 1 million records. But not getting how can i download 200+ millions records from the teradata table into pipe separated text file.
Below is the code that I am currently using.
.export reset
.set width 1048575
.SET RECORDMODE OFF
.SET FORMAT OFF
.SET SEPARATOR "|"
.export report file=test_file.txt
select * from test_schema.test_table
I found this link and understood that teradata could have some limitation on this. But I am sure there must be some other ways to download this large data set. Can you please share some examples on how can i do that?
Thanks.