Created 06-27-2018 09:29 AM
I am working with sqoop, I can import and export data from mysql to hive or hbase with the command:
sqoop import \ |
--connect "jdbc:mysql://localhost:3306/retail_db" \ |
--username=retail_dba \ |
--password=password \ |
--table departments \ |
--as-sequencefile \ |
--target-dir=/user/departments |
It work fine for me.
Now I am trying to import and export from diffrent machine (my friend's machine)what I have to do.
Thanks
Created 06-27-2018 02:58 PM
You have to use his port number and his location(address) of mysql
--connect jdbc:mysql://address/portnumber
Created 06-27-2018 11:28 PM
First you have to ensure that mysql host is reachable from your host you are operating the sqoop command
HTH