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