Sqoop Import From Teradata to HDFS Only Imports Distinctive Records With "--query" Option
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms