从 Teradata 表导出到 CSV [英] Export From Teradata Table to CSV

问题描述

是否可以将 Teradata 表中的日期直接传输到 .csv 文件中.问题是 - 我的表有超过 1800 万行.如果是，请告诉我过程

Is it possible to transfer the date from the Teradata Table into .csv file directly. Problem is - my table has more that 18 million rows. If yes, please send tell me the process

推荐答案

对于这么大的表，我建议使用 FastExport 实用程序.它本身不支持 CSV 导出，但您可以模仿该行为.

For a table that size I would suggest using the FastExport utility. It does not natively support a CSV export but you can mimic the behavior.

Teradata SQL Assistant 将导出为 CSV，但不适用于该大小的表.

Teradata SQL Assistant will export to a CSV but it would not be appropriate to use with a table of that size.

BTEQ 是另一种替代方案，对于一次性转储，如果表是可以接受的.

BTEQ is another alternative that may be acceptable for a one-time dump if the table.

您可以访问其中任何一个吗?

Do you have access to any of these?

这篇关于从 Teradata 表导出到 CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！