Configure and Start Apache Sqoop

Before you can upgrade Apache Sqoop, you must have first upgraded your HDP components to the latest version (in this case, 2.3.6). This section assumes that you have already upgraded your components for HDP 2.3.6. If you have not already completed these steps, return to Getting Ready to Upgrade and Upgrade 2.1 Components for instructions on how to upgrade your HDP components to 2.3.6.

	Note
	The `su` commands in this section use keywords to represent the Service user. For example, "hdfs" is used to represent the HDFS Service user. If you are using another name for your Service users, you will need to substitute your Service user name in each of the `su` commands.

Replace your configuration after upgrading. Copy /etc/sqoop/conf from the template to the conf directory in sqoop hosts.

As the HDFS Service user, upload the Sqoop tarball to HDFS.

su - hdfs -c “hdfs dfs -mkdir -p /hdp/apps/2.3.6.0-$BUILD/sqoop" 
                
su - hdfs -c "hdfs dfs -chmod -R 555 /hdp/apps/2.3.6.0-$BUILD/sqoop" 

su - hdfs -c "hdfs dfs -chown -R hdfs:hadoop /hdp/apps/2.3.6.0-$BUILD/sqoop" 

su - hdfs -c "hdfs dfs -put /usr/hdp/2.3-$BUILD/sqoop/sqoop.tar.gz /hdp/apps/2.3.6.0-$BUILD/sqoop/sqoop.tar.gz" 

su - hdfs -c "hdfs dfs -chmod 444 /hdp/apps/2.3.6.0-$BUILD/sqoop/sqoop.tar.gz"

If you are using the MySQL database as a source or target, then the MySQL connector jar must be updated to 5.1.29 or later.
Refer to the MySQL web site for information on updating the MySQL connector jar.
Because Sqoop is a client tool with no server component, you will need to run your own jobs to validate the upgrade.

​Configure and Start Apache Sqoop

Configure and Start Apache Sqoop