Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

sqoop export error,not found org/apache/hadoop/hive/metastore/IMetaStoreClient

avatar
New Contributor

[root@hadoop01 ~]# /usr/bin/sqoop export --connect jdbc:mysql://192.168.52.150:3306/scrm_bi --username root --password 123456 --table consult_dws --hcatalog-database itcast_dws --hcatalog-table consult_dws
22/06/04 19:01:10 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7-cdh6.2.1
22/06/04 19:01:10 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/IMetaStoreClient
at org.apache.sqoop.tool.BaseSqoopTool.validateHCatalogOptions(BaseSqoopTool.java:1743)
at org.apache.sqoop.tool.ExportTool.validateOptions(ExportTool.java:394)
at org.apache.sqoop.Sqoop.run(Sqoop.java:136)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:182)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:233)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:242)
at org.apache.sqoop.Sqoop.main(Sqoop.java:251)
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.metastore.IMetaStoreClient
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 8 more

 

This sqoop export command can be used normally last week, but it keeps getting an error today, how can I solve this problem?

 

1 REPLY 1

avatar
Master Mentor

@FLYs 

Can you have a look at this solution it could be a classpath issue.
Sqoop error