Sqoop Import From Teradata to HDFS Only Imports Distinctive Records With "--query" Option
(Doc ID 1628463.1)
Last updated on FEBRUARY 25, 2014
Applies to:Big Data Appliance Integrated Software - Version 2.2.1 and later
Sqoop import tool along with Teradata Connector to import data from Teradata to HDFS with "--query" option for a SELECT statement, it only imports the distinctive records.
In other words, the imported data in HDFS contains less records than the original data in Teradata if duplicates exists. The query "SELECT ... " statement has the same effect as "SELECT DISTINCT..." statement.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!