New Contributor
Posts: 1
Registered: ‎08-21-2017

Sqoop2 job start failed while moving mysql data to hive using generic-jdbc-connector and kite-connec

The links and job informations :

sqoop:000> show link --name hive
1 link(s) to show:
link with name hive (Enabled: true, Created by cluster at 21/8/17 3:32 PM, Updated by cluster at 21/8/17 5:17 PM)
Using Connector kite-connector with name {1}
Global configuration
HDFS host and port:
Hadoop conf directory:
sqoop:000> show link --name mysql
1 link(s) to show:
link with name mysql (Enabled: true, Created by cluster at 18/8/17 4:17 PM, Updated by cluster at 21/8/17 3:28 PM)
Using Connector generic-jdbc-connector with name {1}
Database connection
Driver class: com.mysql.jdbc.Driver
Connection String: jdbc:mysql://
Username: root
Fetch Size:
Connection Properties:
protocol = tcp
SQL Dialect
Identifier enclose:

sqoop:000> show job --name mysql_to_hive
1 job(s) to show:
Job with name mysql_to_hive (Enabled: true, Created by cluster at 21/8/17 3:35 PM, Updated by cluster at 21/8/17 5:18 PM)
Throttling resources
Extractors: 1
Loaders: 1
Classpath configuration
Extra mapper jars:
From link: mysql
Database source
Schema name:
Table name: CustomerInvoice
SQL statement:
Column names:
Partition column: AccountNumber
Partition column nullable:
Boundary query:
Incremental read
Check column:
Last value:
To link: hive
Target configuration
Dataset URI: dataset:hive:vinodkumar/ci
File format: PARQUET
sqoop:000> start job --name mysql_to_hive

Exception in thread "main" org.apache.sqoop.common.SqoopException: CLIENT_0001:Server has returned exception
at org.apache.sqoop.client.request.ResourceRequest.doHttpRequest(
at org.apache.sqoop.client.request.ResourceRequest.put(
at org.apache.sqoop.client.request.JobResourceRequest.start(
at org.apache.sqoop.client.request.SqoopResourceRequests.startJob(
at org.apache.sqoop.client.SqoopClient.startJob(
at volumata.library.service.SqoopTest.startJob(
at volumata.library.service.SqoopTest.main(
Caused by: java.lang.NullPointerException:
at org.apache.sqoop.utils.ClassUtils.jarForClass(
at org.apache.sqoop.utils.ClassUtils.jarForClassWithClassLoader(
at org.apache.sqoop.utils.ClassUtils.jarForClass(
at org.apache.sqoop.connector.kite.KiteToInitializer.getJars(
at org.apache.sqoop.connector.kite.KiteToInitializer.getJars(
at org.apache.sqoop.driver.JobManager.addConnectorInitializerJars(
at org.apache.sqoop.driver.JobManager.createJobRequest(
at org.apache.sqoop.driver.JobManager.start(
at org.apache.sqoop.handler.JobRequestHandler.startJob(
at org.apache.sqoop.handler.JobRequestHandler.handleEvent(
at org.apache.sqoop.server.v1.JobServlet.handlePutRequest(
at org.apache.sqoop.server.SqoopProtocolServlet.doPut(
at javax.servlet.http.HttpServlet.service(
at javax.servlet.http.HttpServlet.service(
at org.eclipse.jetty.servlet.ServletHolder.handle(
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(
at org.eclipse.jetty.servlet.ServletHandler.doHandle(
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(
at org.eclipse.jetty.servlet.ServletHandler.doScope(
at org.eclipse.jetty.server.handler.ContextHandler.doScope(
at org.eclipse.jetty.server.handler.ScopedHandler.handle(
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(
at org.eclipse.jetty.server.Server.handle(
at org.eclipse.jetty.server.HttpChannel.handle(
at org.eclipse.jetty.server.HttpConnection.onFillable(
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$

Cloudera Employee
Posts: 780
Registered: ‎03-23-2015

Re: Sqoop2 job start failed while moving mysql data to hive using generic-jdbc-connector and kite-co

Sqoop2 has been deprecated since 5.9 and will be removed in CDH6. I do not recommend you dig further, but rather to switch back to Sqoop1 to import data.

Please refer to:

for details.

Our community is getting a little larger. And a lot better.

Learn More about the Cloudera and Hortonworks community merger planned for late July and early August.