I need to fetch all records from a table in hive which is having latest partitions. The table is partitioned by date,year,month eg (date=25,year=2020,month=3), likewise there will be many partitions.
The partitions are not static and it will be changing frequently. I am trying to handle of getting the latest partition in the query. Can anybody help me to write the query?
