Sqoop (MySQL->HBase): com.mysql.jdbc.PreparedStatement.isClosed()Z?
Posted by: Rizwan Mian
Date: April 11, 2014 01:36PM

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

Options: ReplyQuote

Written By
Sqoop (MySQL->HBase): com.mysql.jdbc.PreparedStatement.isClosed()Z?
April 11, 2014 01:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.