Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cloudera Connector powered by Teradata - Avro file format

Highlighted

Cloudera Connector powered by Teradata - Avro file format

Expert Contributor

 

Hi everyone!

 

I am having some problems when importing data from Teradata with Avro format.

 

sqoop import  \
--connect jdbc:teradata://host/DATABASE=db \
--username usr --password pwd \
--table mytable \
--split-by CODCLI \
--target-dir /path/to/hdfs
--as-avrodatafile

It fails giving the following error:

 

18/01/26 11:00:52 ERROR util.SqlTypeMap: It seems like you are looking up a column that does not
18/01/26 11:00:52 ERROR util.SqlTypeMap: exist in the table. Please ensure that you've specified
18/01/26 11:00:52 ERROR util.SqlTypeMap: correct column names in Sqoop options.
18/01/26 11:00:52 ERROR tool.ImportTool: Import failed: column not found: CODCLI

But if I remove the --as-avrodatafile parameter it works fine. According to Cloudera documentation the import in Avro format sould be supported. Am I missing something?

 

2 REPLIES 2

Re: Cloudera Connector powered by Teradata - Avro file format

Expert Contributor

Any feedback from Cloudera guys?

Re: Cloudera Connector powered by Teradata - Avro file format

Expert Contributor

up!

 

Has anyone succesfully imported a Teradata table in avro format using the Cloudera connector?

Don't have an account?
Coming from Hortonworks? Activate your account here