To get information on commands available with respect to list-tables command sqoop help list-tables Command to get list of tables in a database sqoop list-tables –connect jdbc:sqlserver://hostname:port/database_name –username your_username –p Example: sqoop list-tables –connect jdbc:mysql://ms.itversity.com:3306/retail_db –username retail_user -p -P in the above command will prompt for the password.
To get references with respect to list-databases command Sqoop help list-databases Command to get the list of databases sqoop list-databases –connect jdbc:sqlserver://hostname –username your_username –password your_password Example: sqoop list-databases –connect jdbc:mysql ://ms.itversity.com –username retail_user –password itversity
To get information on all high level sqoop commands available for usage sqoop help To get the version of the sqoop installed. sqoop version To get information on a particular command use sqoop help COMMAND Example: sqoop help eval
Sqoop uses the corresponding JDBC Jar file to connect to a respective remote database. To connect to MySql, Sqoop refers for JDBC Jar file in location: /usr/hdp/2.6.5.0-292/sqoop/Iib/mysqI-connector-java.jar Command to check for JDBC jar file ls -ltr /usr/hdp/2.6.5.0-292/sqoop/Iib/mysqI-connector-java.jar
To connect to MySql server mysql -u Username -h Hostname -p mysql -u retail_user -h ms.itversity.com -p To get all databases available in MySql server SHOW databases; To connect to retail database USE retail_db; To get all tables in database SHOW tables; To get first 10 rows from orders table. SELECT * FROM orders LIMIT …
Sqoop is an open-source data transfer tool used to efficiently transfer large volumes of data between big-data cluster and relational databases. Refer to Apache Sqoop Documentation Here.
