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)

Report message to a moderator

Previous Topic: Beginer to Big Data & Hadoop
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 01 03:49:36 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.