Cheat CodeALTER TABLE mydatabase.mysupertable_agg DROP IF EXISTS PARTITION(month_partitionkey = ‘__HIVE_DEFAULT_PARTITION__’); Another amazing day.We have been almost 1 year with Hive as main big data engine, and everything was smooth as baby bum.This morning, out of the blue (why blue? I wonder)… my dashboard looks damn weird. I have strange month start appearing on the chart,Continue reading “Hive Drop Partition”
Tag Archives: Partition
Refresh Hive Partition
Cheat CodeMSCK REPAIR TABLE mydatabase.table_name We added partitions to our external table to manage our data easily. Multiple folders are set on our data lake.How can we refresh the hive to know new partitions are added? Quite Simple! run the cheat code above and voila the hive partition is updated!don’t worry it wont messed upContinue reading “Refresh Hive Partition”
My IT Cheat Code 