title: Teradata Fast export (or TPT) vs Sqoop export
body: <p><strong>Edit:</strong> Need to identify which one is better for exporting huge data volume from Teradata - Sqoop, TPT, or fexp</p>
  
  <p><strong>OP:</strong> I am already aware that teradata's fast export and TPT cannot be used to export data directly to Hadoop. I can bring data to local environment and move it to hadoop parallely.</p>
  
  <p>I want to know which tool extracts the data from Teradata in the most efficient way.</p>
  
  <p>I have to extract dataset having huge data volume (almost 25 billion records ~ 15 TB in size).
  Of course the data in Teradata is well partitioned and I am going to split my extraction strategy based on partitions and Unique PI.</p>
  
  <p>I was not able to find enough content which would provide direct comparison between Teradata utilities and Sqoop.</p>
  
  <p>Which tool would make least impact on currently running jobs in Teradata environment and extract the data in most optimized way.</p>