The bellow Sqoop job works perfectly fine. Each time when I execute , the last value is appending when new data comes in MySQL. My question is
1) In which location the last-value is getting stored?
2) Can I browse the location of last value?
3) Can I change the location of last value?
sqoop job --create myjob3 \
-- import \
--connect "jdbc:mysql://ip-122-41-11-214:3306/sqoop" \
--username wikihadoop \
--password ABCD1234 \
--target-dir /user/sachin/inDataX3 \
--table sac01 \
--split-by age \
--num-mappers -1 \
--incremental append \
--check-column id \
--last-value 1
I executed this for sqoop
sqoop job --exec myjob3
1) In which location the last-value is getting stored?
It depends on how you are running your import job:
2) Can I browse the location of last value?
3) Can I change the location of last value?
Yes. You can change the location of the metastore where last-value is stored.