All Forums Connectivity
tanzir 1 post Joined 08/14
01 Sep 2014
Teradata Hadoop Connector (HDP 1.3.3) - Schema definition is invalid

Hello everyone,
This is the first time I'm trying to use Teradata Hadoop connector for Hortonworks Distribution (HDP 1.3.3) but looks like I'm missing something. I tried with 2 different versions of connector but both of the time I'm getting the same error "Schema definition is invalid" from the method: com.teradata.hadoop.utils.TeradataSchemaUtils.setupOut putSchema. Can anyone please tell me what I'm doing wrong here? Any information will be highly appreciated.
Here is the complete log:

14/09/01 20:39:06 INFO mapreduce.TeradataOutputProcessor: job setup ends at 1409629146472

14/09/01 20:39:06 INFO mapreduce.TeradataOutputProcessor: job setup time is 1s

14/09/01 20:39:06 ERROR teradata.TeradataSqoopExportJob: Exception running Teradata export job

com.teradata.hadoop.exception.TeradataHadoopSchemaExce ption: Schema definition is invalid

        at com.teradata.hadoop.utils.TeradataSchemaUtils.setupOut putSchema(

        at com.teradata.hadoop.mapreduce.TeradataOutputProcessor. setupSchemaMapping(

        at com.teradata.hadoop.mapreduce.TeradataBatchInsertOutpu tProcessor.setupSchemaMapping(TeradataBatchInsertOutpu

        at com.teradata.hadoop.mapreduce.TeradataOutputProcessor. setup(

        at com.teradata.hadoop.mapreduce.TeradataBatchInsertOutpu tProcessor.setup(TeradataBatchInsertOutputProcessor.ja va:60)

        at com.teradata.hadoop.job.TeradataHdfsFileExportJob.runJ ob(

        at com.teradata.hadoop.tool.TeradataJobRunner.runExportJo b(

        at org.apache.sqoop.teradata.TeradataSqoopExportJob.doSub mitJob(

        at org.apache.sqoop.mapreduce.ExportJobBase.runJob(Export

        at org.apache.sqoop.mapreduce.ExportJobBase.runExport(Exp

        at org.apache.sqoop.teradata.TeradataConnManager.exportTa ble(

        at org.apache.sqoop.tool.ExportTool.exportTable(ExportToo

        at 100)


        at 65)

        at org.apache.sqoop.Sqoop.runSqoop(

        at org.apache.sqoop.Sqoop.runTool(

        at org.apache.sqoop.Sqoop.runTool(

        at org.apache.sqoop.Sqoop.main(

14/09/01 20:39:06 INFO teradata.TeradataSqoopExportJob: Teradata export Job completed with exit code 1

14/09/01 20:39:06 ERROR tool.ExportTool: Encountered IOException running export job: Exception running Teradata export job



Thanks in advance.


mohan.indugula 1 post Joined 07/12
24 Nov 2015

Can you share Sqoop Code.

You must sign in to leave a comment.