Hi Team,

I am using the below sqoop command to export hive table with ORC file format to 
Teradata.

sqoop export  -D mapred.job.queue.name="everest" 
-Dsqoop.export.records.per.statement=1 --connect  
"jdbc:teradata://24.40.61.160/DATABASE=NDW_HADOOP_JRNL_TABLES,SESSIONS=30,COP=ON,TCP=RECEIVE65536"
 --driver com.teradata.jdbc.TeraDriver --username HADOOP_JRNL_LOAD --password 
HADOOpjrnl032015  --table NDW_HADOOP_JRNL_TABLES.CUSTOMERS --hcatalog-table 
customers;

but the error is:

Exception in thread "main" java.lang.NoClassDefFoundError: 
org/apache/hive/hcatalog/mapreduce/HCatOutputFormat
        at 
org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:405)
        at org.apache.sqoop.manager.SqlManager.exportTable(SqlManager.java:904)
        at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:81)
        at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Caused by: java.lang.ClassNotFoundException: 
org.apache.hive.hcatalog.mapreduce.HCatOutputFormat
        at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

Could you please help me out in resolving the issue.

Thanks & Regards,
Sagar

Reply via email to