-1

I am trying to export a SQL query with Teradata SQLA. My query returns 15 millions of lines. The output files is too big to be used after.

I want to split in several files the output of the query and in the fastest way.

Best regards,

Jouvzer

marc_s
  • 675,133
  • 158
  • 1,253
  • 1,388
Jouvzer
  • 55
  • 4
  • 2
    Don't use SQLA to export millions of rows, it will take forever. Use Fast Export or TPT. I don't know if there is a way with either of those to split your output into multiple files. What are you trying to do that a 15 million row file is too big? – Andrew May 28 '21 at 13:20
  • TPT allows multiple instances of FileWriter (Data Connector Consumer) operator to write multiple files in parallel. Add the -C option on the command line so the files will be roughly equal size. – Fred May 28 '21 at 17:47

0 Answers0