Hello Durga Sir,
I was watching the 04Sqoop import video and was trying to play with my virtual machine which has a database called loudacre and underwhich I created something called sqoop_import and have a directory called customerservicerep. However, after inserting 2 additional rows of data am able to access it only from mysql, but this data is not accessible when I do hdfs dfs -ls or even if I log into hive and look into the databases/tables. All I see are NULL values on the fields.
. I am also attaching a picture of the output of sqoop import with append and with a where clause of acct_num > 2000 (which is what I created).
Can you please let me know how to resolve this?