question Fetch LAST MODIFIED data using NiFi in Support Questions

question Fetch LAST MODIFIED data using NiFi in Support Questions https://community.cloudera.com/t5/Support-Questions/Fetch-LAST-MODIFIED-data-using-NiFi/m-p/231281#M193125 Hi,I am trying to look at different processor but somehow couldn't find the best match to my Use Case.My Use Case is I want to fetch the table from the Oracle SQL and put this data into Hive. And I want to run a customized SQL query against the OracleDB and fetched the data but it is fetching the complete data but I want just the LAST MODIFIED data only. For This I am using GenerateTableFetch-- > ExecuteSQL --> PutHiveStreaming. But Execute SQL is pulling the complete data from OracleDB but not just the LAST MODIFIED. Is there any way where I am doing wrong ? My idea is to ExecuteSQL --> SplitAvro --> PutHiveStreaming not sure if this works or not. Wed, 20 Jun 2018 04:18:09 GMT saikrishnamakin 2018-06-20T04:18:09Z