How to use sqoop import

Question

Hi.

I have created a sql database and table and I have inserted values in the table. Now I want to import this in sqoop. I have successfully installed sql connector. I want to know what code to use to import sql in sqoop.

Answer 1

Here is an example of import command. Replace the values with your respective parameters:

bin/sqoop import --connect jdbc:mysql://192.168.243.1/sample --table Employee --username root -P --target-dir /sqoopOut1 -m 1