Apache Sqoop Installation Tutorial
Prerequisites
Hardware requirements:
Local machine
ram 8 gb or above
Software requirements:
VMware Workstation:, Version :16 pro
Download the software from given link :- https://prwatech.in/blog/software-installation/vmware-workstation-installation/
Ubuntu , Version: 18.04
Download the software from given link : https://prwatech.in/blog/software-installation/vmware-workstation-installation/
Programming languages: Linux
Learn Linux : https://prwatech.in/blog/linux/linux-architecture/
1.Go to the below link and download sqoop-1.4.7.bin_hadoop-6.0.tar.gz
https://mirrors.estointernet.in/apache/sqoop/1.4.7/
2.Open the terminal and go to the folder directory where sqoop has been downloaded and extract the file using the following command:
tar -xvf sqoop-1.4.7.bin_hadoop-2.6.0.tar.gz
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-219.png)
3.Edit the .bashrc file
nano ~/.bashrc
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-220.png)
Note: you can edit the sqoop file name so that it will be easy , in my case i have renamed it to “sqoop-1.4.7” from “sqoop-1.4.7.bin_hadoop-2.6.0”
4. Enter the following commands below in bashrc file
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-221.png)
5.Now save the bashrc file by source ~/.bashrc
source ~/.bashrc
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-222.png)
6.Use this command to rename sqoop-env-template.sh to sqoop-env.sh
mv sqoop-env-template.sh sqoop-env.sh
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-223.png)
7.Edit the sqoop-env.sh
nano sqoop-env.sh
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-224.png)
Add the following lines as follows
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-225.png)
8. Now download the mysql connector from the following link in terminal
wget http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-J/mysql-connector-java-8.0.22.tar.gz
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-226.png)
9.Go to the downloaded file directory and untar by running the following command
tar -xvf mysql-connector-java-8.0.22.tar.
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-227.png)
10. Move mysql connector to sqoop/lib
mv mysql-connector-java-8.0.22/mysql-connector-java-8.0.22.jar /home/user/Downloads/sqoop-1.4.7/lib
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-228.png)
11.Check the version whether it is installed
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-229.png)
12.Type ‘sqoop help’ to know the sqoop commands
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-230.png)
![](https://prwatech.in/blog/wp-content/uploads/2021/03/image-231.png)