- Command to change the default property during runtime to deal with non-numeric field
sqoop import -Dorg.apache.sqoop.splitter.allow_text_splitter=true --connect jdbc:mysql://ms.itversity.com:3306/nyse --username nyse_user --password itversity --table stock_eod --warehouse-dir /user/training/sqoop_import/nyse --delete-target-dir
- Command to validate imported data
hadoop fs -ls /user/training/sqoop_import/nyse/stock_eodhadoop fs -tail /user/training/sqoop_import/nyse/stock_eod/part-m-00003