You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Bonthu, Sagar (Contractor)" <Sa...@cable.comcast.com> on 2015/09/21 19:43:24 UTC

Error with sqoop export using Hcatalog

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