Need help with Hadoop lab

profileArrow1993

Import the Device table from MySQL 

1. Open a new terminal window if necessary. 

2. Get familiar with Sqoop by running the sqoop command line

 $Sqoop help

3. List the table in Loudacre database:

 $ sqoop list-tables \

   --connect jdbc:mysql://localhost/loudacre \ 

   --username training --password training 

4. Run the sqoop import command to see its options: 

 $ sqoop import --help 

5. *Use Sqoop to import the device table in the loudacre database and save it in HDFS under /loudacre:

    • 6 years ago
    • 10
    Answer(0)