Home » Open Source » NoSQL » Latest month Partition in hive (Hadoop)
Latest month Partition in hive [message #681546] Wed, 29 July 2020 11:39
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
Hi Guys
I have a table in hive that holds daily date partition column

[code][
My_tab
part_col
2020-03-31
2020-03-30
2020-03-29
2020-04-30
2020-04-29
2020-04-28

/code]
I need the latest partition value i.e. 2020-03-30 reason being 2020-03-31 doesn't hold data. So latest month partition that holds data if i pass 2020-03 i.e.(YYYY-MM)
Previous Topic: Beginer to Big Data & Hadoop
Goto Forum:
  


Current Time: Thu Mar 28 15:43:59 CDT 2024