sqoop imoprt

Sqoop Command with Secure Password

There are different way to secure sqoop password. following are the different method to secure sqoop password while running script. 1. Use — password Option with Sqoop Command $sqoop import –connect jdbc:mysql://localhost/MYDB \ –username testuser \ –password **** \ –table EMPLOYEE 2. Use — P Option with Sqoop Command $sqoop import –connect jdbc:mysql://localhost/MYDB \ –username …

Sqoop Command with Secure Password Read More »

Exclude parameter in SQOOP to exclude import tables

Exclude parameter is useful to exclude the tables from sqoop export operation. exclude parameter work with import-all-tables parameter. here import-all-tables will import all tables but exclude the tables in exclude list. STEP 1. Check the no of tables in mysql database. mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | company | | student | …

Exclude parameter in SQOOP to exclude import tables Read More »