@Ann A You can use the concept of time window. These two links may help you: http://blog.madhukaraphatak.com/introduction-to-spark-two-part-5/ https://stackoverflow.com/questions/37632238/how-to-group-by-time-interval-in-spark-sql ... View more