Dear Friends,
Objective: Sqoop MySQL data into HBase
Problem: When I execute a simple Sqoop statement in my cloudera 5 cluster, I get the following error:
14/04/11 16:51:08 INFO mapreduce.Job: Running job: job_1397164121655_0005
14/04/11 16:51:17 INFO mapreduce.Job: Job job_1397164121655_0005 running in uber mode : false
14/04/11 16:51:17 INFO mapreduce.Job: map 0% reduce 0%
14/04/11 16:51:27 INFO mapreduce.Job: Task Id : attempt_1397164121655_0005_m_000000_0, Status : FAILED
Error: com.mysql.jdbc.PreparedStatement.isClosed()Z
...
14/04/11 16:51:52 INFO mapreduce.Job: Job job_1397164121655_0005 failed with state FAILED due to: Task failed task_1397164121655_0005_m_000000
Job failed as tasks failed. failedMaps:1 failedReduces:0
I am following the simple HBase tutorial by Gulati [1]. I wonder if anybody can help me problem please? Is Sqoop misconfigured? Am I missing a jar?
Description: I installed cloudera 5 [2] on five VMs, with all its parcels and software packages.
- All services are in good health as shown by cloudera manager
- I am able to execute Wordcount in the cluster to ensure MapReduce is functioning
- I have written a simple jdbc program that uses the same jdbc driver as cloudera to retrieve the contents of the database table in MySQL to ensure there are not any permission issue or driver issue
Note, exactly the same setup works in cloudera 4.4 and the sqoop successfully retrieves the data.
[1]
http://souravgulati.webs.com/apps/forums/topics/show/8680714-sqoop-import-data-from-mysql-to-hbase
[2]
http://archive.cloudera.com/cm5/installer/latest/cloudera-manager-installer.bin
--
Rizwan Mian
Doctoral Candidate
Computer Science
Queens University
http://ca.linkedin.com/in/rizwanmian