Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. 7. Makeconnection from sqoop to MySQL
  2. sqoop/bin>
  3. sqoop list-databases --connect jdbc:mysql://localhost/
  4. --username sqoop --password 12345678
  5.  
  6. sqoop/bin>
  7. sqoop import --connect jdbc:mysql://localhost/dbjpkn--table usermaster
  8. --username sqoop --password 12345678 --hive-import --fields-terminated-by ","
  9.  
  10. 8. check if data had been imported to hadoop [NOTE : user/Krishnan/usermaster need to check on indiviual pc]
  11. hadoop fs -cat /user/Krishnan/usermaster/part*
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement