Reply
Highlighted
Expert Contributor
Posts: 69
Registered: ‎11-24-2017

Cloudera Connector powered by Teradata - Avro file format

[ Edited ]

 

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?

 

Expert Contributor
Posts: 69
Registered: ‎11-24-2017

Re: Cloudera Connector powered by Teradata - Avro file format

Any feedback from Cloudera guys?

Expert Contributor
Posts: 69
Registered: ‎11-24-2017

Re: Cloudera Connector powered by Teradata - Avro file format

up!

 

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

Announcements