# terminal 1
mysql -u retail_dba -p -D retail_db
show tables;
select * from customers;

# terminal 2

sqoop import \
--connect jdbc:mysql://localhost/retail_db \
--table customers \
--username retail_dba \
--password cloudera \
--target-dir /user/cloudera/sqoop_import_data \
-m 1

hadoop fs -ls /user/cloudera/sqoop_import_data

hadoop fs -cat /user/cloudera/sqoop_import_data/part-m-00000

hadoop fs -cat /user/cloudera/sqoop_import_data/part-m-00000 | head
hadoop fs -tail /user/cloudera/sqoop_import_data/part-m-00000

hadoop fs -get /user/cloudera/sqoop_import_data/part-m-00000
head part-m-00000

# terminal 1
mysql -u retail_dba -p -D retail_db
show tables;
select * from products;

# terminal 2
sqoop import \
--connect jdbc:mysql://localhost/retail_db \
--table products \
--username retail_dba \
--password cloudera \
--target-dir /user/cloudera/sqoop_products \
-m 1

hadoop fs -ls /user/cloudera/sqoop_products

hadoop fs -cat /user/cloudera/sqoop_products/part-m-00000

hadoop fs -cat /user/cloudera/sqoop_products/part-m-00000 | head
hadoop fs -tail /user/cloudera/sqoop_products/part-m-00000

rm -rf part-m-00000
hadoop fs -get /user/cloudera/sqoop_products/part-m-00000
head part-m-00000
