Cloudera Community

Welcome to the Cloudera Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Sqoop Import into Hive - Error with configuration

avatar
author-rank Gopibala
New Contributor

Created on ‎09-10-2016 02:48 PM - edited ‎09-10-2016 02:50 PM

Hi,

 

I am trying to import data from a mysql table into hive and i am facing this error.

Could someone please help me overcome this problem?

 

I have searched for wrong version of xerces jar and don't have very old versions mixed up in my libraries.

Another post suggested to remove hsqldb jar present outside of CDH installation and that didn't help either.

I don't have core-default.xml in my system.

 

>sqoop import --connect jdbc:mysql://xxxxx:3306/gopidbp --username=hdp --password=xxxxx --table=accounts --hive-import --hive-table=default.acctcopy --target-dir=/user/root/sample -m 1 

The HIVE_HOME is /opt/cloudera/parcels/CDH/lib/hive/lib
The HIVE_CONF_DIR is /opt/cloudera/parcels/CDH/lib/hive/lib/../conf
Warning: /opt/cloudera/parcels/CDH-5.8.0-1.cdh5.8.0.p0.42/bin/../lib/sqoop/../accumulo does not exist! Accumulo impor
ts will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
16/09/10 16:38:06 FATAL conf.Configuration: error parsing conf core-default.xml
javax.xml.parsers.ParserConfigurationException: Feature 'http://apache.org/xml/features/xinclude' is not recognized.
at org.apache.xerces.jaxp.DocumentBuilderFactoryImpl.newDocumentBuilder(Unknown Source)
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2541)
at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2503)
at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2409)
at org.apache.hadoop.conf.Configuration.get(Configuration.java:982)
at org.apache.sqoop.tool.SqoopTool.loadPluginsFromConfDir(SqoopTool.java:170)
at org.apache.sqoop.tool.SqoopTool.loadPlugins(SqoopTool.java:140)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:208)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Exception in thread "main" java.lang.RuntimeException: javax.xml.parsers.ParserConfigurationException: Feature 'http://apache.org/xml/features/xinclude' is not recognized.
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2659)
at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2503)
at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2409)
at org.apache.hadoop.conf.Configuration.get(Configuration.java:982)
at org.apache.sqoop.tool.SqoopTool.loadPluginsFromConfDir(SqoopTool.java:170)
at org.apache.sqoop.tool.SqoopTool.loadPlugins(SqoopTool.java:140)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:208)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Caused by: javax.xml.parsers.ParserConfigurationException: Feature 'http://apache.org/xml/features/xinclude' is not recognized.
at org.apache.xerces.jaxp.DocumentBuilderFactoryImpl.newDocumentBuilder(Unknown Source)
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2541)

6,669
0 Kudos
4
Who agreed with this topic