222.Adding Password File

  • Command to create a password file
    • nano password_file
    • echo -n "itversity" > password_file
  • Command to evaluate data using password file
    • sqoop eval --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password-file file:///home/training/password_file -e "SELECT count(1) FROM orders"

Share this post