Sqoop Eval in Big Data Hadoop

Can evaluate any type of SQL query.

sqoop eval --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root --query “select * from employee limit 3”

Insert:

sqoop eval --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root -e “insert into employee values (1107,‘chandra’,‘UI dev’,15000,‘TP’)”

List database:

sqoop list-databases --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root

List Table:

sqoop list-tables --connect jdbc:mysql://localhost:3306/db --driver com.mysql.jdbc.Driver --username root -password root