mysql - Is Apache Hadoop 2.7.1 is compatible with Apache Sqoop 1.4.6? -
i have installed apache hadoop 2.7.1 , integrate apache sqoop 1.4.6. when trying import mysql database hive using sqoop commands :
sqoop import \ --connect "jdbc:mysql://localhost:3306/assignment5" \ --username root \ --password cg \ --table emp_detail \ --fields-terminated-by ',' \ --lines-terminated-by '\n' \ --hive-home /user/hive/warehouse/assignment5.db \ --hive-import \ --hive-table emp_detail
and getting issue :
exception in thread "main" java.lang.incompatibleclasschangeerror: found interface org.apache.hadoop.mapreduce.jobcontext, class expected @ org.apache.sqoop.config.configurationhelper.getjobnummaps(configurationhelper.java:65) @ com.cloudera.sqoop.config.configurationhelper.getjobnummaps(configurationhelper.java:36) @ org.apache.sqoop.mapreduce.db.datadrivendbinputformat.getsplits(datadrivendbinputformat.java:125) @ org.apache.hadoop.mapreduce.jobsubmitter.writenewsplits(jobsubmitter.java:301) @ org.apache.hadoop.mapreduce.jobsubmitter.writesplits(jobsubmitter.java:318) @ org.apache.hadoop.mapreduce.jobsubmitter.submitjobinternal(jobsubmitter.java:196) @ org.apache.hadoop.mapreduce.job$10.run(job.java:1290) @ org.apache.hadoop.mapreduce.job$10.run(job.java:1287) @ java.security.accesscontroller.doprivileged(native method) @ javax.security.auth.subject.doas(subject.java:422) @ org.apache.hadoop.security.usergroupinformation.doas(usergroupinformation.java:1657) @ org.apache.hadoop.mapreduce.job.submit(job.java:1287) @ org.apache.hadoop.mapreduce.job.waitforcompletion(job.java:1308) @ org.apache.sqoop.mapreduce.importjobbase.dosubmitjob(importjobbase.java:196) @ org.apache.sqoop.mapreduce.importjobbase.runjob(importjobbase.java:169) @ org.apache.sqoop.mapreduce.importjobbase.runimport(importjobbase.java:266) @ org.apache.sqoop.manager.sqlmanager.importtable(sqlmanager.java:673) @ org.apache.sqoop.tool.importtool.importtable(importtool.java:497) @ org.apache.sqoop.tool.importtool.run(importtool.java:605) @ org.apache.sqoop.sqoop.run(sqoop.java:143) @ org.apache.hadoop.util.toolrunner.run(toolrunner.java:70) @ org.apache.sqoop.sqoop.runsqoop(sqoop.java:179) @ org.apache.sqoop.sqoop.runtool(sqoop.java:218) @ org.apache.sqoop.sqoop.runtool(sqoop.java:227) @ org.apache.sqoop.sqoop.main(sqoop.java:236)
could tell me issue means?
indeed seems suffering version conflicts.
answering first question compatibility. yes running
hadoop 2.7.1.2.4.0.0-169
sqoop 1.4.6.2.4.0.0-169
and work together.
trying answer second question.
i check running 2 versions by
hadoop version sqoop version
apart thing might add import sentence, (probably not related problem) specify connection driver. mysql use
--driver com.mysql.jdbc.driver
however, not sure issue related driver. there more info drivers @ sqoop page
but coming initial question compatibility. pretty sure compatible.
i rather check actual versions running on system , calls.
for more info changes on hadoop across versions can check answer.
Comments
Post a Comment