Cheat Code
ALTER 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, it said __HIVE_DEFAULT_PARTITION__ WHAT ON EARTH IS THAT!?
So…. checked the query that populate this super table and saw nothing new or strange or alien lurking around. Finally found it was due to crazy behavior when we set “hive.vectorized.execution.enabled=true;” CRAP!
anyway, adjusted the code and reload. But this crazy partition still listed on the table, so to remove it we need to drop the partition manually. Just fire the cheat code, remove the folder and all good.
BTW __HIVE_DEFAULT_PARTITION__ appear if your column for the partition is null (your welcome!).
My IT Cheat Code 