Guest User

Untitled

a guest
Dec 14th, 2017
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. MYSQL : mysql -u root -p
  2. LOGIN AS HDFS : su -hdfs
  3. CHMOD : hdfs dfs -chown -R root:hdfs /user/root
  4. sqoop list-databases \
  5. --connect "jdbc:mysql://sandbox.hortonworks.com:3306" \
  6. --username root \
  7. --password hadoop
  8.  
  9. sqoop list-tables \
  10. --connect "jdbc:mysql://sandbox.hortonworks.com:3306/ranger" \
  11. --username root \
  12. --password hadoop
  13.  
  14. sqoop eval \
  15. --connect "jdbc:mysql://sandbox.hortonworks.com:3306/ranger" \
  16. --username root \
  17. --password hadoop \
  18. --query "select count(1) from x_service"
  19.  
  20. #NOT WORKING for Second Time:
  21. sqoop import \
  22. --connect "jdbc:mysql://sandbox.hortonworks.com:3306/ranger" \
  23. --driver com.mysql.jdbc.Driver \
  24. --username root \
  25. --password hadoop \
  26. --table x_service \
  27. --as-textfile \
  28. --target-dir /home/hdfs/inbound/xservice2
  29.  
  30.  
  31. sqoop import-all-tables \
  32. --connect "jdbc:mysql://sandbox.hortonworks.com:3306/ranger" \
  33. --driver com.mysql.jdbc.Driver \
  34. --username root \
  35. --password hadoop \
  36. --warehouse-dir /home/hdfs/inbound
  37.  
  38. hadoop fs -ls /home/hdfs/inbound
Add Comment
Please, Sign In to add comment