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
Linux x86-64

Symptoms

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.



Cause

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