Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Retrieving Impala data using SQL, only data records since last poll using the Date/Timestamp

avatar
New Contributor

I want to poll an Impala table using SQL queries and only want to retrieve data records added since I last polled. This would be using a Date/Timestamp column in the table. Does anyone know how to achieve this?

I am happy to hold the last Date/Timestamp retrieved, in my source system

2 REPLIES 2

avatar

Hi @StuartM , I know it's not a direct answer, but this requirement sounds more like a good call for Kafka - which inherently supports the idea of "consumer offsets".

avatar
Community Manager

@StuartM, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: