Yes you can use the QueryDatabaseTable processor for incrementally retrieving data from a relational database table, see this article:
https://community.hortonworks.com/articles/51902/incremental-fetch-in-nifi-with-querydatabasetable.h...
Then you can use PutHDFS to store the data in HDFS.