sqoop imoprt
LearnoMate Technologies > sqoop imoprt
Sqoop Command with Secure Password
05
Jun
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 […]
Exclude parameter in SQOOP to exclude import tables
05
Jun
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 | […]