Start MySQL prompt:
(you will have to specify password)
mysql -h 10.142.1.2 -u sqoopuser -pNHkkP876rp
On mysql prompt, take a look at data:
use sqoopex
select * from widgets
Delete the folder if exists in HDFS:
hadoop fs -rmr widgets
Run the following to import:
sqoop import --connect jdbc:mysql://10.142.1.2/sqoopex --table widgets -m 2 --username sqoopuser --password NHkkP876rp --split-by id
Check the content of the imported File:
hadoop fs -cat widgets/part-m-*
NOTE: The mysql host used used in video is old. Please use the most recent host listed in "My Lab".
Loading comments...