Data Contains unique IDs with different latitudes and longitudes on multiple timestamps.I would like to select the rows of latest 30 days of coordinates for each unique ID.Please help me on how to run the query .This date is in Hive table,below is the sample data. Regards, Akshay ID DATE Latitude Longittude 1 8/22/2020 40.73 -73.78 1 8/22/2020 9:11 40.76 -74.55 1 8/21/2020 10:11 40.71 -73.56 2 2/18/2019 3:12 15.71 24.45 2 2/18/2019 6:12 16.44 24.35 2 2/17/2019 6:12 11.45 23.98 3 2/15/2018 6:12 76.87 68.22 3 2/16/2018 7:32 76.43 67.45 3 2/18/2018 8:42 76.44 67.4 ... View more