Incremental append in Sqoop

–1 vote
While studying I came across Incremental append --last-value command

For example, let's say I already imported 'Account' table from RDBMS to HDFS using Sqoop. Now that table in RDBMS has new records and some old records also updated.

So to apply below command to import and append to the existing table we need to know the last value in that table. In real time how does this work?

$Sqoop import --connect jdbc:mysql://localhost/dbname --username uname --password pwd --incremental append --null-non-string --table tablename --target-dir '/location' --check-column colname --last-value number

Once we import to HDFS we can't delete records as per my understanding, so are we going to keep a flag to identify terminated or new or modified records

Please help to understand this.
Dec 31, 2018 in Big Data Hadoop by digger
• 26,550 points
348 views

1 answer to this question.

0 votes

You are right. As Hadoop follows WORM principle i.e write once and read many times. So, once the data gets uploaded to HDFS then it cannot be deleted or terminated anymore.

append is used when rows in a source table in DB get inserted regularly and the table must have a numeric primary key, if not then a numeric –split-by column that is used in absence of the numeric primary key. And that's how we keep track of the last value in the table. For e.g.

$sqoop import –connect jdbc://mysql:/localhost/DB_name –user username –password pasword –table tablename –incremental append –check-column colname –last-value 100

answered Dec 31, 2018 by Omkar
• 67,660 points

Related Questions In Big Data Hadoop

+1 vote
1 answer

What is the process to perform an incremental data load in Sqoop?

The process to perform incremental data load ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Frankie
• 9,810 points
472 views
0 votes
1 answer

Creating testjob in sqoop for incremental load

Yes, it is possible to do so. ...READ MORE

answered Jul 5 in Big Data Hadoop by Umar
35 views
0 votes
1 answer

Could not find the Sqoop directory in HDP 2.2

You can find the Sqoop lib directory ...READ MORE

answered May 4, 2018 in Big Data Hadoop by Shubham
• 13,300 points
284 views
0 votes
1 answer

Synchronizing sqoop imported data in HDFS

Data can be synchronised using incremental parameter ...READ MORE

answered Jul 19, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
135 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,710 points
3,320 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,710 points
394 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,353 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,193 views
0 votes
1 answer

Sqoop incremental append by date

Consider a table with 3 records which ...READ MORE

answered Feb 19 in Big Data Hadoop by Omkar
• 67,660 points
562 views
0 votes
3 answers

How to change the delimiter in Sqoop?

--fields-terminated-by <char> READ MORE

answered Jun 25 in Big Data Hadoop by anonymous
1,819 views