Python for Machine Learning - Live Instructor-led Training Enroll For Free

FAQ

Frequently Asked Questions and Answers

How to access Sqoop in CloudxLab?

Please use the syntax given below to access Sqoop after logging into CloudxLab web console.

  • Sqoop List Databases

    sqoop list-databases --connect "jdbc:mysql://mysql_host:3306" --username mysql_user_name -P
    

    Enter mysql_password when prompted. You can find mysql_host, mysql_user_name and mysql_password inside "MySQL Credentials" section under "My Lab".

    Some thing like this command should work

    sqoop list-databases --connect "jdbc:mysql://ip-172-31-13-154:3306" --username sqoopuser -P
    
  • Sqoop Import

    Lets say your username is john8204 and you want to import orders table from retail_db database into retail_db_orders directory inside your home directory in HDFS. Please run below command

    sqoop import --connect "jdbc:mysql://ip-172-31-13-154:3306/retail_db" --table orders --username=sqoopuser -P --target-dir /user/john8204/retail_db_orders
    

You can also go through below videos on Sqoop from our partners